pgsql-hackers since 2023-11-10 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

Nov. 10, 2023

Thread	Author	Time
Re: [PoC] Federated Authn/z with OAUTHBEARER	Andrey Chudnovsky	01:42
Re: Optimizing nbtree ScalarArrayOp execution, allowing multi-column ordered scans, skip scan	Matthias van de Meent	02:05
Re: A recent message added to pg_upgade 📎	Michael Paquier	02:20
Re: Failure during Building Postgres in Windows with Meson	vignesh C	02:47
Re: Failure during Building Postgres in Windows with Meson	Andres Freund	03:06
Re: Synchronizing slots from primary to standby	shveta malik	03:31
Re: Why is src/test/modules/committs/t/002_standby.pl flaky? 📎	Thomas Munro	03:31
Re: Add new option 'all' to pg_stat_reset_shared() 📎	torikoshia	03:33
RE: Is this a problem in GenericXLogFinish()? 📎	Hayato Kuroda (Fujitsu)	03:47
AdvanceXLInsertBuffers() vs wal_sync_method=open_datasync	Andres Freund	03:54
Re: Add new option 'all' to pg_stat_reset_shared()	Michael Paquier	04:15
Re: Add new option 'all' to pg_stat_reset_shared()	Andres Freund	04:18
Re: Add recovery to pg_control and remove backup_label	Michael Paquier	04:37
Re: SLRU optimization - configurable buffer pool and partitioning the SLRU lock	Dilip Kumar	04:46
Re: SLRU optimization - configurable buffer pool and partitioning the SLRU lock	Dilip Kumar	04:47
Re: Synchronizing slots from primary to standby	Amit Kapila	05:41
Re: Synchronizing slots from primary to standby	Drouvot, Bertrand	07:20
Re: Remove MSVC scripts from the tree 📎	Peter Eisentraut	07:38
Re: Tab completion for CREATE TABLE ... AS	Jim Jones	07:53
Re: Synchronizing slots from primary to standby	Amit Kapila	07:55
Re: Synchronizing slots from primary to standby	Amit Kapila	07:59
RE: MinGW compiler warnings in ecpg tests 📎	Hayato Kuroda (Fujitsu)	07:59
Re: Synchronizing slots from primary to standby	Drouvot, Bertrand	08:15
Re: Failure during Building Postgres in Windows with Meson 📎	Nazir Bilal Yavuz	08:29
Re: Move bki file pre-processing from initdb to bootstrap	Peter Eisentraut	08:38
Re: Move bki file pre-processing from initdb to bootstrap	Peter Eisentraut	08:48
Re: ResourceOwner refactoring	Alexander Lakhin	09:00
Re: POC, WIP: OR-clause support for indexes 📎	Alena Rybakina	09:20
Re: Bug: RLS policy FOR SELECT is used to check new rows	Dean Rasheed	09:39
Re: Add the ability to limit the amount of memory that can be allocated to backends.	jian he	09:55
Re: A recent message added to pg_upgade	Amit Kapila	09:57
Parallel aggregates in PG 16.1	ZIMANYI Esteban	10:47
Re: Synchronizing slots from primary to standby	Drouvot, Bertrand	11:00
Re: trying again to get incremental backup	Dilip Kumar	11:27
Re: Add new option 'all' to pg_stat_reset_shared()	torikoshia	11:32
Re: Parallel aggregates in PG 16.1	Matthias van de Meent	12:27
Re: Bug: RLS policy FOR SELECT is used to check new rows	Laurenz Albe	12:43
Re: pg_upgrade and logical replication 📎	vignesh C	13:56
Re: pg_upgrade and logical replication	vignesh C	14:01
Re: ResourceOwner refactoring 📎	Heikki Linnakangas	14:26
Re: Buffer Cache Problem	jacktby jacktby	14:31
Re: Buffer Cache Problem	jacktby jacktby	14:38
Re: EXCLUDE COLLATE in CREATE/ALTER TABLE document	jian he	14:59
Re: AdvanceXLInsertBuffers() vs wal_sync_method=open_datasync	Heikki Linnakangas	15:16
Re: CRC32C Parallel Computation Optimization on ARM	Nathan Bossart	16:36
Re: SLRU optimization - configurable buffer pool and partitioning the SLRU lock	Nathan Bossart	16:43
Re: Buffer Cache Problem	jacktby jacktby	16:46
Re: AdvanceXLInsertBuffers() vs wal_sync_method=open_datasync	Andres Freund	17:39
Re: SET ROLE documentation improvement	Nathan Bossart	17:41
Re: Improvements in pg_dump/pg_restore toc format and performances	Nathan Bossart	17:50
Re: pgsql: Don't trust unvalidated xl_tot_len.	Christoph Berg	18:10
Re: pgsql: Don't trust unvalidated xl_tot_len.	Christoph Berg	18:13
Re: Move bki file pre-processing from initdb to bootstrap	Krishnakumar R	18:33
Re: Failure during Building Postgres in Windows with Meson	Tristan Partin	18:53
Re: Add recovery to pg_control and remove backup_label 📎	David Steele	18:55
Re: Adding facility for injection points (or probe points?) for more advanced tests	Nathan Bossart	20:44
Re: pg_dump needs SELECT privileges on irrelevant extension table	Jacob Champion	20:48
locked reads for atomics 📎	Nathan Bossart	20:51
Re: Atomic ops for unlogged LSN	Nathan Bossart	20:54
Re: pgsql: Don't trust unvalidated xl_tot_len.	Christoph Berg	21:42
Re: locked reads for atomics	John Morris	21:49
Re: pgsql: Don't trust unvalidated xl_tot_len.	Thomas Munro	22:05
Re: Failure during Building Postgres in Windows with Meson	Andres Freund	22:47
Re: locked reads for atomics	Nathan Bossart	22:55
Re: locked reads for atomics	Andres Freund	23:11
Re: locked reads for atomics	Andres Freund	23:22
Re: ResourceOwner refactoring	Andres Freund	23:34
Re: Force the old transactions logs cleanup even if checkpoint is skipped	Andres Freund	23:58

