pgsql-hackers since 2024-01-19 03:42

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. 19, 2024

Thread	Author	Time
Re: ALTER ROLE documentation improvement	Nathan Bossart	03:42
Re: Commitfest manager January 2024	Peter Smith	03:49
Re: Add \syncpipeline command to pgbench	Michael Paquier	04:08
Re: Fix incorrect format placeholders in walreceiver.c	Michael Paquier	04:24
Re: Commitfest manager January 2024	vignesh C	04:40
Re: btree: implement dynamic prefix truncation (was: Improving btree performance through specializing by key shape, take 2)	Dilip Kumar	04:54
Re: Synchronizing slots from primary to standby	Masahiko Sawada	05:05
Re: [PATCH] Add additional extended protocol commands to psql: \parse and \bindx	Michael Paquier	05:20
Re: "ERROR: could not open relation with OID 16391" error was encountered when reindexing	Michael Paquier	05:26
Re: generate syscache info automatically	John Naylor	05:28
Re: Synchronizing slots from primary to standby	Amit Kapila	05:52
Re: Improve the connection failure error messages	Nisha Moond	05:54
Re: Add 64-bit XIDs into PostgreSQL 15	Shubham Khanna	05:56
Re: Test slots invalidations in 035_standby_logical_decoding.pl only if dead rows are removed	Alexander Lakhin	06:00
Re: Synchronizing slots from primary to standby	shveta malik	06:16
Re: the s_lock_stuck on perform_spin_delay 📎	Andy Fan	06:17
Re: Synchronizing slots from primary to standby	Peter Smith	06:18
Re: System username in pg_stat_activity	Bertrand Drouvot	06:20
Re: [PoC] Improve dead tuple storage for lazy vacuum	Masahiko Sawada	07:26
Re: Change GUC hashtable to use simplehash?	John Naylor	07:27
logical decoding build wrong snapshot with subtransactions 📎	feichanghong	07:35
Re: pgbnech: allow to cancel queries during benchmark 📎	Yugo NAGATA	07:51
Re: Add \syncpipeline command to pgbench 📎	Anthonin Bonnefoy	07:55
Re: Emitting JSON to file using COPY TO	Masahiko Sawada	08:09
Re: Synchronizing slots from primary to standby	Bertrand Drouvot	08:12
Re: subscription disable_on_error not working after ALTER SUBSCRIPTION set bad conninfo	Masahiko Sawada	08:20
Re: UUID v7 📎	Andrey Borodin	08:25
Re: index prefetching	Konstantin Knizhnik	08:34
Re: Parent/child context relation in pg_get_backend_memory_contexts()	torikoshia	08:41
Re: pgbnech: allow to cancel queries during benchmark	Tatsuo Ishii	08:46
Re: speed up a logical replica setup 📎	Shubham Khanna	08:48
Re: Test slots invalidations in 035_standby_logical_decoding.pl only if dead rows are removed 📎	Bertrand Drouvot	09:03
Re: Oom on temp (un-analyzed table caused by JIT) V16.1 [Fixed Already]	Laurenz Albe	09:20
Re: Simplify documentation related to Windows builds	Nazir Bilal Yavuz	09:38
Re: Oom on temp (un-analyzed table caused by JIT) V16.1 [Fixed Already]	Daniel Gustafsson	09:48
Re: [PoC] Improve dead tuple storage for lazy vacuum	John Naylor	09:48
Re: Oom on temp (un-analyzed table caused by JIT) V16.1 [Fixed Already]	Michael Banck	10:04
Re: Oom on temp (un-analyzed table caused by JIT) V16.1 [Fixed Already]	Daniel Gustafsson	10:06
Re: Build versionless .so for Android	Matthias Kuhn	10:08
Re: Synchronizing slots from primary to standby	shveta malik	10:25
Re: Increasing IndexTupleData.t_info from uint16 to uint32	Aleksander Alekseev	10:40
Re: remaining sql/json patches	jian he	10:46
Re: Synchronizing slots from primary to standby 📎	shveta malik	10:48
Re: Synchronizing slots from primary to standby	shveta malik	10:55
Re: UUID v7	Aleksander Alekseev	11:07
Re: Simplify documentation related to Windows builds	Andrew Dunstan	11:11
Re: [PoC] Improve dead tuple storage for lazy vacuum 📎	John Naylor	11:27
Re: System username in pg_stat_activity	Aleksander Alekseev	11:33
Re: BUG: Former primary node might stuck when started as a standby	Aleksander Alekseev	11:45
Re: Synchronizing slots from primary to standby	Amit Kapila	11:53
Re: psql JSON output format	Laurenz Albe	12:22
Re: index prefetching	Tomas Vondra	12:35
Re: POC PATCH: copy from ... exceptions to: (was Re: VLDB Features)	torikoshia	12:37
Re: System username in pg_stat_activity	Julien Rouhaud	12:43
Re: heavily contended lwlocks with long wait queues scale badly 📎	Jakub Wartak	12:49
Re: POC PATCH: copy from ... exceptions to: (was Re: VLDB Features)	Alexander Korotkov	13:27
Re: Use of backup_label not noted in log 📎	David Steele	13:32
Re: BUG: Former primary node might stuck when started as a standby	Alexander Lakhin	14:00
Re: Build versionless .so for Android	Peter Eisentraut	14:00
Re: generate syscache info automatically	Peter Eisentraut	14:03
Re: [PATCH] Exponential backoff for auth_delay 📎	Michael Banck	14:08
Re: [PATCH] Exponential backoff for auth_delay 📎	Michael Banck	14:16
Re: POC: GROUP BY optimization 📎	Alexander Korotkov	14:21
Re: pgsql: Clean up role created in new subscription test.	Daniel Gustafsson	14:26
Re: POC PATCH: copy from ... exceptions to: (was Re: VLDB Features)	torikoshia	14:26
Re: Assertion failure with epoch when replaying standby records for 2PC	Alexander Korotkov	14:28
Re: pgsql: Clean up role created in new subscription test.	Peter Eisentraut	14:40
Re: [PATCH] Exponential backoff for auth_delay	Abhijit Menon-Sen	14:41
Optimize duplicate code and fix memory leak in function fetch_remote_table_info() 📎	Yongtao Huang	14:42
Re: initdb's -c option behaves wrong way?	Daniel Gustafsson	14:53
[PATCH] pg_receivewal skip WAL file size checking 📎	Sergey Sergey	15:13
Re: index prefetching	Konstantin Knizhnik	15:19
Re: initdb's -c option behaves wrong way? 📎	Tom Lane	16:33
Re: Change GUC hashtable to use simplehash?	Heikki Linnakangas	16:54
PG12 change to DO UPDATE SET column references	James Coleman	17:00
Re: Add system identifier to backup manifest 📎	Amul Sul	17:06
Re: Build versionless .so for Android	Matthias Kuhn	17:12
Re: Add system identifier to backup manifest	Amul Sul	17:12
Re: reorganize "Shared Memory and LWLocks" section of docs	Nathan Bossart	17:22
Re: UUID v7 📎	Andrey Borodin	18:07
Re: [PATCHES] Post-special page storage TDE support 📎	David Christensen	18:49
Re: PG12 change to DO UPDATE SET column references	David G. Johnston	18:53
Improving EXPLAIN's display of SubPlan nodes 📎	Tom Lane	19:32
GUC-ify walsender MAX_SEND_SIZE constant 📎	Majid Garoosi	19:34
Re: introduce dynamic shared memory registry	Nathan Bossart	20:46
Re: Patch: Improve Boolean Predicate JSON Path Docs	Tom Lane	21:15
Re: Patch: Improve Boolean Predicate JSON Path Docs	Tom Lane	21:22
Re: Change GUC hashtable to use simplehash?	Jeff Davis	21:38
Re: index prefetching 📎	Melanie Plageman	21:43
cleanup patches for dshash 📎	Nathan Bossart	21:59
Re: Oom on temp (un-analyzed table caused by JIT) V16.1 [Fixed Already]	Kirk Wolak	22:09
Re: index prefetching	Tomas Vondra	22:14
Re: [DOC] Add detail regarding resource consumption wrt max_connections	reid.thompson	22:37
Re: Optimizing nbtree ScalarArrayOp execution, allowing multi-column ordered scans, skip scan	Peter Geoghegan	22:41

