pgsql-hackers since 2024-01-11 13:44

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

Jan. 11, 2024

Thread	Author	Time
Re: Postgres Partitions Limitations (5.11.2.3)	Magnus Hagander	13:44
Re: Slightly improved meson error for docs tools	Magnus Hagander	13:56
Re: Error "initial slot snapshot too large" in create replication slot	vignesh C	14:11
Re: odd buildfarm failure - "pg_ctl: control file appears to be corrupt"	vignesh C	14:20
Re: Set log_lock_waits=on by default 📎	Michael Banck	14:24
Re: Assertion failure in SnapBuildInitialSnapshot()	vignesh C	14:25
Re: Show WAL write and fsync stats in pg_stat_io	Melanie Plageman	14:27
Re: Issue in postgres_fdw causing unnecessary wait for cancel request reply	vignesh C	14:30
Re: Streaming I/O, vectored I/O (WIP)	Heikki Linnakangas	14:31
Re: SQL:2011 application time	Peter Eisentraut	14:44
Re: heavily contended lwlocks with long wait queues scale badly	Jonathan S. Katz	14:47
Re: Test slots invalidations in 035_standby_logical_decoding.pl only if dead rows are removed 📎	Bertrand Drouvot	14:58
Re: A recent message added to pg_upgade	Tom Lane	15:01
Re: Postgres Partitions Limitations (5.11.2.3)	Laurenz Albe	15:05
Re: Should the archiver process always make sure that the timeline history files exist in the archive?	vignesh C	15:08
Re: Wrong results with grouping sets	vignesh C	15:10
Re: [PATCH] LockAcquireExtended improvement	vignesh C	15:21
Re: [BUG] autovacuum may skip tables when session_authorization/role is set on database	vignesh C	15:32
Re: Synchronizing slots from primary to standby	Bertrand Drouvot	15:41
Re: Add new protocol message to change GUCs for usage with future protocol-only GUCs	Jelte Fennema-Nio	16:20
Re: logical decoding and replication of sequences, take 2 📎	Tomas Vondra	16:26
Re: A failure in t/038_save_logical_slots_shutdown.pl	Bharath Rupireddy	16:33
Re: Emit fewer vacuum records by reaping removable tuples during pruning	Robert Haas	16:54
Re: System username in pg_stat_activity	Bertrand Drouvot	16:55
Re: recovery modules 📎	Nathan Bossart	16:56
Suggest two small improvements for PITR. 📎	Yura Sokolov	16:58
Re: Compile warnings in dbcommands.c building with meson	Magnus Hagander	17:00
Re: Stack overflow issue	Robert Haas	17:37
Re: Recovering from detoast-related catcache invalidations 📎	Xiaoran Wang	17:52
pgsql: Add new pg_walsummary tool.	Robert Haas	17:56
Re: cleanup patches for incremental backup	Robert Haas	18:13
Re: Emit fewer vacuum records by reaping removable tuples during pruning	Robert Haas	18:43
Re: pgsql: Add new pg_walsummary tool.	Robert Haas	18:49
Re: pgsql: Add new pg_walsummary tool.	Robert Haas	18:58
Re: Built-in CTYPE provider	Jeff Davis	19:05
buildfarm failures in pg_walsummary checks	Robert Haas	19:12
Re: Emit fewer vacuum records by reaping removable tuples during pruning 📎	Melanie Plageman	19:30
Re: Test slots invalidations in 035_standby_logical_decoding.pl only if dead rows are removed 📎	Alexander Lakhin	20:00
Re: Emit fewer vacuum records by reaping removable tuples during pruning	Robert Haas	21:49
Re: Test slots invalidations in 035_standby_logical_decoding.pl only if dead rows are removed	Michael Paquier	22:01
Re: speed up a logical replica setup 📎	Euler Taveira	22:15
Re: Recovering from detoast-related catcache invalidations	Tom Lane	22:21
Re: speed up a logical replica setup	Euler Taveira	23:00
Re: Streaming I/O, vectored I/O (WIP)	Thomas Munro	23:32
Re: Adding facility for injection points (or probe points?) for more advanced tests	Michael Paquier	23:35
Re: Built-in CTYPE provider	Jeff Davis	23:36
Re: A recent message added to pg_upgade	Michael Paquier	23:37
Re: Confine vacuum skip logic to lazy_scan_skip 📎	Melanie Plageman	23:41
Re: Confine vacuum skip logic to lazy_scan_skip	Melanie Plageman	23:50

