pgsql-hackers since 2023-01-09 08:36

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. 9, 2023

Thread	Author	Time
Re: Common function for percent placeholder replacement 📎	Peter Eisentraut	08:36
Re: RFC: logical publication via inheritance root?	Aleksander Alekseev	08:41
Re: Progress report of CREATE INDEX for nested partitioned tables 📎	Ilya Gladyshev	08:44
Re: Perform streaming logical transactions by background workers and parallel apply	Amit Kapila	08:51
Re: [PoC] Improve dead tuple storage for lazy vacuum 📎	John Naylor	08:59
Re: An oversight in ExecInitAgg for grouping sets 📎	David Rowley	09:21
Re: Privileges on PUBLICATION	Peter Eisentraut	09:23
RE: Perform streaming logical transactions by background workers and parallel apply 📎	Shinoda, Noriyoshi (PN Japan FSIP)	09:32
Re: POC: Lock updated tuples in tuple_update() and tuple_delete() 📎	Aleksander Alekseev	09:56
Re: [PATCH] Simple code cleanup in tuplesort.c.	John Naylor	09:58
Re: POC: Lock updated tuples in tuple_update() and tuple_delete() 📎	Alexander Korotkov	10:10
RE: Perform streaming logical transactions by background workers and parallel apply 📎	[email protected]	10:15
Re: POC: Lock updated tuples in tuple_update() and tuple_delete() 📎	Alexander Korotkov	10:29
RE: Logical replication timeout problem	[email protected]	10:38
Re: POC: Lock updated tuples in tuple_update() and tuple_delete()	Pavel Borisov	10:40
Re: POC: Lock updated tuples in tuple_update() and tuple_delete()	Aleksander Alekseev	10:46
Re: POC: Lock updated tuples in tuple_update() and tuple_delete()	Alexander Korotkov	10:46
Re: Split index and table statistics into different types of stats	Nitin Jadhav	11:38
Fix pg_publication_tables to exclude generated columns 📎	[email protected]	11:59
Re: [PATCH] random_normal function	Dean Rasheed	12:03
Re: Todo: Teach planner to evaluate multiple windows in the optimal order 📎	David Rowley	12:23
Re: MERGE ... RETURNING	Dean Rasheed	12:29
Re: [PATCH] Simple code cleanup in tuplesort.c.	Xing Guo	12:29
RE: Perform streaming logical transactions by background workers and parallel apply	Shinoda, Noriyoshi (PN Japan FSIP)	12:44
Re: [EXTERNAL] Re: Support load balancing in libpq 📎	Jelte Fennema	13:00
Allow +group in pg_ident.conf 📎	Andrew Dunstan	13:00
Re: Allow DISTINCT to use Incremental Sort	Richard Guo	13:28
Re: XID formatting and SLRU refactorings (was: Add 64-bit XIDs into PostgreSQL 15)	Maxim Orlov	13:29
Re: XID formatting and SLRU refactorings (was: Add 64-bit XIDs into PostgreSQL 15)	Aleksander Alekseev	13:30
Re: Fix pg_publication_tables to exclude generated columns	Amit Kapila	13:32
Re: Add support for DEFAULT specification in COPY FROM	Andrew Dunstan	13:52
Re: XID formatting and SLRU refactorings (was: Add 64-bit XIDs into PostgreSQL 15)	Maxim Orlov	14:03
Re: XID formatting and SLRU refactorings (was: Add 64-bit XIDs into PostgreSQL 15) 📎	Maxim Orlov	14:15
Lazy allocation of pages required for verifying FPI consistency 📎	Bharath Rupireddy	14:30
Re: Timeout when changes are filtered out by the core during logical replication	Ashutosh Bapat	14:50
Re: Add SHELL_EXIT_CODE to psql	Maxim Orlov	15:01
Re: Fix pg_publication_tables to exclude generated columns	Tom Lane	15:06
Re: [PATCH] Add `verify-system` sslmode to use system CA pool for server cert	Jelte Fennema	15:07
Re: [PATCH] random_normal function	Tom Lane	15:26
Re: [PATCH] psql: Add tab-complete for optional view parameters	Jim Jones	15:32
Re: Postgres Partitions Limitations (5.11.2.3) 📎	Laurenz Albe	15:40
Re: [PATCH] Add `verify-system` sslmode to use system CA pool for server cert	Andrew Dunstan	15:40
Re: PL/pgSQL cursors should get generated portal names by default	Pavel Stehule	15:50
Re: doc: add missing "id" attributes to extension packaging page	Karl O. Pinc	15:53
psql: Add role's membership options to the \du+ command 📎	Pavel Luzanov	16:09
Re: [PATCH] random_normal function	Dean Rasheed	16:12
Re: MERGE ... RETURNING	Vik Fearing	16:23
Re: Make EXPLAIN generate a generic plan for a parameterized query 📎	Laurenz Albe	16:40
Re: BUG: Postgres 14 + vacuum_defer_cleanup_age + FOR UPDATE + UPDATE 📎	Matthias van de Meent	16:50
Re: Todo: Teach planner to evaluate multiple windows in the optimal order 📎	Ankit Kumar Pandey	17:15
Re: wake up logical workers after ALTER SUBSCRIPTION 📎	Nathan Bossart	17:34
Re: pub/sub - specifying optional parameters without values.	Zheng Li	17:37
Re: suppressing useless wakeups in logical/worker.c 📎	Nathan Bossart	17:42
Re: MERGE ... RETURNING	Dean Rasheed	17:44
Re: add \dpS to psql	Nathan Bossart	17:45
Re: Common function for percent placeholder replacement	Nathan Bossart	17:53
Re: Fixing a couple of buglets in how VACUUM sets visibility map bits 📎	Peter Geoghegan	18:16
Re: [PATCH] Use indexes on the subscriber when REPLICA IDENTITY is full on the publisher	Önder Kalacı	18:21
Re: Allow +group in pg_ident.conf	Nathan Bossart	18:24
Re: Add SHELL_EXIT_CODE to psql 📎	Corey Huinker	18:36
Re: [PATCH] random_normal function 📎	Tom Lane	18:52
Re: BUG: Postgres 14 + vacuum_defer_cleanup_age + FOR UPDATE + UPDATE 📎	Andres Freund	19:34
Re: Fixing a couple of buglets in how VACUUM sets visibility map bits	Andres Freund	19:44
Re: Fixing a couple of buglets in how VACUUM sets visibility map bits	Andres Freund	19:57
Re: [PATCH] Use indexes on the subscriber when REPLICA IDENTITY is full on the publisher	Andres Freund	20:03
Re: Fixing a couple of buglets in how VACUUM sets visibility map bits	Peter Geoghegan	20:04
Re: Split index and table statistics into different types of stats	Andres Freund	20:04
pgsql: Doc: add XML ID attributes to <sectN> and <varlistentry> tags.	Tom Lane	20:08
Re: doc: add missing "id" attributes to extension packaging page	Tom Lane	20:18
Re: BUG: Postgres 14 + vacuum_defer_cleanup_age + FOR UPDATE + UPDATE	Thomas Munro	20:27
Re: [PATCH] Use indexes on the subscriber when REPLICA IDENTITY is full on the publisher	Tom Lane	20:37
Re: doc: add missing "id" attributes to extension packaging page	Karl O. Pinc	20:45
Re: Fixing a couple of buglets in how VACUUM sets visibility map bits	Robert Haas	20:51
Re: Fixing a couple of buglets in how VACUUM sets visibility map bits	Peter Geoghegan	20:58
Re: pg_stat_bgwriter.buffers_backend is pretty meaningless (and more?) 📎	Melanie Plageman	21:10
Re: ATTACH PARTITION seems to ignore column generation status 📎	Tom Lane	21:41
Re: Reducing the WAL overhead of freezing in VACUUM by deduplicating per-tuple freeze plans	Andres Freund	21:43
Re: BUG: Postgres 14 + vacuum_defer_cleanup_age + FOR UPDATE + UPDATE	Mark Dilger	21:55
Show various offset arrays for heap WAL records 📎	Andres Freund	21:58
Re: BUG: Postgres 14 + vacuum_defer_cleanup_age + FOR UPDATE + UPDATE	Andres Freund	22:07
Re: Reducing the WAL overhead of freezing in VACUUM by deduplicating per-tuple freeze plans	Peter Geoghegan	22:18
Re: WAL Insertion Lock Improvements (was: Re: Avoid LWLockWaitForVar() for currently held WAL insertion lock in WaitXLogInsertionsToFinish())	Andres Freund	22:24
Re: doc: add missing "id" attributes to extension packaging page	Karl O. Pinc	22:28
Re: doc: add missing "id" attributes to extension packaging page	Tom Lane	22:30
Re: Allow +group in pg_ident.conf 📎	Andrew Dunstan	22:33
Re: [PATCH] random_normal function	Dean Rasheed	22:38
Re: [PATCH] Support % wildcard in extension upgrade filenames	Tom Lane	22:51
Re: allow granting CLUSTER, REFRESH MATERIALIZED VIEW, and REINDEX 📎	Nathan Bossart	22:51
Re: Fixing a couple of buglets in how VACUUM sets visibility map bits	Peter Geoghegan	22:59
Re: Allow +group in pg_ident.conf	Jelte Fennema	23:25
Re: [PATCH] random_normal function 📎	Tom Lane	23:38
Re: POC: Lock updated tuples in tuple_update() and tuple_delete()	Andres Freund	23:38