Jan. 20, 2024

Thread	Author	Time
Re: Oom on temp (un-analyzed table caused by JIT) V16.1 [Fixed Already]	Daniel Gustafsson	00:03
Re: Change GUC hashtable to use simplehash?	Jeff Davis	00:13
Re: Improve WALRead() to suck data directly from WAL buffers when possible	Jeff Davis	01:47
Re: Documentation for building with meson	vignesh C	01:53
Re: Lockless queue of waiters in LWLock	vignesh C	01:58
Re: Collation version tracking for macOS	vignesh C	02:10
Re: Dump-restore loosing 'attnotnull' bit for DEFERRABLE PRIMARY KEY column(s).	vignesh C	02:24
Re: fix stats_fetch_consistency value in postgresql.conf.sample	vignesh C	02:29
Re: Make documentation builds reproducible	vignesh C	02:33
Re: Inconsistency in reporting checkpointer stats	vignesh C	02:40
Re: Amcheck verification of GiST and GIN	vignesh C	02:46
Re: Re: Patch: Improve Boolean Predicate JSON Path Docs	Erik Wienhold	02:46
Re: add function argument names to regex* functions.	jian he	02:55
Re: add function argument names to regex* functions.	jian he	03:03
Re: fix stats_fetch_consistency value in postgresql.conf.sample	Michael Paquier	03:09
Re: Optimize duplicate code and fix memory leak in function fetch_remote_table_info()	Michael Paquier	03:13
Re: MultiXact\SLRU buffers configuration	vignesh C	03:31
Re: Reduce timing overhead of EXPLAIN ANALYZE using rdtsc?	vignesh C	03:33
Re: Prefetch the next tuple's memory during seqscans	vignesh C	03:35
Re: Optimize duplicate code and fix memory leak in function fetch_remote_table_info() 📎	Yongtao Huang	04:08
Re: Optimize duplicate code and fix memory leak in function fetch_remote_table_info()	Tom Lane	04:34
Re: Synchronizing slots from primary to standby	Dilip Kumar	05:21
Re: Change GUC hashtable to use simplehash?	John Naylor	05:50
Re: Change GUC hashtable to use simplehash?	John Naylor	06:48
Re: Optimize duplicate code and fix memory leak in function fetch_remote_table_info()	Yongtao Huang	07:46
Re: Create shorthand for including all extra tests	Peter Eisentraut	08:22
Re: Make documentation builds reproducible	Peter Eisentraut	08:32
Re: Synchronizing slots from primary to standby	Amit Kapila	10:44
Re: PG12 change to DO UPDATE SET column references	James Coleman	14:10
Re: PG12 change to DO UPDATE SET column references	David G. Johnston	14:47
Re: Patch: Improve Boolean Predicate JSON Path Docs	David E. Wheeler	15:09
Re: Make documentation builds reproducible	Tom Lane	16:03
Re: PG12 change to DO UPDATE SET column references	Tom Lane	16:12
Re: Patch: Improve Boolean Predicate JSON Path Docs	Tom Lane	16:45
Re: Patch: Improve Boolean Predicate JSON Path Docs	Tom Lane	17:34
Re: PG12 change to DO UPDATE SET column references	James Coleman	17:51
Re: PG12 change to DO UPDATE SET column references	Tom Lane	17:59
Re: [PATCH] Add support function for containment operators	Tom Lane	19:01
Re: Schema variables - new implementation for Postgres 15 📎	Pavel Stehule	20:26
Re: PG12 change to DO UPDATE SET column references 📎	James Coleman	21:45
Re: Make documentation builds reproducible	Peter Eisentraut	22:44
Re: PG12 change to DO UPDATE SET column references	Tom Lane	22:57
Re: Make documentation builds reproducible	Tom Lane	22:59