Jan. 12, 2024

Thread	Author	Time
Re: Fix log_line_prefix to display the transaction id (%x) for statements not in a transaction block	jian he	00:51
RE: cleanup patches for incremental backup 📎	Shinoda, Noriyoshi (HPE Services Japan - FSIP)	00:58
Re: pgsql: Add support event triggers on authenticated login	Bharath Rupireddy	01:58
Re: Built-in CTYPE provider 📎	Jeff Davis	02:02
Re: Emit fewer vacuum records by reaping removable tuples during pruning	Melanie Plageman	02:04
Re: Error "initial slot snapshot too large" in create replication slot 📎	Kyotaro Horiguchi	02:46
Re: Improve the connection failure error messages	Peter Smith	02:49
Re: pgsql: Add support event triggers on authenticated login 📎	Tom Lane	02:55
Re: initdb --no-locale=C doesn't work as specified when the environment is not C	Kyotaro Horiguchi	02:56
Re: POC PATCH: copy from ... exceptions to: (was Re: VLDB Features) 📎	torikoshia	02:58
Re: Synchronizing slots from primary to standby	Amit Kapila	03:12
Re: speed up a logical replica setup	Amit Kapila	03:35
RE: Synchronizing slots from primary to standby	Zhijie Hou (Fujitsu)	03:46
Re: Recovering from detoast-related catcache invalidations	Xiaoran Wang	03:56
Re: A failure in t/038_save_logical_slots_shutdown.pl	Amit Kapila	03:57
Re: Adding facility for injection points (or probe points?) for more advanced tests	Ashutosh Bapat	04:10
reorganize "Shared Memory and LWLocks" section of docs 📎	Nathan Bossart	04:14
Re: Adding facility for injection points (or probe points?) for more advanced tests 📎	Michael Paquier	04:26
Re: Emit fewer vacuum records by reaping removable tuples during pruning	Michael Paquier	04:35
Re: pub/sub - specifying optional parameters without values. 📎	Peter Smith	05:07
RE: speed up a logical replica setup	Hayato Kuroda (Fujitsu)	05:08
Re: Compile warnings in dbcommands.c building with meson	jian he	05:19
Re: Synchronizing slots from primary to standby	Amit Kapila	05:41
Re: Make COPY format extendable: Extract COPY TO format implementations	Sutou Kouhei	05:46
doc: add LITERAL tag to RETURNING 📎	torikoshia	05:56
Re: doc: add LITERAL tag to RETURNING	Ashutosh Bapat	06:22
RE: speed up a logical replica setup	Hayato Kuroda (Fujitsu)	06:32
Re: Make NUM_XLOGINSERT_LOCKS configurable 📎	Bharath Rupireddy	06:32
Re: Synchronizing slots from primary to standby	Bertrand Drouvot	06:37
Re: Make COPY format extendable: Extract COPY TO format implementations	Junwang Zhao	06:40
Re: Synchronizing slots from primary to standby	Bertrand Drouvot	06:54
Re: Test slots invalidations in 035_standby_logical_decoding.pl only if dead rows are removed 📎	Bertrand Drouvot	07:15
Re: [PoC] Improve dead tuple storage for lazy vacuum	Masahiko Sawada	08:49
plpgsql memory leaks	Pavel Stehule	09:27
Re: alter table add x wrong error position	Alvaro Herrera	09:58
Re: plpgsql memory leaks	Pavel Stehule	10:02
Re: A failure in t/038_save_logical_slots_shutdown.pl	Bharath Rupireddy	10:05
plperl and perl 5.38	Christoph Berg	10:14
RE: speed up a logical replica setup	Hayato Kuroda (Fujitsu)	10:31
Re: tablecmds.c/MergeAttributes() cleanup	Alvaro Herrera	10:32
Re: plpgsql memory leaks	Michael Banck	10:54
Re: Test slots invalidations in 035_standby_logical_decoding.pl only if dead rows are removed 📎	Alexander Lakhin	11:00
Re: Make attstattarget nullable	Alvaro Herrera	11:16
Re: Make attstattarget nullable	Alvaro Herrera	11:27
Re: doc: add LITERAL tag to RETURNING	Alvaro Herrera	11:56
Re: Synchronizing slots from primary to standby	Masahiko Sawada	12:00
Re: Compile warnings in dbcommands.c building with meson	Alvaro Herrera	12:03
Re: Make mesage at end-of-recovery less scary.	Aleksander Alekseev	12:03
Re: Improve the connection failure error messages 📎	Nisha Moond	12:07
Re: Synchronizing slots from primary to standby	shveta malik	12:19
Re: plpgsql memory leaks	Pavel Stehule	12:35
Re: Show WAL write and fsync stats in pg_stat_io	Nazir Bilal Yavuz	13:23
Re: Compile warnings in dbcommands.c building with meson	jian he	13:27
Re: Improve the connection failure error messages	Aleksander Alekseev	13:35
Re: Test slots invalidations in 035_standby_logical_decoding.pl only if dead rows are removed	Bertrand Drouvot	13:46
Re: plpgsql memory leaks	Michael Banck	13:53
Re: reorganize "Shared Memory and LWLocks" section of docs	Aleksander Alekseev	14:12
RE: Synchronizing slots from primary to standby 📎	Zhijie Hou (Fujitsu)	14:21
Re: Emit fewer vacuum records by reaping removable tuples during pruning	Robert Haas	14:43
Re: cleanup patches for incremental backup	Robert Haas	14:50
[PATCH] New predefined role pg_manage_extensions 📎	Michael Banck	14:53
Re: tablecmds.c/MergeAttributes() cleanup	Robert Haas	15:09
Re: Stack overflow issue 📎	Heikki Linnakangas	15:12
Re: [PATCH] New predefined role pg_manage_extensions	Jelte Fennema-Nio	15:13
Re: Make all Perl warnings fatal	Peter Eisentraut	15:33
Re: tablecmds.c/MergeAttributes() cleanup	Tom Lane	15:42
Re: the s_lock_stuck on perform_spin_delay	Robert Haas	15:45
Re: tablecmds.c/MergeAttributes() cleanup	Robert Haas	15:46
Re: reorganize "Shared Memory and LWLocks" section of docs	Nathan Bossart	15:46
Re: Make all Perl warnings fatal	Bharath Rupireddy	15:51
Re: System username in pg_stat_activity 📎	Magnus Hagander	16:16
Re: Error "initial slot snapshot too large" in create replication slot	Robert Haas	16:28
Re: index prefetching 📎	Tomas Vondra	16:42
Re: psql not responding to SIGINT upon db reconnection	Robert Haas	16:45
Re: Emit fewer vacuum records by reaping removable tuples during pruning	Peter Geoghegan	16:50
Re: Report planning memory in EXPLAIN ANALYZE	Alvaro Herrera	16:52
Re: index prefetching	Robert Haas	16:52
Re: Built-in CTYPE provider	Jeff Davis	16:58
Re: Emit fewer vacuum records by reaping removable tuples during pruning	Melanie Plageman	17:03
Re: Custom explain options	Tomas Vondra	17:03
Re: psql not responding to SIGINT upon db reconnection	Tristan Partin	17:13
Re: introduce dynamic shared memory registry 📎	Nathan Bossart	17:21
Re: Report planning memory in EXPLAIN ANALYZE	Abhijit Menon-Sen	17:23
Re: reorganize "Shared Memory and LWLocks" section of docs 📎	Nathan Bossart	17:23
Re: Emit fewer vacuum records by reaping removable tuples during pruning	Melanie Plageman	17:33
Re: introduce dynamic shared memory registry	Abhijit Menon-Sen	17:43
Re: Built-in CTYPE provider	Daniel Verite	18:00
Re: Emit fewer vacuum records by reaping removable tuples during pruning	Peter Geoghegan	18:07
Re: Built-in CTYPE provider	Robert Haas	18:13
Re: Built-in CTYPE provider	Jeff Davis	18:16
Re: speed up a logical replica setup	Nazir Bilal Yavuz	18:32
Re: Emit fewer vacuum records by reaping removable tuples during pruning	Robert Haas	18:45
Re: Emit fewer vacuum records by reaping removable tuples during pruning	Melanie Plageman	18:52
Re: Emit fewer vacuum records by reaping removable tuples during pruning	Melanie Plageman	19:02
Re: Confine vacuum skip logic to lazy_scan_skip	Jim Nasby	19:02
Re: plpgsql memory leaks	Pavel Stehule	19:09
Re: Confine vacuum skip logic to lazy_scan_skip	Melanie Plageman	19:09
Re: Custom explain options	Konstantin Knizhnik	19:30
Re: Emit fewer vacuum records by reaping removable tuples during pruning 📎	Robert Haas	19:32
Re: Emit fewer vacuum records by reaping removable tuples during pruning	Peter Geoghegan	19:43
Re: introduce dynamic shared memory registry	Nathan Bossart	19:45
Re: Emit fewer vacuum records by reaping removable tuples during pruning	Robert Haas	19:47
Re: Extensible storage manager API - SMGR hook Redux 📎	Tristan Partin	19:57
Re: Emit fewer vacuum records by reaping removable tuples during pruning	Peter Geoghegan	20:01
Re: Emit fewer vacuum records by reaping removable tuples during pruning	Melanie Plageman	20:04
Re: Recovering from detoast-related catcache invalidations 📎	Tom Lane	20:14
Re: Emit fewer vacuum records by reaping removable tuples during pruning	Robert Haas	20:22
Re: Invalidate the subscription worker in cases where a user loses their superuser status	Jeff Davis	20:32
cfbot is failing all tests on FreeBSD/Meson builds	Tom Lane	20:32
Re: libpq compression (part 3)	Robert Haas	20:45
Re: Recovering from detoast-related catcache invalidations 📎	Tom Lane	20:47
Re: Stack overflow issue	Robert Haas	21:00
Re: libpq compression (part 3)	Jacob Burroughs	21:02
Re: Emit fewer vacuum records by reaping removable tuples during pruning	Melanie Plageman	21:05
Re: libpq compression (part 3)	Robert Haas	21:11
Re: plpgsql memory leaks	Tom Lane	21:25
Re: Make NUM_XLOGINSERT_LOCKS configurable	Jim Nasby	22:09
Re: [DOC] Add detail regarding resource consumption wrt max_connections	Cary Huang	22:14
Re: pg_upgrade failing for 200+ million Large Objects	Nathan Bossart	22:42
Re: pg_upgrade failing for 200+ million Large Objects	Nathan Bossart	22:48
Re: pg_upgrade failing for 200+ million Large Objects	Nathan Bossart	22:56
Re: pg_upgrade failing for 200+ million Large Objects	Tom Lane	22:57
Fix minor memory leak in connection string validation 📎	Jeff Davis	23:06