Nov. 11, 2023

Thread	Author	Time
Re: maybe a type_sanity. sql bug 📎	jian he	00:00
Why do indexes and sorts use the database collation?	Jeff Davis	00:03
Re: A recent message added to pg_upgade	Michael Paquier	00:16
Re: maybe a type_sanity. sql bug	Michael Paquier	00:38
Re: Why do indexes and sorts use the database collation?	Andres Freund	01:19
Re: Adding facility for injection points (or probe points?) for more advanced tests	Andres Freund	02:32
Re: locked reads for atomics	Nathan Bossart	02:38
Re: locked reads for atomics	Andres Freund	02:48
Re: remaining sql/json patches	Erik Rijkers	02:52
Re: locked reads for atomics	Nathan Bossart	02:55
Re: remaining sql/json patches	Amit Langote	02:56
Re: pg_walfile_name_offset can return inconsistent values	Andres Freund	03:59
Fix documentation for pg_stat_statements JIT deform_counter 📎	Julien Rouhaud	09:26
Re: [PATCH] New [relation] option engine	John Naylor	09:33
Making auto_explain more useful / convenient	Vladimir Churyukin	10:17
Re: Add SPLIT PARTITION/MERGE PARTITIONS commands 📎	Dmitry Koval	10:26
Re:Making auto_explain more useful / convenient	Sergei Kornilov	10:43
Re: pgsql: Don't trust unvalidated xl_tot_len.	Christoph Berg	11:53
Re: ResourceOwner refactoring	Alexander Lakhin	12:00
Re: autovectorize page checksum code included elsewhere	John Naylor	12:38
Re: pg_basebackup check vs Windows file path limits	Alexander Lakhin	13:00
Re: pg_basebackup check vs Windows file path limits	Andrew Dunstan	15:18
Re: Making auto_explain more useful / convenient	Tom Lane	15:49
Re: Making auto_explain more useful / convenient	Vladimir Churyukin	16:20
Re: pg_basebackup check vs Windows file path limits	Alvaro Herrera	16:31
Re: pg_basebackup check vs Windows file path limits	Alexander Lakhin	17:00
Re: Making auto_explain more useful / convenient	Vladimir Churyukin	17:03
Re: pgsql: Don't trust unvalidated xl_tot_len.	Thomas Munro	18:17
Re: pgsql: Don't trust unvalidated xl_tot_len.	Christoph Berg	18:26
Re: pgsql: Don't trust unvalidated xl_tot_len.	Thomas Munro	19:00
Add basic tests for the low-level backup method. 📎	David Steele	19:21
Re: pgsql: Don't trust unvalidated xl_tot_len.	Andres Freund	19:43
Re: pgsql: Don't trust unvalidated xl_tot_len.	Christoph Berg	20:03
Re: Optimizing nbtree ScalarArrayOp execution, allowing multi-column ordered scans, skip scan	Matthias van de Meent	21:08
Re: Add minimal C example and SQL registration example for custom table access methods.	Paul A Jungwirth	21:17
Re: autovectorize page checksum code included elsewhere	Nathan Bossart	21:49
Re: pgsql: Don't trust unvalidated xl_tot_len.	Thomas Munro	23:17

