pgsql-hackers since 2025-02-26 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. 26, 2025

Thread	Author	Time
Re: psql \dh: List High-Level (Root) Tables and Indexes	Greg Sabino Mullane	00:00
Re: Statistics Import and Export	Jeff Davis	00:17
Re: pgbench client-side performance issue on large scripts 📎	Tom Lane	00:17
Re: pg_trgm comparison bug on cross-architecture replication due to different char implementation	Masahiko Sawada	00:20
RE: Improve CRC32C performance on SSE4.2 📎	Devulapalli, Raghuveer	00:20
Re: psql \dh: List High-Level (Root) Tables and Indexes 📎	Sadeq Dousti	00:27
Re: Parallel heap vacuum	Masahiko Sawada	00:49
Re: Remove wal_[sync|write][_time] from pg_stat_wal and track_wal_io_timing	Michael Paquier	00:53
Re: Get rid of WALBufMappingLock	Michael Paquier	01:03
Re: Make COPY format extendable: Extract COPY TO format implementations 📎	Masahiko Sawada	01:14
Re: Statistics Import and Export 📎	Jeff Davis	02:00
Re: Make COPY format extendable: Extract COPY TO format implementations	Sutou Kouhei	02:08
Re: Statistics Import and Export	Corey Huinker	02:29
Postmaster crashed during start	Srinath Reddy	03:22
Re: bug in stored generated column over domain with constraints. 📎	jian he	03:32
Re: Restrict copying of invalidated replication slots	Amit Kapila	03:33
Re: Statistics Import and Export	Tom Lane	03:40
Re: long-standing data loss bug in initial sync of logical replication 📎	Shlok Kyal	03:51
Re: Postmaster crashed during start	Tom Lane	03:53
Re: Statistics Import and Export	Jeff Davis	03:55
Re: Statistics Import and Export	Corey Huinker	04:05
Re: Spinlock can be released twice in procsignal.c	Andrey Borodin	04:08
Re: Extend postgres_fdw_get_connections to return remote backend pid	Sagar Shedge	04:09
Re: Statistics Import and Export	Tom Lane	04:36
Re: Log connection establishment timings	Fujii Masao	04:46
Re: Spinlock can be released twice in procsignal.c	Michael Paquier	04:56
Re: Statistics Import and Export	Corey Huinker	04:57
Re: Statistics Import and Export	Tom Lane	05:05
Re: SQL:2011 application time 📎	Paul Jungwirth	05:15
Re: Improve CRC32C performance on SSE4.2	John Naylor	05:22
Re: Fix logging for invalid recovery timeline	Michael Paquier	05:27
Re: Postmaster crashed during start	Srinath Reddy	05:30
Enhances pg_createsubscriber documentation for the -d option. 📎	vignesh C	06:03
Re: [BUG]: the walsender does not update its IO statistics until it exits	Michael Paquier	06:37
Re: Spinlock can be released twice in procsignal.c 📎	Maxim Orlov	06:57
Re: support virtual generated column not null constraint	ego alter	07:00
Re: Doc fix of aggressive vacuum threshold for multixact members storage	John Naylor	07:04
Re: Log connection establishment timings	Bertrand Drouvot	07:41
Re: per backend WAL statistics	Michael Paquier	07:52
Re: Experimental tool to explore commitfest patches	Jacob Brazeal	07:59
Re: Spinlock can be released twice in procsignal.c	Andrey Borodin	08:25
Re: Draft for basic NUMA observability 📎	Jakub Wartak	08:38
Re: Proposal: Limitations of palloc inside checkpointer 📎	Maxim Orlov	08:46
Re: why there is not VACUUM FULL CONCURRENTLY? 📎	Antonin Houska	08:48
Re: Draft for basic NUMA observability	Jakub Wartak	08:48
Re: Get rid of WALBufMappingLock	Andrey Borodin	08:52
Re: Adding a '--two-phase' option to 'pg_createsubscriber' utility.	Amit Kapila	08:53
Re: Proposal: Limitations of palloc inside checkpointer	Andres Freund	08:54
Re: Enhances pg_createsubscriber documentation for the -d option.	Amit Kapila	09:05
Re: Statistics Import and Export 📎	Corey Huinker	09:25
Re: Spinlock can be released twice in procsignal.c 📎	Maxim Orlov	09:33
Re: Doc fix of aggressive vacuum threshold for multixact members storage	Bertrand Drouvot	09:40
Re: Anti join confusion	Richard Guo	09:46
Re: [BUG]: the walsender does not update its IO statistics until it exits 📎	Bertrand Drouvot	09:48
Re: Lowering temp_buffers minimum 📎	Andres Freund	09:53
Re: long-standing data loss bug in initial sync of logical replication	Amit Kapila	09:54
Re: Some read stream improvements	Andres Freund	09:55
Re: Draft for basic NUMA observability	Andres Freund	09:58
Re: [BUG]: the walsender does not update its IO statistics until it exits	Andres Freund	10:08
Re: Anti join confusion	Tender Wang	10:08
Re: Sample rate added to pg_stat_statements	Ilia Evdokimov	10:51
Re: Anti join confusion	Laurenz Albe	10:54
Re: per backend WAL statistics 📎	Bertrand Drouvot	10:59
Re: Proposal: Limitations of palloc inside checkpointer	Maxim Orlov	11:10
Re: pg_trgm comparison bug on cross-architecture replication due to different char implementation 📎	Dagfinn Ilmari Mannsåker	11:12
Re: Enhances pg_createsubscriber documentation for the -d option. 📎	vignesh C	11:18
Re: Get rid of WALBufMappingLock 📎	Alexander Korotkov	11:48
Race condition in replication slot usage introduced by commit f41d846 📎	Nisha Moond	12:10
Re: Removing unneeded self joins 📎	Alexander Korotkov	12:12
Re: Removing unneeded self joins	Alexander Korotkov	12:14
Re: Psql meta-command conninfo+	Dagfinn Ilmari Mannsåker	12:34
Re: Draft for basic NUMA observability 📎	Jakub Wartak	13:05
Re: Log connection establishment timings	Guillaume Lelarge	13:22
Re: Fix api misuse (src/bin/pg_amcheck/pg_amcheck.c)	vignesh C	13:34
Re: Race condition in replication slot usage introduced by commit f41d846	Amit Kapila	13:48
Script for determining code coverage of functions listed in pg_proc.dat 📎	Aleksander Alekseev	14:04
Re: Support a wildcard in backtrace_functions	Peter Eisentraut	14:30
Re: SQL Property Graph Queries (SQL/PGQ) 📎	Junwang Zhao	14:34
Re: Postmaster crashed during start	Greg Sabino Mullane	14:54
Re: psql \dh: List High-Level (Root) Tables and Indexes	Greg Sabino Mullane	15:01
Re: Extend postgres_fdw_get_connections to return remote backend pid	Fujii Masao	15:36
Re: Support a wildcard in backtrace_functions	Tom Lane	15:40
Re: Statistics Import and Export	Tom Lane	16:13
Re: Statistics Import and Export	Jeff Davis	16:16
Re: Trigger more frequent autovacuums of heavy insert tables	Robert Treat	16:17
Re: Statistics Import and Export	Tom Lane	16:23
Re: Statistics Import and Export	Corey Huinker	16:43
Re: Doc fix of aggressive vacuum threshold for multixact members storage 📎	Alex Friedman	16:50
Re: Draft for basic NUMA observability 📎	Bertrand Drouvot	17:13
Re: Trigger more frequent autovacuums of heavy insert tables	Nathan Bossart	17:25
Re: psql \dh: List High-Level (Root) Tables and Indexes 📎	Sadeq Dousti	17:50
Re: Statistics Import and Export	Jeff Davis	18:02
Re: Statistics Import and Export	Tom Lane	18:06
Doc: clarify possibility of ephemeral discrepancies between state and wait_event in pg_stat_activity 📎	Alex Friedman	18:12
Re: Log connection establishment timings 📎	Melanie Plageman	18:37
Re: [PATCH] Optimize SP-GiST text leaf comparisons with memcmp 📎	James Hunter	18:38
Re: Statistics Import and Export	Jeff Davis	18:44
Re: Log connection establishment timings	Melanie Plageman	18:45
Re: explain plans for foreign servers	Sami Imseih	19:13
Re: a very significant fraction of the buildfarm is now pink	James Hunter	19:14
Re: Log connection establishment timings 📎	Melanie Plageman	19:29
Re: Relaxing constraints on BitmapAnd eligibility? 📎	Dmytro Astapov	19:31
Re: [PATCH] New [relation] option engine 📎	Nikolay Shaplov	19:33
Re: SQLFunctionCache and generic plans	Pavel Stehule	19:34
Re: Anti join confusion	Robert Haas	19:36
Re: pgbench client-side performance issue on large scripts	Daniel Verite	19:44
Re: Statistics Import and Export	Melanie Plageman	19:54
Re: Doc: clarify possibility of ephemeral discrepancies between state and wait_event in pg_stat_activity	Sami Imseih	20:00
Re: Parallel CREATE INDEX for GIN indexes 📎	Tomas Vondra	20:08
Re: Statistics Import and Export	Robert Haas	20:15
Re: Make query cancellation keys longer	Robert Haas	20:18
Re: Statistics Import and Export	Jeff Davis	20:37
Re: Relaxing constraints on BitmapAnd eligibility? 📎	Dmytro Astapov	20:44
RE: Improve CRC32C performance on SSE4.2 📎	Devulapalli, Raghuveer	20:53
Re: Statistics Import and Export	Robert Haas	20:57
Re: Doc: clarify possibility of ephemeral discrepancies between state and wait_event in pg_stat_activity 📎	Alex Friedman	21:01
Re: Lowering temp_buffers minimum	Robert Haas	21:07
Re: Proposal: "query_work_mem" GUC, to distribute working memory to the query's individual operators 📎	James Hunter	21:27
Re: Statistics Import and Export	Jeff Davis	21:32
Re: Statistics Import and Export	Tom Lane	21:44
Re: Statistics Import and Export	Tom Lane	21:46
Re: Trigger more frequent autovacuums of heavy insert tables 📎	Melanie Plageman	21:48
Re: Statistics Import and Export	Corey Huinker	21:57
Re: Statistics Import and Export	Corey Huinker	21:58
Re: Anti join confusion	Tom Lane	21:58
suspicious lockup on widowbird in AdvanceXLInsertBuffer (could it be due to 6a2275b8953?) 📎	Tomas Vondra	22:08
Re: suspicious lockup on widowbird in AdvanceXLInsertBuffer (could it be due to 6a2275b8953?)	Peter Geoghegan	22:13
Re: suspicious lockup on widowbird in AdvanceXLInsertBuffer (could it be due to 6a2275b8953?)	Tomas Vondra	22:16
Re: Some read stream improvements	Thomas Munro	22:19
Re: suspicious lockup on widowbird in AdvanceXLInsertBuffer (could it be due to 6a2275b8953?)	Peter Geoghegan	22:23
[PATCH] [52] Review of patch 5381 - Documentation for pgstatindex fragmentation	ahmedashour	23:23
Re: suspicious lockup on widowbird in AdvanceXLInsertBuffer (could it be due to 6a2275b8953?)	Michael Paquier	23:49
pg_upgrade fails when using custom extension with operator class 📎	Dmitry K.	23:57

