pgsql-hackers since 2022-04-23 00:00

The PostgreSQL developers team lives here. Discussion of current development issues, problems and bugs, and proposed new features. If your question cannot be answered by people in the other lists, and it is likely that only a developer will know the answer, you may re-post your question in this list. You must try elsewhere first!

Search the Archives

(enter a message-id to go directly to that message)
Advanced Search

Browse Archives

Prev | Next
Jump to day: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30

April 23, 2022

Thread Author Time
Re: pgsql: Allow db.schema.table patterns, but complain about random garbag Noah Misch 02:59
Re: [Proposal] vacuumdb --schema only 📎 Nathan Bossart 05:57
Re: Implementing Incremental View Maintenance Greg Stark 06:18
multirange of arrays not working on postgresql 14 Jian He 06:26
Re: Throttling WAL inserts when the standby falls behind more than the configured replica_lag_in_bytes Bharath Rupireddy 06:59
Re: multirange of arrays not working on postgresql 14 David G. Johnston 07:03
Re: [Patch] ALTER SYSTEM READ ONLY Bharath Rupireddy 08:03
Re: [PATCH] Teach pg_waldump to extract FPIs from the WAL Alvaro Herrera 13:39
Re: [PATCH] Teach pg_waldump to extract FPIs from the WAL Matthias van de Meent 14:49
Re: [PATCH] Allow multiple recursive self-references Tom Lane 15:14
Re: [PATCH] Teach pg_waldump to extract FPIs from the WAL 📎 David Christensen 18:43
Re: Cryptohash OpenSSL error queue in FIPS enabled builds Daniel Gustafsson 21:40

April 24, 2022

Thread Author Time
Re: Use generation context to speed up tuplesorts Noah Misch 00:59
Re: Use generation context to speed up tuplesorts Peter Geoghegan 01:11
Re: Why is EXECUTE granted to PUBLIC for all routines? Isaac Morland 02:43
Re: Use generation context to speed up tuplesorts David Rowley 05:16
RE: Data is copied twice when specifying both child and parent table in publication 📎 [email protected] 06:16
Re: pgsql: Allow db.schema.table patterns, but complain about random garbag Andrew Dunstan 17:09
Re: pgsql: Allow db.schema.table patterns, but complain about random garbag Noah Misch 18:19
Re: pgsql: Allow db.schema.table patterns, but complain about random garbag Andrew Dunstan 19:37
Re: [RFC] building postgres with meson -v8 Andrew Dunstan 19:44

April 25, 2022