Jan. 13, 2024

Thread	Author	Time
Re: cfbot is failing all tests on FreeBSD/Meson builds	Thomas Munro	00:39
Re: cfbot is failing all tests on FreeBSD/Meson builds	Tom Lane	00:51
Re: cfbot is failing all tests on FreeBSD/Meson builds	Thomas Munro	00:57
Re: [17] CREATE SUBSCRIPTION ... SERVER 📎	Jeff Davis	01:17
Re: Fix minor memory leak in connection string validation	Nathan Bossart	02:37
Re: Fix minor memory leak in connection string validation	Tom Lane	03:18
Re: Synchronizing slots from primary to standby	Amit Kapila	04:35
Re: Recovering from detoast-related catcache invalidations	Xiaoran Wang	05:16
Re: plpgsql memory leaks	Pavel Stehule	05:25
Re: Synchronizing slots from primary to standby	Amit Kapila	07:23
Re: [PATCH] New predefined role pg_manage_extensions	Michael Banck	08:20
Re: Recovering from detoast-related catcache invalidations	Xiaoran Wang	09:02
Re: POC: GROUP BY optimization 📎	Andrei Lepikhov	09:08
Postgres and --config-file option	Aleksander Alekseev	10:39
Re: reorganize "Shared Memory and LWLocks" section of docs	Aleksander Alekseev	10:49
Re: speed up a logical replica setup	Amit Kapila	11:02
Re: A failure in t/038_save_logical_slots_shutdown.pl	Amit Kapila	11:12
Re: Invalidate the subscription worker in cases where a user loses their superuser status	Amit Kapila	11:21
Add support for data change delta tables	PavelTurk	11:41
Re: Documentation to upgrade logical replication cluster 📎	vignesh C	13:37
Re: pg_stat_statements and "IN" conditions 📎	Dmitry Dolgov	14:05
Re: POC PATCH: copy from ... exceptions to: (was Re: VLDB Features) 📎	jian he	14:19
Re: Tidy fill hstv array (src/backend/access/heap/pruneheap.c)	Ranier Vilela	14:36
Re: [PATCH] Add additional extended protocol commands to psql: \parse and \bindx	Jelte Fennema-Nio	14:37
Re: Custom explain options	Tomas Vondra	14:51
Re: POC: GROUP BY optimization 📎	Alexander Korotkov	15:00
Re: Documentation to upgrade logical replication cluster	vignesh C	15:50
Re: On login trigger: take three	Alexander Lakhin	16:00

Browse Archives

Prev | Next