Nov. 12, 2023

Thread	Author	Time
Re: pgsql: Don't trust unvalidated xl_tot_len.	Michael Paquier	00:22
Re: autovectorize page checksum code included elsewhere	Andres Freund	01:00
Re: maybe a type_sanity. sql bug	Michael Paquier	01:09
Commitfest 2023-11 update 1	John Naylor	05:53
Re: Why do indexes and sorts use the database collation?	Jeff Davis	07:19
Re: Add new option 'all' to pg_stat_reset_shared()	Michael Paquier	07:46
Re: Add new option 'all' to pg_stat_reset_shared()	Michael Paquier	07:54
Re: Parallel CREATE INDEX for BRIN indexes	Matthias van de Meent	09:38
Re: Parallel CREATE INDEX for BRIN indexes	Tomas Vondra	10:01
building with meson on windows with ssl	Dave Cramer	12:57
Re: proposal: possibility to read dumped table's name from file 📎	Pavel Stehule	13:17
Re: Add PQsendSyncMessage() to libpq 📎	Anton Kirilov	13:37
Re: pg_basebackup check vs Windows file path limits	Andrew Dunstan	14:09
Re: building with meson on windows with ssl	Dave Cramer	16:41
Re: [PATCH] Add support function for containment operators 📎	Laurenz Albe	17:15
Re: [PATCH] Add support function for containment operators	Laurenz Albe	19:20
Re: [PATCH] Add support function for containment operators	Kim Johan Andersson	20:30
Re: ResourceOwner refactoring 📎	Heikki Linnakangas	22:16
Re: ResourceOwner refactoring	Thomas Munro	23:08
Re: Cleaning up array_in()	Heikki Linnakangas	23:30
Re: pg_walfile_name_offset can return inconsistent values	Michael Paquier	23:31

Nov. 13, 2023