Feb. 27, 2025

Thread	Author	Time
Re: Proposal: "query_work_mem" GUC, to distribute working memory to the query's individual operators	Jeff Davis	00:08
Re: Spinlock can be released twice in procsignal.c	Michael Paquier	00:46
Re: Anti join confusion	Robert Haas	01:39
Re: Anti join confusion	Tom Lane	01:55
Re: Anti join confusion	David Rowley	02:16
Re: Statistics Import and Export 📎	Corey Huinker	02:19
Re: Anti join confusion	Tom Lane	02:26
Re: per backend WAL statistics	Michael Paquier	03:02
Re: [BUG]: the walsender does not update its IO statistics until it exits	Michael Paquier	03:09
Re: Update docs for UUID data type 📎	Andy Alsup	03:11
Re: Fix api misuse (src/bin/pg_amcheck/pg_amcheck.c)	Michael Paquier	05:08
Re: Restrict copying of invalidated replication slots	Masahiko Sawada	05:16
Re: new commitfest transition guidance	Michael Paquier	05:16
Re: Improve CRC32C performance on SSE4.2	John Naylor	05:38
Re: psql \dh: List High-Level (Root) Tables and Indexes	vignesh C	05:43
Re: Small memory fixes for pg_createsubcriber	Michael Paquier	05:50
Re: [BUG]: the walsender does not update its IO statistics until it exits	Bertrand Drouvot	05:51
Re: Spinlock can be released twice in procsignal.c	Maxim Orlov	06:11
Re: Add missing tab completion for VACUUM and ANALYZE with ONLY option	vignesh C	06:12
Remove unused <poll.h> header file in pqcomm.c	Japin Li	06:34
Re: Add “FOR UPDATE NOWAIT” lock details to the log.	Yuki Seino	06:44
Re: Log connection establishment timings	Bertrand Drouvot	06:50
Re: NOT ENFORCED constraint feature 📎	Amul Sul	06:56
Re: Add a warning message when using unencrypted passwords	Guillaume Lelarge	07:39
Re: per backend WAL statistics 📎	Bertrand Drouvot	07:47
RE: ReplicationSlotRelease() crashes when the instance is in the single user mode 📎	Hayato Kuroda (Fujitsu)	07:58
RE: long-standing data loss bug in initial sync of logical replication 📎	Zhijie Hou (Fujitsu)	08:14
Re: Changing shared_buffers without restart	Dmitry Dolgov	08:28
Useless LEFT JOIN breaks MIN/MAX optimization 📎	Alena Rybakina	08:28
Re: Race condition in replication slot usage introduced by commit f41d846	Amit Kapila	08:36
Re: Enhances pg_createsubscriber documentation for the -d option.	Amit Kapila	08:37
Re: Restrict copying of invalidated replication slots	Amit Kapila	08:52
Re: Draft for basic NUMA observability	Bertrand Drouvot	09:00
Re: Draft for basic NUMA observability 📎	Jakub Wartak	09:05
Re: vacuumdb changes for stats import/export	John Naylor	09:36
Re: suspicious lockup on widowbird in AdvanceXLInsertBuffer (could it be due to 6a2275b8953?)	Alexander Korotkov	09:45
Re: Add -k/--link option to pg_combinebackup	vignesh C	09:49
Re: Support NOT VALID / VALIDATE constraint options for named NOT NULL constraints 📎	Rushabh Lathia	09:55
Re: [BUG]: the walsender does not update its IO statistics until it exits	Andres Freund	10:06
Re: Some read stream improvements	Thomas Munro	10:09
Re: Some read stream improvements	Andres Freund	10:20
Re: Fix api misuse (src/bin/pg_amcheck/pg_amcheck.c)	Ranier Vilela	11:05
Re: Replace IN VALUES with ANY in WHERE clauses during optimization	newtglobal postgresql_contributors	11:09
Re: New "raw" COPY format	newtglobal postgresql_contributors	11:09
Re: NOT ENFORCED constraint feature	Álvaro Herrera	11:18
Re: psql \dh: List High-Level (Root) Tables and Indexes	Sadeq Dousti	11:44
Re: SQLFunctionCache and generic plans	Alexander Pyhalov	12:25
Re: new commitfest transition guidance	Andrew Dunstan	12:27
Re: SQLFunctionCache and generic plans	Pavel Stehule	12:43
Add support for EXTRA_REGRESS_OPTS for meson 📎	Andreas Karlsson	12:53
Reduce the instruction overhead of OpenSSL calls 📎	ryanewang (王蕾)	13:16
Re: Add support for EXTRA_REGRESS_OPTS for meson	Andres Freund	13:21
Re: Small memory fixes for pg_createsubcriber 📎	Ranier Vilela	13:23
Re: Serverside SNI support in libpq 📎	Daniel Gustafsson	13:38
Re: Logging which local address was connected to in log_line_prefix	Greg Sabino Mullane	13:54
Re: Add -k/--link option to pg_combinebackup	Robert Haas	14:04
Re: Proposal: Limitations of palloc inside checkpointer 📎	Maxim Orlov	14:16
Re: pg_dump, pg_dumpall, pg_restore: Add --no-policies option 📎	vignesh C	14:37
Patch: Cover POSITION(bytea,bytea) with tests 📎	Aleksander Alekseev	14:40
Re: pg_dump, pg_dumpall, pg_restore: Add --no-policies option	Greg Sabino Mullane	14:52
bug: ALTER TABLE ADD VIRTUAL GENERATED COLUMN with table rewrite 📎	jian he	15:00
Re: proposal: plpgsql, new check for extra_errors - strict_expr_check	Gilles Darold	15:33
Re: Draft for basic NUMA observability	Bertrand Drouvot	15:34
Re: proposal - plpgsql - support standard syntax for named arguments for cursors 📎	Pavel Stehule	15:40
Re: Draft for basic NUMA observability	Bertrand Drouvot	15:42
Re: SQL:2023 JSON simplified accessor support 📎	Alexandra Wang	15:46
Re: pgbench client-side performance issue on large scripts	Tom Lane	16:00

Browse Archives

Prev | Next