Jan. 21, 2024

Thread	Author	Time
Re: PG12 change to DO UPDATE SET column references	James Coleman	00:12
Re: Change GUC hashtable to use simplehash?	Jeff Davis	01:06
Re: PATCH: Using BRIN indexes for sorted output	vignesh C	02:02
Re: Cross-database SERIALIZABLE safe snapshots	vignesh C	02:05
Re: XLog size reductions: smaller XLRec block header for PG17	vignesh C	02:14
Re: ReadRecentBuffer() doesn't scale well	vignesh C	02:17
Re: Allow parallel plan for referential integrity checks?	vignesh C	02:26
Bug report and fix about building historic snapshot 📎	cca5507	09:25
Fix some typos 📎	Yongtao Huang	12:22
Re: Using AF_UNIX sockets always for tests on Windows	vignesh C	12:31
Re: some namespace.c refactoring	vignesh C	12:34
Re: Trivial revise for the check of parameterized partial paths	vignesh C	12:36
Re: Retiring is_pushed_down	vignesh C	12:37
Re: proposal: psql: show current user in prompt 📎	Pavel Stehule	15:05
Re: Patch: Improve Boolean Predicate JSON Path Docs	David E. Wheeler	15:16
Re: introduce dynamic shared memory registry	Tom Lane	16:21
FEATURE REQUEST: Role vCPU limit/priority	Yoni Sade	18:07
Re: Collation version tracking for macOS	Jeff Davis	18:57
Re: Patch: Improve Boolean Predicate JSON Path Docs	David E. Wheeler	19:02
Re: [17] CREATE COLLATION default provider	Jeff Davis	19:07
Re: Patch: Improve Boolean Predicate JSON Path Docs	David E. Wheeler	19:24
Re: Patch: Improve Boolean Predicate JSON Path Docs 📎	Tom Lane	19:34
Re: Patch: Improve Boolean Predicate JSON Path Docs	Tom Lane	19:43
Re: index prefetching	Konstantin Knizhnik	19:50
Re: Patch: Improve Boolean Predicate JSON Path Docs	David E. Wheeler	19:52
Re: index prefetching	Konstantin Knizhnik	19:56
Re: Patch: Improve Boolean Predicate JSON Path Docs	David E. Wheeler	19:58
Re: Patch: Improve Boolean Predicate JSON Path Docs	David E. Wheeler	20:02
Re: Things I don't like about \du's "Attributes" column 📎	Pavel Luzanov	21:34
Re: introduce dynamic shared memory registry 📎	Nathan Bossart	22:13
Re: the s_lock_stuck on perform_spin_delay 📎	Andy Fan	23:26
Re: Evaluate arguments of correlated SubPlans in the referencing ExprState	Peter Smith	23:30
Re: pg_rewind WAL segments deletion pitfall	Peter Smith	23:38
Re: index prefetching	Tomas Vondra	23:39
Re: index prefetching	Tomas Vondra	23:47
Re: Guiding principle for dropping LLVM versions?	Peter Smith	23:49

