pgsql-hackers since 2022-04-26 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)

Browse Archives

Prev | Next

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
AW: BUG #17448: In Windows 10, version 1703 and later, huge_pages doesn't work. Wilm Hoyer 09:31
RE: Logical replication timeout problem [email protected] 10:01
Re: Logical replication timeout problem 📎 Amit Kapila 10:25
Re: Multi-Master Logical Replication Yura Sokolov 10:54
RE: Skipping schema changes in publication [email protected] 11:20
Re: Skipping schema changes in publication Amit Kapila 11:31
src / test / regress / sql / triggers.sql first 10 lines. alias 11:50
Re: Multi-Master Logical Replication vignesh C 12:07
Re: bogus: logical replication rows/cols combinations Peter Eisentraut 12:13
Re: bogus: logical replication rows/cols combinations Peter Eisentraut 12:26
Re: json_query - redundant result Andrew Dunstan 13:49
Re: src / test / regress / sql / triggers.sql first 10 lines. Tom Lane 13:55
Re: json_query - redundant result Tom Lane 14:00
Re: json_query - redundant result Pavel Stehule 14:06
Re: Dump/Restore of non-default PKs Peter Eisentraut 14:09
Re: json_query - redundant result Andrew Dunstan 14:20
Re: bogus: logical replication rows/cols combinations 📎 Tomas Vondra 15:35
Re: Unstable tests for recovery conflict handling Mark Dilger 15:42
[PATCH] Completed unaccent dictionary with many missing characters 📎 Przemysław Sztoch 16:50
Re: Re: fix cost subqueryscan wrong parallel cost Robert Haas 16:53
Re: Handle infinite recursion in logical replication setup 📎 vignesh C 17:04
Re: Handle infinite recursion in logical replication setup vignesh C 17:07
Re: bogus: logical replication rows/cols combinations Tomas Vondra 17:30
Re: json_object returning jsonb reuslt different from returning json, returning text Andrew Dunstan 19:35
Missing can't-assign-to-constant checks in plpgsql 📎 Tom Lane 21:52
Re: Missing can't-assign-to-constant checks in plpgsql Pavel Stehule 22:11

April 29, 2022

Thread Author Time
Re: Re: fix cost subqueryscan wrong parallel cost 📎 David G. Johnston 01:30
RE: Perform streaming logical transactions by background workers and parallel apply 📎 [email protected] 02:06
Re: Handle infinite recursion in logical replication setup Peter Smith 02:37
Re: Multi-Master Logical Replication Yura Sokolov 04:16
Re: bogus: logical replication rows/cols combinations Amit Kapila 04:48
Re: bogus: logical replication rows/cols combinations Amit Kapila 05:05
Re: pgsql: Add contrib/pg_walinspect. 📎 Bharath Rupireddy 05:16
RE: Perform streaming logical transactions by background workers and parallel apply 📎 [email protected] 05:22
RE: Logical replication timeout problem 📎 [email protected] 05:35
Re: SQL JSON compliance Peter Eisentraut 08:13
Re: Re: fix cost subqueryscan wrong parallel cost Richard Guo 08:35
Re: Multi-Master Logical Replication Peter Smith 09:05
Re: Add WAL recovery messages with log_wal_traffic GUC (was: add recovery, backup, archive, streaming etc. activity messages to server logs along with ps display) 📎 Bharath Rupireddy 09:10
add log messages when replication slots become active and inactive (was Re: Is it worth adding ReplicationSlot active_pid to ReplicationSlotPersistentData?) 📎 Bharath Rupireddy 09:59
Re: add log messages when replication slots become active and inactive (was Re: Is it worth adding ReplicationSlot active_pid to ReplicationSlotPersistentData?) Alvaro Herrera 10:32
Re: Multi-Master Logical Replication vignesh C 10:38
Re: Add WAL recovery messages with log_wal_traffic GUC (was: add recovery, backup, archive, streaming etc. activity messages to server logs along with ps display) Alvaro Herrera 10:41
Re: Handle infinite recursion in logical replication setup 📎 vignesh C 11:01
Re: Skipping schema changes in publication 📎 vignesh C 11:42
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 12:08
Re: Building Postgres with lz4 on Visual Studio Andrew Dunstan 12:50
Re: Building Postgres with lz4 on Visual Studio 📎 Andrew Dunstan 12:59
Re: SQL JSON compliance Andrew Dunstan 13:11
Re: Assorted small doc patches David G. Johnston 13:52
Re: fix cost subqueryscan wrong parallel cost Tom Lane 14:02
Re: fix cost subqueryscan wrong parallel cost David G. Johnston 14:39
Re: fix cost subqueryscan wrong parallel cost Tom Lane 14:54
Re: fix cost subqueryscan wrong parallel cost 📎 Tom Lane 15:53
Re: Support logical replication of DDLs 📎 Zheng Li 17:34
Re: [RFC] building postgres with meson -v8 Andres Freund 17:46
Re: [RFC] building postgres with meson -v8 Andres Freund 18:00
Re: fix cost subqueryscan wrong parallel cost Tom Lane 18:09
Re: allow specifying action when standby encounters incompatible parameter settings Cary Huang 18:35
Re: fix cost subqueryscan wrong parallel cost David G. Johnston 19:06
Re: Use standard SIGHUP and SIGTERM handlers in autoprewarm module Andres Freund 19:18
Re: fix cost subqueryscan wrong parallel cost Tom Lane 19:31
Re: fix cost subqueryscan wrong parallel cost 📎 Tom Lane 19:38
Re: failures in t/031_recovery_conflict.pl on CI 📎 Andres Freund 20:08
Re: [RFC] building postgres with meson -v8 Andres Freund 20:11
Re: fix cost subqueryscan wrong parallel cost David G. Johnston 20:29
Re: bogus: logical replication rows/cols combinations Tomas Vondra 20:31
Re: failures in t/031_recovery_conflict.pl on CI Tom Lane 23:26

April 30, 2022

Thread Author Time
Re: bogus: logical replication rows/cols combinations Amit Kapila 01:20

Browse Archives

Prev | Next