pgsql-hackers since 2025-02-19 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

Feb. 19, 2025

Thread	Author	Time
Re: Commitfest app release on Feb 17 with many improvements	Bruce Momjian	00:25
Re: Unsafe access BufferDescriptors array in BufferGetLSNAtomic()	Richard Guo	00:36
Re: pg_stat_statements and "IN" conditions	Michael Paquier	00:39
Re: Parallel heap vacuum	Melanie Plageman	00:43
Re: Unsafe access BufferDescriptors array in BufferGetLSNAtomic()	Michael Paquier	00:44
Re: test_escape: invalid option -- 'c'	Michael Paquier	00:53
Re: Issues with 2PC at recovery: CLOG lookups and GlobalTransactionData	Noah Misch	00:57
Re: Unsafe access BufferDescriptors array in BufferGetLSNAtomic()	Richard Guo	00:58
Re: [Feature Request] INSERT FROZEN to Optimize Large Cold Data Imports and Migrations	wenhui qiu	01:07
Re: Why does exec_simple_query requires 2 snapshots	Andy Fan	01:10
Re: Virtual generated columns 📎	Dean Rasheed	01:42
Re: Unsafe access BufferDescriptors array in BufferGetLSNAtomic()	Richard Guo	02:30
Re: Why does exec_simple_query requires 2 snapshots	Tom Lane	02:30
Re: test_escape: invalid option -- 'c'	Japin Li	02:31
Re: GetRelationPath() vs critical sections 📎	Andres Freund	02:35
Re: Unsafe access BufferDescriptors array in BufferGetLSNAtomic()	Tender Wang	02:47
RE: ReplicationSlotRelease() crashes when the instance is in the single user mode 📎	Hayato Kuroda (Fujitsu)	02:57
Re: test_escape: invalid option -- 'c'	Michael Paquier	03:13
Re: [fixed] Trigger test 📎	Dmitrii Bondar	03:15
Re: Enhance 'pg_createsubscriber' to retrieve databases automatically when no database is provided. 📎	Shubham Khanna	04:25
Re: Enhance 'pg_createsubscriber' to retrieve databases automatically when no database is provided.	Shubham Khanna	04:31
Re: Remove wal_[sync|write][_time] from pg_stat_wal and track_wal_io_timing	Michael Paquier	04:32
Re: Enhance 'pg_createsubscriber' to retrieve databases automatically when no database is provided.	Shubham Khanna	04:35
Re: Improve CRC32C performance on SSE4.2	John Naylor	05:19
Re: Forbid to DROP temp tables of other sessions	Daniil Davydov	06:13
missing assert in makeString 📎	Pavel Stehule	06:31
Re: missing assert in makeString	Tom Lane	06:48
Re: Proposal to CREATE FOREIGN TABLE LIKE	Michael Paquier	06:53
Re: BUG #18815: Logical replication worker Segmentation fault	Sergey Belyashov	06:55
Re: BUG #18815: Logical replication worker Segmentation fault	Tom Lane	07:06
Re: pg_copy_logical_replication_slot doesn't copy the failover property 📎	Shlok Kyal	07:10
Re: [PoC] Reducing planning time when tables have many partitions 📎	Yuya Watari	07:33
Re: missing assert in makeString	Pavel Stehule	07:35
Re: Proposal to CREATE FOREIGN TABLE LIKE	Zhang Mingli	07:40
Re: [PATCH] Hex-coding optimizations using SVE on ARM. 📎	Chiranmoy.Bhattacharya@fujitsu.com	08:19
Re: Extend postgres_fdw_get_connections to return remote backend pid	Fujii Masao	08:49
Re: Why does exec_simple_query requires 2 snapshots	Andy Fan	08:50
Re: Remove wal_[sync|write][_time] from pg_stat_wal and track_wal_io_timing 📎	Bertrand Drouvot	09:24
Re: new commitfest transition guidance	Jelte Fennema-Nio	09:25
Re: [PATCH] SVE popcount support 📎	Chiranmoy.Bhattacharya@fujitsu.com	09:31
Re: Improve statistics estimation considering GROUP-BY as a 'uniqueiser'	Alexander Korotkov	09:48
Re: Fix logging for invalid recovery timeline	Benoit Lobréau	09:51
Re: POC: enable logical decoding when wal_level = 'replica' without a server restart	Bertrand Drouvot	09:56
Re: Improve statistics estimation considering GROUP-BY as a 'uniqueiser'	Alexander Korotkov	10:00
Re: Introduce XID age and inactive timeout based replication slot invalidation	Amit Kapila	10:13
Re: Clarification on Role Access Rights to Table Indexes 📎	Ayush Vatsa	10:23
Re: Added schema level support for publication.	Amit Kapila	10:26
pg_upgrade fails for PostGIS custom SRIDs	Jakub Wartak	10:27
Re: Clarification on Role Access Rights to Table Indexes	Ayush Vatsa	10:31
Re: pg_upgrade fails for PostGIS custom SRIDs	Jakub Wartak	10:33
RE: Enhance 'pg_createsubscriber' to retrieve databases automatically when no database is provided.	Hayato Kuroda (Fujitsu)	10:53
Re: Non-text mode for pg_dumpall	Mahendra Singh Thalor	11:32
Re: Non-text mode for pg_dumpall 📎	jian he	11:37
Re: Restrict copying of invalidated replication slots 📎	Shlok Kyal	11:46
Re: Non-text mode for pg_dumpall 📎	Mahendra Singh Thalor	12:37
Re: Added schema level support for publication. 📎	vignesh C	12:48
Re: BitmapHeapScan streaming read user and prelim refactoring	Jakub Wartak	13:28
Re: explain analyze rows=%.0f	Ilia Evdokimov	14:01
Re: [PoC] Federated Authn/z with OAUTHBEARER 📎	Daniel Gustafsson	14:13
Re: Sample rate added to pg_stat_statements	Ilia Evdokimov	14:24
Re: new commitfest transition guidance	Aleksander Alekseev	14:29
Re: new commitfest transition guidance	Daniel Gustafsson	15:02
Re: new commitfest transition guidance	Robert Haas	15:05
Re: new commitfest transition guidance	Aleksander Alekseev	15:13
Re: new commitfest transition guidance	Tom Lane	15:19
Re: new commitfest transition guidance	Aleksander Alekseev	15:24
Re: Virtual generated columns 📎	Dean Rasheed	15:25
Re: new commitfest transition guidance	Jelte Fennema-Nio	15:30
Re: explain analyze rows=%.0f	Andrei Lepikhov	15:37
Re: BackgroundPsql swallowing errors on windows	Andres Freund	15:41
Re: Support for NO INHERIT to INHERIT state change with named NOT NULL constraints	Alvaro Herrera	15:46
Re: new commitfest transition guidance	Daniel Gustafsson	16:24
Re: new commitfest transition guidance	David G. Johnston	16:27
Re: new commitfest transition guidance	Robert Haas	16:32
Re: why there is not VACUUM FULL CONCURRENTLY? 📎	Antonin Houska	17:08
Re: Fix logging for invalid recovery timeline	David Steele	17:35
Re: why there is not VACUUM FULL CONCURRENTLY?	Marcos Pegoraro	17:40
Re: BackgroundPsql swallowing errors on windows	Andres Freund	17:46
Re: Improve cleaning files on Postgres crashes	Ranier Vilela	17:48
Re: Improve cleaning files on Postgres crashes 📎	Ranier Vilela	17:50
Re: new commitfest transition guidance	Maciek Sakrejda	18:01
Re: new commitfest transition guidance	Jelte Fennema-Nio	18:03
Re: missing assert in makeString	Andres Freund	18:05
Re: missing assert in makeString	Pavel Stehule	18:32
Re: pg_trgm comparison bug on cross-architecture replication due to different char implementation 📎	Masahiko Sawada	18:48
Re: AIO v2.4 📎	Andres Freund	19:10
Re: Sample rate added to pg_stat_statements	Sami Imseih	19:11
Re: [PoC] Federated Authn/z with OAUTHBEARER	Jacob Champion	19:54
Re: dblink: Add SCRAM pass-through authentication	Matheus Alcantara	20:01
Re: Adjusting hash join memory limit to handle batch explosion	Tomas Vondra	20:21
Re: Non-text mode for pg_dumpall	Álvaro Herrera	21:09
Re: BitmapHeapScan streaming read user and prelim refactoring 📎	Melanie Plageman	21:14
Re: jsonb_strip_nulls with arrays?	Florents Tselai	21:23
Re: Trigger more frequent autovacuums of heavy insert tables	Melanie Plageman	21:36
Re: Parallel CREATE INDEX for GIN indexes 📎	Tomas Vondra	21:54
Re: BUG #18815: Logical replication worker Segmentation fault	Tom Lane	21:55
Re: Trigger more frequent autovacuums of heavy insert tables	Nathan Bossart	21:59
Re: IPC::Run::time[r|out] vs our TAP tests	Andrew Dunstan	22:08
Re: new commitfest transition guidance	Jelte Fennema-Nio	22:18
Re: jsonb_strip_nulls with arrays?	Andrew Dunstan	22:18
Re: new commitfest transition guidance	Andrew Dunstan	22:33
Re: new commitfest transition guidance	Daniel Gustafsson	22:42
Re: new commitfest transition guidance	Magnus Hagander	22:44
Re: new commitfest transition guidance	Daniel Gustafsson	22:55
Re: Should heapam_estimate_rel_size consider fillfactor?	Tomas Vondra	22:56
Re: Sample rate added to pg_stat_statements 📎	Ilia Evdokimov	22:59
Re: BitmapHeapScan streaming read user and prelim refactoring	Thomas Munro	23:12
Re: Serverside SNI support in libpq 📎	Daniel Gustafsson	23:12
Re: dblink: Add SCRAM pass-through authentication	Jacob Champion	23:19
Re: Proposal to CREATE FOREIGN TABLE LIKE	Michael Paquier	23:55
Re: IPC::Run::time[r|out] vs our TAP tests 📎	Daniel Gustafsson	23:56