Thread	Author	Time
Re: Cleaning up array_in()	Tom Lane	00:11
RE: Synchronizing slots from primary to standby	Zhijie Hou (Fujitsu)	00:49
How to solve the problem of one backend process crashing and causing other processes to restart?	yuansong	02:30
Re: [EXTERNAL] Re: Add non-blocking version of PQcancel	Thomas Munro	02:38
Re: How to solve the problem of one backend process crashing and causing other processes to restart?	Tom Lane	02:55
Re: A recent message added to pg_upgade	Amit Kapila	03:15
Re: Is this a problem in GenericXLogFinish()?	Amit Kapila	03:55
Re: Synchronizing slots from primary to standby	shveta malik	04:00
Re: Add new option 'all' to pg_stat_reset_shared()	torikoshia	04:15
Re: Synchronizing slots from primary to standby	shveta malik	04:24
Re: Add recovery to pg_control and remove backup_label	Michael Paquier	04:36
Re: A recent message added to pg_upgade	Michael Paquier	04:49
Re: MERGE ... RETURNING	jian he	05:29
Re: Remove MSVC scripts from the tree	Michael Paquier	05:30
Re: Synchronizing slots from primary to standby	Ajin Cherian	05:32
RE: Is this a problem in GenericXLogFinish()? 📎	Hayato Kuroda (Fujitsu)	05:47
Re: Adding facility for injection points (or probe points?) for more advanced tests	Michael Paquier	05:48
RE: Partial aggregates pushdown 📎	Fujii.Yuki@df.MitsubishiElectric.co.jp	05:48
Re: How to solve the problem of one backend process crashing and causing other processes to restart?	Laurenz Albe	05:53
Re: Add new option 'all' to pg_stat_reset_shared()	Michael Paquier	05:55
Re: Synchronizing slots from primary to standby	shveta malik	06:38
Re: pg_upgrade --copy-file-range	Peter Eisentraut	07:15
Re: ALTER COLUMN ... SET EXPRESSION to alter stored generated column's expression	Peter Eisentraut	08:10
Re: Add PQsendSyncMessage() to libpq	Anthonin Bonnefoy	08:19
Re: pg_upgrade and logical replication	Peter Smith	08:21
Re: pg_upgrade and logical replication	Michael Paquier	08:22
RE: Partial aggregates pushdown 📎	Fujii.Yuki@df.MitsubishiElectric.co.jp	08:25
Re: Split index and table statistics into different types of stats 📎	Drouvot, Bertrand	08:26
Re: Add new option 'all' to pg_stat_reset_shared() 📎	Bharath Rupireddy	08:37
Re: Synchronizing slots from primary to standby	Ajin Cherian	09:12
Re:Re: How to solve the problem of one backend process crashing and causing other processes to restart?	yuansong	09:13
should check collations when creating partitioned index 📎	Peter Eisentraut	09:24
Re: Synchronizing slots from primary to standby	Drouvot, Bertrand	09:53
Re: serial and partitioned table	Peter Eisentraut	10:09
Re: Incorrect file reference in comment in procarray.c	Etsuro Fujita	10:20
Re: partitioning and identity column	Peter Eisentraut	10:21
Re: Fix output of zero privileges in psql	Erik Wienhold	10:27
Re: Add new option 'all' to pg_stat_reset_shared()	Michael Paquier	10:31
Re: pg_upgrade and logical replication	Amit Kapila	10:32
Re: Re: How to solve the problem of one backend process crashing and causing other processes to restart?	Junwang Zhao	10:42
Re: pgsql: doc: fix wording describing the checkpoint_flush_after GUC	Alvaro Herrera	11:31
Re: pg_upgrade and logical replication	Amit Kapila	11:31
Re: add log messages when replication slots become active and inactive (was Re: Is it worth adding ReplicationSlot active_pid to ReplicationSlotPersistentData?) 📎	Bharath Rupireddy	12:13
Re: pg_upgrade and logical replication	Amit Kapila	12:19
Re: Why do indexes and sorts use the database collation?	Peter Eisentraut	12:43
Re: ALTER COLUMN ... SET EXPRESSION to alter stored generated column's expression	Amul Sul	13:07
Re: proposal: possibility to read dumped table's name from file 📎	Pavel Stehule	13:15
Re: pg_basebackup check vs Windows file path limits	Andrew Dunstan	13:27
Re: Improve WALRead() to suck data directly from WAL buffers when possible	Bharath Rupireddy	13:32
Re: proposal: possibility to read dumped table's name from file	Daniel Gustafsson	13:39
RE: Synchronizing slots from primary to standby 📎	Zhijie Hou (Fujitsu)	13:57
Re: add log messages when replication slots become active and inactive (was Re: Is it worth adding ReplicationSlot active_pid to ReplicationSlotPersistentData?) 📎	Bharath Rupireddy	14:17
Re: pg_upgrade failing for 200+ million Large Objects 📎	Kumar, Sachin	15:06
Re: ALTER COLUMN ... SET EXPRESSION to alter stored generated column's expression	Peter Eisentraut	15:39
Re: proposal: possibility to read dumped table's name from file	Pavel Stehule	16:07
Re: trying again to get incremental backup	Alvaro Herrera	16:25
Re: Why do indexes and sorts use the database collation?	Jeff Davis	16:49
Re: How to solve the problem of one backend process crashing and causing other processes to restart?	Joe Conway	16:57
Re: pg_walfile_name_offset can return inconsistent values 📎	Bruce Momjian	17:14
Re: Is this a problem in GenericXLogFinish()?	Robert Haas	17:21
Re: Official Windows Installer and Documentation	Bruce Momjian	17:40
Re: pg_walfile_name_offset can return inconsistent values	Andres Freund	17:49
Re: COPY TO (FREEZE)?	Bruce Momjian	17:53
[PATCH] pgbench log file headers 📎	Adam Hendel	17:55
Re: Bug: RLS policy FOR SELECT is used to check new rows	Robert Haas	17:57
Re: Question about non-blocking mode in libpq	Bruce Momjian	18:01
Re: Why do indexes and sorts use the database collation?	Andres Freund	18:02
Re: COPY TO (FREEZE)?	Tom Lane	18:17
Re: Cleaning up array_in() 📎	Tom Lane	18:23
retire MemoryContextResetAndDeleteChildren backwards compatibility macro 📎	Nathan Bossart	18:59
Re: Question about non-blocking mode in libpq	Bruce Momjian	19:05
Re: pg_walfile_name_offset can return inconsistent values 📎	Bruce Momjian	19:12
Re: [PATCH] pgbench log file headers	Andrew Atkinson	19:12
Re: trying again to get incremental backup	Robert Haas	19:22

Browse Archives

Prev | Next