Jan. 22, 2024

Thread	Author	Time
Re: remaining sql/json patches 📎	jian he	00:00
Re: [PATCH] psql: \dn+ to show size of each schema (and \dA+ for AMs)	Peter Smith	00:10
Re: generate syscache info automatically	John Naylor	00:33
Re: pg_receivewal fail to streams when the partial file to write is not fully initialized present in the wal receiver directory	Peter Smith	01:05
Re: pg_ls_tmpdir to show directories and shared filesets (and pg_ls_*)	Peter Smith	01:16
Re: WIP: Aggregation push-down - take2	Peter Smith	01:22
Re: Temporary tables versus wraparound... again	Peter Smith	01:29
Re: Support TZ format code in to_timestamp()	Peter Smith	01:57
Re: Change GUC hashtable to use simplehash? 📎	John Naylor	02:03
Re: MERGE ... WHEN NOT MATCHED BY SOURCE	Peter Smith	02:10
Re: Support TZ format code in to_timestamp()	Tom Lane	02:10
Re: Volatile write caches on macOS and Windows, redux	Peter Smith	02:16
Re: ALTER TABLE SET ACCESS METHOD on partitioned tables	Peter Smith	02:25
Re: cleanup patches for dshash	Andy Fan	02:28
Re: Remove unused fields in ReorderBufferTupleBuf	Peter Smith	02:33
Re: Incremental View Maintenance, take 2	Peter Smith	02:51
Re: Opportunistically pruning page before update	Peter Smith	02:58
Re: Add code indentation check to cirrus-ci (was Re: Add BF member koel-like indentation checks to SanityCheck CI)	Peter Smith	03:19
Re: Add last_commit_lsn to pg_stat_database	Peter Smith	03:26
Re: [PoC] Improve dead tuple storage for lazy vacuum	Masahiko Sawada	03:27
Re: Add new protocol message to change GUCs for usage with future protocol-only GUCs	Peter Smith	03:31
Re: Synchronizing slots from primary to standby 📎	shveta malik	03:36
Re: cleanup patches for dshash	Nathan Bossart	03:51
Re: Avoid computing ORDER BY junk columns unnecessarily	Peter Smith	04:11
Re: Change GUC hashtable to use simplehash?	Jeff Davis	04:16
Re: Synchronizing slots from primary to standby	Amit Kapila	04:19
Re: UUID v7	Nikolay Samokhvalov	04:22

Browse Archives

Prev | Next