Feb. 20, 2025

Thread	Author	Time
Re: ReplicationSlotRelease() crashes when the instance is in the single user mode	Michael Paquier	00:02
Re: Sample rate added to pg_stat_statements	Sami Imseih	00:32
Re: Bump soft open file limit (RLIMIT_NOFILE) to hard limit on startup	Andres Freund	00:37
Re: GetRelationPath() vs critical sections	Thomas Munro	01:00
Re: Sample rate added to pg_stat_statements	Sami Imseih	01:04
Re: Parallel heap vacuum 📎	Masahiko Sawada	01:31
Re: Fix logging for invalid recovery timeline	Michael Paquier	01:45
RE: ReplicationSlotRelease() crashes when the instance is in the single user mode 📎	Hayato Kuroda (Fujitsu)	02:22
Re: ReplicationSlotRelease() crashes when the instance is in the single user mode	David G. Johnston	02:27
Re: Proposal: Filter irrelevant change before reassemble transactions during logical decoding 📎	Ajin Cherian	02:30
Re: Proposal: Filter irrelevant change before reassemble transactions during logical decoding	Ajin Cherian	02:51
Re: Adding support for SSLKEYLOGFILE in the frontend 📎	Abhishek Chanda	03:36
RE: Proposal: Filter irrelevant change before reassemble transactions during logical decoding	Hayato Kuroda (Fujitsu)	04:08
Re: pg_copy_logical_replication_slot doesn't copy the failover property	Nisha Moond	04:09
Re: Commitfest app release on Feb 17 with many improvements	Thomas Munro	04:16
Re: pg_copy_logical_replication_slot doesn't copy the failover property 📎	Shlok Kyal	04:24
DB Restarting daily at midnight	Gayatri Singh	04:34
Re: Extended Statistics set/restore/clear functions. 📎	Corey Huinker	04:43
Re: DB Restarting daily at midnight	Ashutosh Bapat	04:49
Re: DB Restarting daily at midnight	Tom Lane	04:52
Re: Virtual generated columns	jian he	04:57
Inconsistent GUC descriptions 📎	Kyotaro Horiguchi	05:08
Re: Remove wal_[sync|write][_time] from pg_stat_wal and track_wal_io_timing 📎	Michael Paquier	05:37
RE: Inconsistent GUC descriptions	Hayato Kuroda (Fujitsu)	05:46
Re: Introduce XID age and inactive timeout based replication slot invalidation	Amit Kapila	06:11
Re: Add “FOR UPDATE NOWAIT” lock details to the log.	Yuki Seino	06:27
Re: Non-text mode for pg_dumpall 📎	Mahendra Singh Thalor	06:43
Re: Adding a '--clean-publisher-objects' option to 'pg_createsubscriber' utility. 📎	Shubham Khanna	06:44
RE: Conflict detection for update_deleted in logical replication 📎	Zhijie Hou (Fujitsu)	07:20
Re: Enhance 'pg_createsubscriber' to retrieve databases automatically when no database is provided.	Peter Smith	07:53
Re: Add Pipelining support in psql	Michael Paquier	08:02
Re: Remove wal_[sync|write][_time] from pg_stat_wal and track_wal_io_timing	Bertrand Drouvot	08:11
Re: Draft for basic NUMA observability	Bertrand Drouvot	08:32
Re: Non-text mode for pg_dumpall 📎	jian he	09:18
Re: Add Pipelining support in psql 📎	Anthonin Bonnefoy	09:29
Re: Statistics Import and Export	Jeff Davis	09:39
RE: Proposal: Filter irrelevant change before reassemble transactions during logical decoding	Hayato Kuroda (Fujitsu)	09:42
Re: Commitfest app release on Feb 17 with many improvements	Tatsuo Ishii	09:53
Re: Enhance 'pg_createsubscriber' to retrieve databases automatically when no database is provided. 📎	Shubham Khanna	10:08
Re: Enhance 'pg_createsubscriber' to retrieve databases automatically when no database is provided.	Shubham Khanna	10:11
Re: Commitfest app release on Feb 17 with many improvements	Thomas Munro	10:16
Re: Statistics Import and Export	vignesh C	10:24
Re: ReplicationSlotRelease() crashes when the instance is in the single user mode	Bertrand Drouvot	10:29
Re: Commitfest app release on Feb 17 with many improvements	Jelte Fennema-Nio	10:53
RE: ReplicationSlotRelease() crashes when the instance is in the single user mode	Zhijie Hou (Fujitsu)	10:56
Re: Commitfest app release on Feb 17 with many improvements	Tatsuo Ishii	11:01
RE: create subscription with (origin = none, copy_data = on)	Zhijie Hou (Fujitsu)	11:02
Assert when executing query on partitioned table 📎	Dmitry Koval	11:13
Re: Add XMLNamespaces to XMLElement 📎	Jim Jones	11:20
Re: Commitfest app release on Feb 17 with many improvements	Thomas Munro	11:22
RE: Enhance 'pg_createsubscriber' to retrieve databases automatically when no database is provided.	Hayato Kuroda (Fujitsu)	11:26
Conflict detection for multiple_unique_conflicts in logical replication 📎	Nisha Moond	11:30
Re: ReplicationSlotRelease() crashes when the instance is in the single user mode	Amit Kapila	11:31
Re: Reducing memory consumed by RestrictInfo list translations in partitionwise join planning 📎	Ashutosh Bapat	11:58
Re: Proposal: Filter irrelevant change before reassemble transactions during logical decoding	Shlok Kyal	12:14
Re: Issues with ON CONFLICT UPDATE and REINDEX CONCURRENTLY 📎	Міхаіл Нікалаеў	12:19
RE: ReplicationSlotRelease() crashes when the instance is in the single user mode	Hayato Kuroda (Fujitsu)	12:29
Proposal: pg_is_volatile function	Andrew Farries	12:47
RE: ReplicationSlotRelease() crashes when the instance is in the single user mode 📎	Hayato Kuroda (Fujitsu)	12:51
Re: IPC::Run::time[r|out] vs our TAP tests	Andrew Dunstan	13:06
Re: Enhancing Memory Context Statistics Reporting 📎	Rahila Syed	13:26
Missing [NO] INDENT flag in XMLSerialize backward parsing 📎	Jim Jones	13:27
Re: Non-text mode for pg_dumpall 📎	Mahendra Singh Thalor	13:49
Re: IPC::Run::time[r|out] vs our TAP tests 📎	Daniel Gustafsson	14:09
Re: Revisiting {CREATE INDEX, REINDEX} CONCURRENTLY improvements 📎	Mihail Nikalayeu	14:56
Re: Fix logging for invalid recovery timeline	David Steele	15:40
Re: Statistics Import and Export	Andrew Dunstan	15:43
pgsql: Add support for OAUTHBEARER SASL mechanism	Daniel Gustafsson	15:47
Re: Restrict publishing of partitioned table with a foreign table as partition	vignesh C	15:48
Re: Extend postgres_fdw_get_connections to return remote backend pid 📎	Sagar Shedge	15:54
Re: BitmapHeapScan streaming read user and prelim refactoring	Melanie Plageman	16:10
Re: Strange assertion in procarray.c 📎	Mihail Nikalayeu	16:28
Re: [PoC] Federated Authn/z with OAUTHBEARER	Daniel Gustafsson	16:29
Re: BitmapHeapScan streaming read user and prelim refactoring	Melanie Plageman	16:36
Re: Improve pgindent exclude handling: ignore empty lines	Andrew Dunstan	16:40
Re: BitmapHeapScan streaming read user and prelim refactoring	Melanie Plageman	16:51
Re: Parallel CREATE INDEX for GIN indexes 📎	Tomas Vondra	16:56
Improvement of var_eq_non_const() 📎	Teodor Sigaev	17:05
Re: Proposal: pg_is_volatile function	Pavel Stehule	17:15
RE: SIMD optimization for list_sort	Devulapalli, Raghuveer	17:25
Re: [PoC] Federated Authn/z with OAUTHBEARER	Jacob Champion	17:28
Re: GetRelationPath() vs critical sections	Andres Freund	17:40
Re: pg_copy_logical_replication_slot doesn't copy the failover property	Masahiko Sawada	17:48
Re: POC: enable logical decoding when wal_level = 'replica' without a server restart	Masahiko Sawada	18:05
Re: Proposal: pg_is_volatile function	Tom Lane	18:10
Patch Review Workshop	Paul Jungwirth	18:12
Re: Improvement of var_eq_non_const()	Tom Lane	18:21
Re: Proposal: pg_is_volatile function	Pavel Stehule	18:21
RE: Improve CRC32C performance on SSE4.2	Devulapalli, Raghuveer	18:23

Browse Archives

Prev | Next