pgsql-hackers since 2022-04-22 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 22, 2022

Thread Author Time
Re: Replace open mode with PG_BINARY_R/W/A macros Japin Li 01:51
Re: Implementing Incremental View Maintenance πŸ“Ž Yugo NAGATA 02:29
Re: Replace open mode with PG_BINARY_R/W/A macros Tom Lane 03:21
Re: fix cost subqueryscan wrong parallel cost bucoo 03:35
Re: Perform streaming logical transactions by background workers and parallel apply Peter Smith 04:12
Re: A qsort template David Rowley 04:13
Re: A qsort template John Naylor 04:37
Allow specifying column list for foreign key ON DELETE SET src_test_regress_sql_foreign_key.sql don't understand the comment. alias 05:06
Re: A qsort template Thomas Munro 05:10
Re: Implementing Incremental View Maintenance πŸ“Ž Yugo NAGATA 05:58
Re: wrong fds used for refilenodes after pg_upgrade relfilenode changes Reply-To: πŸ“Ž Thomas Munro 07:37
Re: Estimating HugePages Requirements? Magnus Hagander 07:49
[PATCH] Compression dictionaries for JSONB πŸ“Ž Aleksander Alekseev 08:30
Re: RFC: compression dictionaries for JSONB Aleksander Alekseev 08:33
Re: BufferAlloc: don't take two simultaneous locks πŸ“Ž Yura Sokolov 08:49
Re: [Proposal] vacuumdb --schema only πŸ“Ž Gilles Darold 09:57
Re: Proposal for internal Numeric to Uint64 conversion function. πŸ“Ž Amul Sul 12:26
Re: pgsql: Allow db.schema.table patterns, but complain about random garbag Andrew Dunstan 13:15
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) Bharath Rupireddy 13:37
Re: Dump/Restore of non-default PKs Peter Eisentraut 13:38
Re: pg_receivewal fail to streams when the partial file to write is not fully initialized present in the wal receiver directory Bharath Rupireddy 13:47
Re: How to generate a WAL record spanning multiple WAL files? Bharath Rupireddy 14:02
Re: pgsql: Allow db.schema.table patterns, but complain about random garbag Tom Lane 14:04
Re: Dump/Restore of non-default PKs Tom Lane 14:14
Re: why pg_walfile_name() cannot be executed during recovery? Bharath Rupireddy 14:15
Re: Fix NULL pointer reference in _outPathTarget() Peter Eisentraut 14:16
Re: Fix NULL pointer reference in _outPathTarget() Tom Lane 14:18
Re: How to simulate sync/async standbys being closer/farther (network distance) to primary in core postgres? Bharath Rupireddy 14:23
Re: pgsql: Allow db.schema.table patterns, but complain about random garbag Andrew Dunstan 14:24
Cryptohash OpenSSL error queue in FIPS enabled builds πŸ“Ž Daniel Gustafsson 14:56
Re: [PATCH] Compression dictionaries for JSONB Zhihong Yu 15:21
Re: Re: fix cost subqueryscan wrong parallel cost David G. Johnston 15:55
Re: Skipping schema changes in publication Bharath Rupireddy 16:09
Re: Handle infinite recursion in logical replication setup πŸ“Ž vignesh C 16:15
Re: Handle infinite recursion in logical replication setup vignesh C 16:23
Re: Handle infinite recursion in logical replication setup vignesh C 16:28
Re: Cryptohash OpenSSL error queue in FIPS enabled builds Tom Lane 17:01
Why is EXECUTE granted to PUBLIC for all routines? Jacek Trocinski 17:31
Re: Why is EXECUTE granted to PUBLIC for all routines? Tom Lane 17:44
Re: Postgres perl module namespace Andres Freund 18:36
Re: Building Postgres with lz4 on Visual Studio Andres Freund 19:54
Re: pgsql: Allow db.schema.table patterns, but complain about random garbag Robert Haas 20:06
Re: pgsql: Allow db.schema.table patterns, but complain about random garbag Thomas Munro 21:12
[PATCH] Teach pg_waldump to extract FPIs from the WAL πŸ“Ž David Christensen 22:51

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 πŸ“Ž wangw.fnst@fujitsu.com 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 wangw.fnst@fujitsu.com 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 houzj.fnst@fujitsu.com 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 osumi.takamichi@fujitsu.com 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 houzj.fnst@fujitsu.com 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

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