Thread Author Time
Re: Estimating HugePages Requirements? Michael Paquier 00:15
Re: Cryptohash OpenSSL error queue in FIPS enabled builds Michael Paquier 00:50
Re: pg_receivewal fail to streams when the partial file to write is not fully initialized present in the wal receiver directory Michael Paquier 01:08
Re: [PATCH] Add native windows on arm64 support Michael Paquier 01:17
RE: Data is copied twice when specifying both child and parent table in publication [email protected] 01:23
Re: [Proposal] vacuumdb --schema only 📎 Nathan Bossart 01:27
Re: Defer selection of asynchronous subplans until the executor initialization stage 📎 Etsuro Fujita 04:29
json_object returning jsonb reuslt different from returning json, returning text alias 05:11
Re: json_object returning jsonb reuslt different from returning json, returning text alias 05:19
Re: [PATCH] Teach pg_waldump to extract FPIs from the WAL Michael Paquier 06:11
Re: why pg_walfile_name() cannot be executed during recovery? Andrey Borodin 06:18
Re: TRAP: FailedAssertion("tabstat->trans == trans", File: "pgstat_relation.c", Line: 508 Michael Paquier 06:18
Re: [Proposal] vacuumdb --schema only Gilles Darold 06:50
Re: [PATCH] Teach pg_waldump to extract FPIs from the WAL Drouvot, Bertrand 07:00
Re: A problem about partitionwise join 📎 Richard Guo 07:21
variable filename for psql \copy Jiří Fejfar 08:24
RE: Perform streaming logical transactions by background workers and parallel apply [email protected] 08:35
Re: variable filename for psql \copy Daniel Verite 10:24
Re: [PATCH] Teach pg_waldump to extract FPIs from the WAL Bharath Rupireddy 11:03
Re: pg_receivewal fail to streams when the partial file to write is not fully initialized present in the wal receiver directory Bharath Rupireddy 11:47
Re: tweak to a few index tests to hits ambuildempty() routine. Alvaro Herrera 13:05
Re: [PATCH] Compression dictionaries for JSONB 📎 Aleksander Alekseev 13:15
Re: tweak to a few index tests to hits ambuildempty() routine. Alvaro Herrera 13:34
Re: tweak to a few index tests to hits ambuildempty() routine. Alvaro Herrera 13:53
Re: tweak to a few index tests to hits ambuildempty() routine. Amul Sul 13:57
Re: tweak to a few index tests to hits ambuildempty() routine. Tom Lane 14:05
Re: json_object returning jsonb reuslt different from returning json, returning text 📎 Andrew Dunstan 14:14
An attempt to avoid locally-committed-but-not-replicated-to-standby-transactions in synchronous replication 📎 Bharath Rupireddy 14:21
Re: Estimating HugePages Requirements? Magnus Hagander 14:55
Re: [PATCH] Teach pg_waldump to extract FPIs from the WAL David Christensen 15:11
Re: [PATCH] Teach pg_waldump to extract FPIs from the WAL David Christensen 15:12
Re: [PATCH] Teach pg_waldump to extract FPIs from the WAL David Christensen 15:24
Move Section 9.27.7 (Data Object Management Functions) to System Information Chapter David G. Johnston 15:33
bogus: logical replication rows/cols combinations Alvaro Herrera 15:48
Re: variable filename for psql \copy David G. Johnston 16:07
Re: [Proposal] vacuumdb --schema only Nathan Bossart 16:18
Re: An attempt to avoid locally-committed-but-not-replicated-to-standby-transactions in synchronous replication Nathan Bossart 16:48
Re: proposal: possibility to read dumped table's name from file 📎 Pavel Stehule 17:39
Re: WIP: WAL prefetch (another approach) Tom Lane 18:11
Re: WIP: WAL prefetch (another approach) Tom Lane 18:31
Re: pg_walcleaner - new tool to detect, archive and delete the unneeded wal files (was Re: pg_archivecleanup - add the ability to detect, archive and delete the unneeded wal files on the primary) Stephen Frost 18:39
Re: pgsql: Allow db.schema.table patterns, but complain about random garbag Andrew Dunstan 18:57
Re: Use "WAL segment" instead of "log segment" consistently in user-facing messages Nathan Bossart 19:54
Re: Add --{no-,}bypassrls flags to createuser Nathan Bossart 20:19
Re: add checkpoint stats of snapshot and mapping files of pg_logical dir Nathan Bossart 20:34
Re: Cryptohash OpenSSL error queue in FIPS enabled builds 📎 Daniel Gustafsson 22:07
Re: bogus: logical replication rows/cols combinations Tomas Vondra 22:30
Re: Cryptohash OpenSSL error queue in FIPS enabled builds Tom Lane 22:44

April 26, 2022

Thread Author Time
Re: add checkpoint stats of snapshot and mapping files of pg_logical dir Michael Paquier 01:01
Re: Estimating HugePages Requirements? Michael Paquier 01:34
Re: Skipping schema changes in publication Peter Smith 01:55
Re: Cryptohash OpenSSL error queue in FIPS enabled builds Michael Paquier 01:55
Re: Building Postgres with lz4 on Visual Studio Michael Paquier 02:19
Re: [Proposal] vacuumdb --schema only Michael Paquier 02:36
Re: [PATCH] Teach pg_waldump to extract FPIs from the WAL Michael Paquier 02:42
Re: [PATCH] Teach pg_waldump to extract FPIs from the WAL Michael Paquier 02:53
Re: [Proposal] vacuumdb --schema only 📎 Nathan Bossart 04:46
Re: BUG #17448: In Windows 10, version 1703 and later, huge_pages doesn't work. Julien Rouhaud 04:54
Re: pgsql: Add contrib/pg_walinspect. Michael Paquier 05:13
Re: CLUSTER on partitioned index Michael Paquier 05:17
Re: Making JIT more granular 📎 David Rowley 05:24
Re: pgsql: Add contrib/pg_walinspect. Tom Lane 05:25
Re: CLUSTER on partitioned index Alvaro Herrera 05:28
Re: pgsql: Add contrib/pg_walinspect. Michael Paquier 05:36
RE: Skipping schema changes in publication [email protected] 06:02
Re: WIP: WAL prefetch (another approach) Thomas Munro 06:11
Re: An attempt to avoid locally-committed-but-not-replicated-to-standby-transactions in synchronous replication Laurenz Albe 06:26
Fix primary crash continually with invalid checkpoint after promote 📎 Zhao Rui 07:16
Re: Perform streaming logical transactions by background workers and parallel apply vignesh C 07:18
Wrong rows count in EXPLAIN Пантюшин Александр Иванович 08:45
range of composite types! Jian He 09:16
Re: An attempt to avoid locally-committed-but-not-replicated-to-standby-transactions in synchronous replication Andrey Borodin 11:22
Re: variable filename for psql \copy Jiří Fejfar 11:55
double inclusion of '-p' flex flag Ashutosh Sharma 12:16
orafce: some of the build time generated files are not present in .gitignore and also checked into the repository Ashutosh Sharma 12:19
Re: orafce: some of the build time generated files are not present in .gitignore and also checked into the repository Daniel Gustafsson 12:21
Re: double inclusion of '-p' flex flag John Naylor 12:25
Re: [Patch] ALTER SYSTEM READ ONLY Amul Sul 12:43
Re: XID formatting and SLRU refactorings (was: Add 64-bit XIDs into PostgreSQL 15) 📎 Aleksander Alekseev 12:55
Re: double inclusion of '-p' flex flag Ashutosh Sharma 12:58
Re: orafce: some of the build time generated files are not present in .gitignore and also checked into the repository Ashutosh Sharma 13:04
Re: Cryptohash OpenSSL error queue in FIPS enabled builds Daniel Gustafsson 13:15
Re: orafce: some of the build time generated files are not present in .gitignore and also checked into the repository Pavel Stehule 16:17
Re: orafce: some of the build time generated files are not present in .gitignore and also checked into the repository Bruce Momjian 16:36
Re: orafce: some of the build time generated files are not present in .gitignore and also checked into the repository Pavel Stehule 16:42
Re: DBT-5 Stored Procedure Development (2022) Mark Wong 17:36
Re: DBT-5 Stored Procedure Development (2022) Peter Geoghegan 17:44
Re: [PATCH] Teach pg_waldump to extract FPIs from the WAL David Christensen 18:13
Re: [PATCH] Teach pg_waldump to extract FPIs from the WAL David Christensen 18:15
Re: Fix primary crash continually with invalid checkpoint after promote Nathan Bossart 18:16
Re: Possible corruption by CreateRestartPoint at promotion Nathan Bossart 18:33
Re: Fix primary crash continually with invalid checkpoint after promote Tom Lane 19:47
Re: avoid multiple hard links to same WAL file after a crash 📎 Nathan Bossart 20:09
Re: Building Postgres with lz4 on Visual Studio Robert Haas 20:26

April 27, 2022

Thread Author Time
Re: pgsql: Add contrib/pg_walinspect. 📎 Thomas Munro 00:06
Re: WIP: WAL prefetch (another approach) Thomas Munro 00:10
Re: pgsql: Add contrib/pg_walinspect. Tom Lane 00:25
Re: pgsql: Add contrib/pg_walinspect. Thomas Munro 01:10
Re: [PATCH] Teach pg_waldump to extract FPIs from the WAL Michael Paquier 01:25
Re: Possible corruption by CreateRestartPoint at promotion 📎 Kyotaro Horiguchi 01:43
Re: pgsql: Add contrib/pg_walinspect. 📎 Tom Lane 01:47
Re: pgsql: Add contrib/pg_walinspect. Thomas Munro 01:54
Re: pgsql: Add contrib/pg_walinspect. Tom Lane 01:55
Re: pgsql: Add contrib/pg_walinspect. Thomas Munro 02:10
Re: pgsql: Add contrib/pg_walinspect. 📎 Tom Lane 02:14
Re: pgsql: Add contrib/pg_walinspect. Tom Lane 02:15
Re: Fix primary crash continually with invalid checkpoint after promote Kyotaro Horiguchi 02:24
Re: Fix primary crash continually with invalid checkpoint after promote Michael Paquier 03:00
Re: pgsql: Add contrib/pg_walinspect. Tom Lane 03:15
Re: Possible corruption by CreateRestartPoint at promotion Nathan Bossart 03:26
Re: pgsql: Add contrib/pg_walinspect. Bharath Rupireddy 03:27
Re:Possible corruption by CreateRestartPoint at promotion 📎 Rui Zhao 04:36
Re: bogus: logical replication rows/cols combinations Amit Kapila 04:55
Fwd: range of composite types! Jian He 05:03
Re: Possible corruption by CreateRestartPoint at promotion Michael Paquier 05:16
Re: Fwd: range of composite types! Tom Lane 05:26
Re: Possible corruption by CreateRestartPoint at promotion Michael Paquier 05:27
Re: range of composite types! David G. Johnston 05:29
Re: Possible corruption by CreateRestartPoint at promotion Tom Lane 05:31
Re: Handle infinite recursion in logical replication setup Peter Smith 05:45
Re: bogus: logical replication rows/cols combinations Michael Paquier 06:12
Re: avoid multiple hard links to same WAL file after a crash Michael Paquier 07:09
Re: Fix NULL pointer reference in _outPathTarget() Peter Eisentraut 07:17
Re: BUG #17448: In Windows 10, version 1703 and later, huge_pages doesn't work. Michael Paquier 08:13
Re: pgsql: Add contrib/pg_walinspect. Bharath Rupireddy 08:17
Re: Wrong rows count in EXPLAIN Andrey Borodin 09:08
Re: bogus: logical replication rows/cols combinations Alvaro Herrera 09:43
Re: bogus: logical replication rows/cols combinations Alvaro Herrera 09:53
Re: BUG #17448: In Windows 10, version 1703 and later, huge_pages doesn't work. Magnus Hagander 10:01
RE: bogus: logical replication rows/cols combinations [email protected] 10:08
Re: Wrong rows count in EXPLAIN Пантюшин Александр Иванович 10:17
Re: pgsql: Add contrib/pg_walinspect. 📎 Bharath Rupireddy 10:22
Re: bogus: logical replication rows/cols combinations Amit Kapila 10:33
Re: Wrong rows count in EXPLAIN Andrey Borodin 10:39
Re: Wrong rows count in EXPLAIN David Rowley 10:43
Re: bogus: logical replication rows/cols combinations Alvaro Herrera 10:57
Re: bogus: logical replication rows/cols combinations Amit Kapila 11:48
[PATCH v1] remove redundant check of item pointer Junwang Zhao 12:04
Re: Skipping schema changes in publication 📎 vignesh C 12:50
Re: Wrong rows count in EXPLAIN Tom Lane 13:44
Re: Wrong rows count in EXPLAIN Bruce Momjian 13:51
cirrus: run macos with COPY_PARSE_PLAN_TREES etc Justin Pryzby 14:53
AW: BUG #17448: In Windows 10, version 1703 and later, huge_pages doesn't work. Wilm Hoyer 15:04
remove redundant check of item pointer 📎 Junwang Zhao 15:11
Re: remove redundant check of item pointer Tom Lane 15:34
Unstable tests for recovery conflict handling Tom Lane 16:45
Re: BUG #17448: In Windows 10, version 1703 and later, huge_pages doesn't work. Julien Rouhaud 16:48
Re: BUG #17448: In Windows 10, version 1703 and later, huge_pages doesn't work. Julien Rouhaud 16:52
Re: Unstable tests for recovery conflict handling Mark Dilger 17:11
Re: pgsql: Add contrib/pg_walinspect. Jeff Davis 17:30
Re: Unstable tests for recovery conflict handling Mark Dilger 17:50
Re: Unstable tests for recovery conflict handling Tom Lane 18:08
Re: Possible corruption by CreateRestartPoint at promotion Nathan Bossart 18:09
Re: avoid multiple hard links to same WAL file after a crash 📎 Nathan Bossart 18:42
Re: [RFC] building postgres with meson -v8 📎 Peter Eisentraut 19:56
Re: bogus: logical replication rows/cols combinations 📎 Tomas Vondra 21:56
Multi-Master Logical Replication 📎 Peter Smith 23:49

April 28, 2022

Thread Author Time
Re: pgsql: Add contrib/pg_walinspect. Thomas Munro 00:11
Re: Possible corruption by CreateRestartPoint at promotion Michael Paquier 00:12
trivial comment fix 📎 Euler Taveira 00:27
RE: Data is copied twice when specifying both child and parent table in publication [email protected] 01:22
Re: Unstable tests for recovery conflict handling Andres Freund 01:26
Re: Unstable tests for recovery conflict handling Andres Freund 01:31
Re: remove redundant check of item pointer Junwang Zhao 01:54
Re: Handle infinite recursion in logical replication setup Peter Smith 02:27
Re: trivial comment fix John Naylor 02:32
Re: Possible corruption by CreateRestartPoint at promotion Kyotaro Horiguchi 02:39
Re: Possible corruption by CreateRestartPoint at promotion Kyotaro Horiguchi 02:43
Re: Possible corruption by CreateRestartPoint at promotion Kyotaro Horiguchi 02:50
Re: pgsql: Add contrib/pg_walinspect. Jeff Davis 03:11
Re: bogus: logical replication rows/cols combinations Amit Kapila 03:17
Re: avoid multiple hard links to same WAL file after a crash Michael Paquier 05:56
Re: Add --{no-,}bypassrls flags to createuser 📎 Shinya Kato 06:06
Re: Defer selection of asynchronous subplans until the executor initialization stage Etsuro Fujita 06:32
Re: Implementing Incremental View Maintenance Yugo NAGATA 06:40
Re: Multi-Master Logical Replication Laurenz Albe 06:48
Re: Possible corruption by CreateRestartPoint at promotion Michael Paquier 06:49
json_query - redundant result Pavel Stehule 08:16
RE: Multi-Master Logical Replication [email protected] 08:34

Browse Archives

Prev | Next
Jump to day: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30