Jan. 10, 2023

Thread	Author	Time
Re: POC: Lock updated tuples in tuple_update() and tuple_delete()	Andres Freund	01:07
Re: Allow +group in pg_ident.conf	Michael Paquier	01:14
Re: Decoupling antiwraparound autovacuum from special rules around auto cancellation	Andres Freund	01:22
Re: Strengthen pg_waldump's --save-fullpage tests	Michael Paquier	01:22
Re: Decoupling antiwraparound autovacuum from special rules around auto cancellation	Peter Geoghegan	01:40
Re: Add index scan progress to pg_stat_progress_vacuum	Andres Freund	01:52
Re: postgres_fdw uninterruptible during connection establishment / ProcSignalBarrier	Andres Freund	02:05
Re: refactoring relation extension and BufferAlloc(), faster COPY 📎	Andres Freund	02:07
Re: Allow DISTINCT to use Incremental Sort 📎	David Rowley	02:13
Re: Schema variables - new implementation for Postgres 15 (typo)	Julien Rouhaud	02:20
RE: Time delayed LR (WAS Re: logical replication restrictions)	Takamichi Osumi (Fujitsu)	02:27
Re: ATTACH PARTITION seems to ignore column generation status 📎	Amit Langote	02:30
Re: Add the ability to limit the amount of memory that can be allocated to backends.	Andres Freund	02:31
Re: ATTACH PARTITION seems to ignore column generation status	Tom Lane	02:38
Re: Handle infinite recursion in logical replication setup	Jonathan S. Katz	02:43
RE: [PATCH] Support % wildcard in extension upgrade filenames	Regina Obe	03:03
Re: Allow DISTINCT to use Incremental Sort	Richard Guo	03:07
RE: Fix pg_publication_tables to exclude generated columns	[email protected]	03:08
Re: BUG: Postgres 14 + vacuum_defer_cleanup_age + FOR UPDATE + UPDATE	Mark Dilger	03:24
Re: FYI: 2022-10 thorntail failures from coreutils FICLONE	Tom Lane	03:49
RE: [Proposal] Add foreign-server health checks infrastructure 📎	Hayato Kuroda (Fujitsu)	03:56
Re: Show various offset arrays for heap WAL records	Peter Geoghegan	03:59
Re: Strengthen pg_waldump's --save-fullpage tests	Bharath Rupireddy	04:10
Re: [Proposal] Add foreign-server health checks infrastructure	Tom Lane	04:24
RE: Perform streaming logical transactions by background workers and parallel apply 📎	[email protected]	04:55
Re: typos 📎	Justin Pryzby	04:57
Re: split TOAST support out of postgres.h	Peter Eisentraut	05:07
Re: doc: add missing "id" attributes to extension packaging page	Brar Piening	05:12
Re: doc: add missing "id" attributes to extension packaging page	Tom Lane	05:22
Re: Todo: Teach planner to evaluate multiple windows in the optimal order	David Rowley	05:23
Re: doc: add missing "id" attributes to extension packaging page	Brar Piening	05:28
Re: wake up logical workers after ALTER SUBSCRIPTION	Amit Kapila	05:29
Re: Todo: Teach planner to evaluate multiple windows in the optimal order	Tom Lane	05:36
Re: Perform streaming logical transactions by background workers and parallel apply	Kyotaro Horiguchi	05:46
Re: doc: add missing "id" attributes to extension packaging page 📎	Brar Piening	06:08
Re: Add BufFileRead variants with short read and EOF detection	Amit Kapila	06:20
Re: Fixing a couple of buglets in how VACUUM sets visibility map bits	Peter Geoghegan	06:28
Re: Perform streaming logical transactions by background workers and parallel apply	Amit Kapila	06:31
Re: typos	Amit Kapila	06:54
Re: FYI: 2022-10 thorntail failures from coreutils FICLONE	Noah Misch	07:24
Re: allowing for control over SET ROLE	Jeff Davis	07:28
Re: split TOAST support out of postgres.h	Noah Misch	07:39
Avoiding "wrong tuple length" errors at the end of VACUUM on pg_database update (Backpatch of 947789f to v12 and v13)	Michael Paquier	07:43
Re: typos	Michael Paquier	07:48
Re: Avoiding "wrong tuple length" errors at the end of VACUUM on pg_database update (Backpatch of 947789f to v12 and v13)	Tom Lane	07:57
Re: typos	Amit Kapila	08:25
Re: Add a new pg_walinspect function to extract FPIs from WAL records	Drouvot, Bertrand	08:29
Re: Todo: Teach planner to evaluate multiple windows in the optimal order	Ankit Kumar Pandey	08:31
Re: Minimal logical decoding on standbys 📎	Drouvot, Bertrand	08:33
Re: [PATCH] random_normal function	Dean Rasheed	08:33
Re: split TOAST support out of postgres.h	Peter Eisentraut	08:48
Re: Add SHELL_EXIT_CODE to psql	Maxim Orlov	08:54
Re: Exposing the lock manager's WaitForLockers() to SQL	Marco Slot	09:01
Re: Collation version tracking for macOS	Peter Eisentraut	09:57
Change xl_hash_vacuum_one_page.ntuples from int to uint16 📎	Drouvot, Bertrand	10:08
Re: Add proper planner support for ORDER BY / DISTINCT aggregates	Dean Rasheed	10:11
Re: [PATCH] random_normal function	Dean Rasheed	10:20
Some revises in adding sorting path 📎	Richard Guo	11:05
Re: Support for dumping extended statistics 📎	Hari krishna Maddileti	11:28
Re: Perform streaming logical transactions by background workers and parallel apply	Dilip Kumar	11:47
Re: [PoC] Improve dead tuple storage for lazy vacuum	Masahiko Sawada	12:07
Re: Allow +group in pg_ident.conf	Jelte Fennema	12:09
Use windows VMs instead of windows containers on the CI 📎	Nazir Bilal Yavuz	12:20
Re: psql's FETCH_COUNT (cursor) is not being respected for CTEs 📎	Jakub Wartak	12:23
Re: [PATCH]Feature improvement for MERGE tab completion 📎	Dean Rasheed	12:24
Re: Use windows VMs instead of windows containers on the CI	Nazir Bilal Yavuz	12:37
Re: Resolve UNKNOWN type to relevant type instead of text type while bulk update using values	Ashutosh Bapat	12:43
Re: SQL/JSON revisited 📎	Elena Indrupskaya	12:51
Re: Use windows VMs instead of windows containers on the CI	Nazir Bilal Yavuz	12:51
Re: [PATCH] support tab-completion for single quote input with equal sign 📎	torikoshia	13:01
Re: split TOAST support out of postgres.h	Robert Haas	13:12
Re: pgbench - adding pl/pgsql versions of tests	Fabien COELHO	13:43
Re: BUG: Postgres 14 + vacuum_defer_cleanup_age + FOR UPDATE + UPDATE	Matthias van de Meent	14:03
RE: Time delayed LR (WAS Re: logical replication restrictions) 📎	Takamichi Osumi (Fujitsu)	14:11
Re: Bug in check for unreachable MERGE WHEN clauses	Dean Rasheed	14:23
RE: Time delayed LR (WAS Re: logical replication restrictions)	Takamichi Osumi (Fujitsu)	14:33
Re: [PATCH] random_normal function	Tom Lane	14:34
RE: Time delayed LR (WAS Re: logical replication restrictions)	Takamichi Osumi (Fujitsu)	14:41
Re: Allow +group in pg_ident.conf	Andrew Dunstan	14:42
Re: MERGE ... WHEN NOT MATCHED BY SOURCE 📎	Dean Rasheed	14:43
Re: split TOAST support out of postgres.h	Tom Lane	14:46
Re: SQL/JSON revisited	Andrew Dunstan	15:03
Re: Handle infinite recursion in logical replication setup	Amit Kapila	15:17
Re: Announcing Release 15 of the PostgreSQL Buildfarm client	Andrew Dunstan	15:17
Re: Announcing Release 15 of the PostgreSQL Buildfarm client	Andrew Dunstan	15:21
Re: Use windows VMs instead of windows containers on the CI	Justin Pryzby	15:22
The documentation for storage type 'plain' actually allows single byte header	PG Doc comments form	15:53
Re: [PATCH] pgbench: add multiconnect option	Fabien COELHO	15:59
Re: allowing for control over SET ROLE 📎	Robert Haas	16:06
Re: [PATCH] random_normal function	Paul Ramsey	16:11
can while loop in ClockSweepTick function be kind of infinite loop in some cases?	斯波隼斗	16:25
Re: Strengthen pg_waldump's --save-fullpage tests	Drouvot, Bertrand	16:25
RE: [Proposal] Add foreign-server health checks infrastructure 📎	Hayato Kuroda (Fujitsu)	16:26
Re: [Proposal] Add foreign-server health checks infrastructure	Ted Yu	16:38
Re: allowing for control over SET ROLE	Robert Haas	16:45
Re: split TOAST support out of postgres.h	Robert Haas	17:00
releasing ParallelApplyTxnHash when pa_launch_parallel_worker returns NULL	Ted Yu	17:25
Re: releasing ParallelApplyTxnHash when pa_launch_parallel_worker returns NULL 📎	Ted Yu	17:26
Re: Transparent column encryption	Mark Dilger	17:26
Re: can while loop in ClockSweepTick function be kind of infinite loop in some cases?	Andres Freund	17:39
Re: Add 64-bit XIDs into PostgreSQL 15	Aleksander Alekseev	17:42
Re: releasing ParallelApplyTxnHash when pa_launch_parallel_worker returns NULL	Ted Yu	17:43
Re: wake up logical workers after ALTER SUBSCRIPTION 📎	Nathan Bossart	17:43
pgsql: Add new GUC createrole_self_grant.	Robert Haas	17:46
Re: fixing CREATEROLE	Robert Haas	17:46
Re: Handle infinite recursion in logical replication setup	Jonathan S. Katz	17:54
Re: Avoiding "wrong tuple length" errors at the end of VACUUM on pg_database update (Backpatch of 947789f to v12 and v13)	Nathan Bossart	17:54
Re: can while loop in ClockSweepTick function be kind of infinite loop in some cases?	Robert Haas	18:11

Browse Archives

Prev | Next