pgsql-hackers - February 2024

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
Jump to day: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29

Feb. 1, 2024

Thread Author Time
Re: speed up a logical replica setup Euler Taveira 00:04
Re: src/bin/pg_upgrade/t/004_subscription.pl test comment fix 📎 Peter Smith 00:27
Re: Rename setup_cancel_handler in pg_dump 📎 Yugo NAGATA 01:21
RE: speed up a logical replica setup Hayato Kuroda (Fujitsu) 01:47
Re: More new SQL/JSON item methods Kyotaro Horiguchi 01:49
Re: More new SQL/JSON item methods Kyotaro Horiguchi 01:53
Re: Make COPY format extendable: Extract COPY TO format implementations Michael Paquier 01:57
set_cheapest without checking pathlist 📎 James Coleman 02:04
RE: speed up a logical replica setup Hayato Kuroda (Fujitsu) 02:09
Re: Parallelize correlated subqueries that execute within each worker James Coleman 02:11
Re: Synchronizing slots from primary to standby Euler Taveira 02:45
Re: Oversight in reparameterize_path_by_child leading to executor crash 📎 Richard Guo 02:54
Re: speed up a logical replica setup Euler Taveira 03:05
Re: Flushing large data immediately in pqcomm Andres Freund 03:24
RE: speed up a logical replica setup 📎 Hayato Kuroda (Fujitsu) 03:26
Re: set_cheapest without checking pathlist Richard Guo 03:28
Re: set_cheapest without checking pathlist David Rowley 03:37
Re: Make COPY format extendable: Extract COPY TO format implementations Junwang Zhao 03:43
Re: More new SQL/JSON item methods Jeevan Chalke 03:49
Re: Make COPY format extendable: Extract COPY TO format implementations Michael Paquier 03:49
Re: Synchronizing slots from primary to standby Amit Kapila 03:51
Re: More new SQL/JSON item methods Jeevan Chalke 03:52
Re: Make COPY format extendable: Extract COPY TO format implementations Michael Paquier 03:56
Re: Make COPY format extendable: Extract COPY TO format implementations Junwang Zhao 04:20
Re: Synchronizing slots from primary to standby Amit Kapila 04:20
Re: pg_column_toast_chunk_id: a function to get a chunk ID of a TOASTed value 📎 Yugo NAGATA 04:45
Re: Race condition in FetchTableStates() breaks synchronization of subscription tables 📎 vignesh C 04:59
Re: POC, WIP: OR-clause support for indexes jian he 05:00
Re: Synchronizing slots from primary to standby Ajin Cherian 05:38
Re: Synchronizing slots from primary to standby Peter Smith 05:50
Re: More new SQL/JSON item methods Kyotaro Horiguchi 05:53
Re: More new SQL/JSON item methods Kyotaro Horiguchi 05:55
Re: More new SQL/JSON item methods Kyotaro Horiguchi 06:08
Re: Small fix on COPY ON_ERROR document 📎 Yugo NAGATA 06:16
Re: set_cheapest without checking pathlist Richard Guo 06:36
Re: [PATCH] New [relation] option engine 📎 Nikolay Shaplov 06:58
Re: [PATCH] LockAcquireExtended improvement 📎 Jingxian Li 07:16
Re: Add system identifier to backup manifest Amul Sul 07:17
support fix query_id for temp table ma lz 07:37
Re: A performance issue with Memoize Anthonin Bonnefoy 07:43
Re: Fix bugs not to discard statistics when changing stats_fetch_consistency Michael Paquier 08:33
Re: A performance issue with Memoize Richard Guo 08:39
Re: support fix query_id for temp table Michael Paquier 08:46
Re: set_cheapest without checking pathlist David Rowley 09:03
Re: Synchronizing slots from primary to standby Amit Kapila 09:05
Re: Documentation to upgrade logical replication cluster 📎 vignesh C 09:20
Re: Why is src/test/modules/committs/t/002_standby.pl flaky? vignesh C 09:34
Re: SLRU optimization - configurable buffer pool and partitioning the SLRU lock Alvaro Herrera 09:49
Re: pg_column_toast_chunk_id: a function to get a chunk ID of a TOASTed value jian he 09:59
Re: When extended query protocol ends? Dave Cramer 10:00
Re: SLRU optimization - configurable buffer pool and partitioning the SLRU lock Dilip Kumar 10:03
Re: SLRU optimization - configurable buffer pool and partitioning the SLRU lock Alvaro Herrera 10:14
Re: SLRU optimization - configurable buffer pool and partitioning the SLRU lock Dilip Kumar 10:42
Re: Synchronizing slots from primary to standby Amit Kapila 10:42
Re: [PoC] Implementation of distinct in Window Aggregates: take two vignesh C 10:49
Re: [PATCH] Support % wildcard in extension upgrade filenames vignesh C 11:01
Re: SLRU optimization - configurable buffer pool and partitioning the SLRU lock Dilip Kumar 11:04
Re: [PoC/RFC] Multiple passwords, interval expirations vignesh C 11:04
Re: When extended query protocol ends? Tatsuo Ishii 11:21
Re: Synchronizing slots from primary to standby Amit Kapila 11:23
Re: Synchronizing slots from primary to standby 📎 shveta malik 11:59
Re: Synchronizing slots from primary to standby shveta malik 12:07
Re: Synchronizing slots from primary to standby shveta malik 12:16
Re: Fix bugs not to discard statistics when changing stats_fetch_consistency Shinya Kato 12:22
Re: Possibility to disable `ALTER SYSTEM` Bruce Momjian 12:33
RE: speed up a logical replica setup 📎 Hayato Kuroda (Fujitsu) 12:47
Re: Refactoring backend fork+exec code 📎 Heikki Linnakangas 13:54
Re: Improving btree performance through specializing by key shape, take 2 📎 Matthias van de Meent 14:49
Re: [PATCH] ltree hash functions vignesh C 15:11
Re: Moving forward with TDE [PATCH v3] vignesh C 15:17
Re: Make COPY format extendable: Extract COPY TO format implementations Sutou Kouhei 15:19
Re: Collation version tracking for macOS vignesh C 15:25
Re: Possibility to disable `ALTER SYSTEM` Robert Haas 15:27
Re: Request for comment on setting binary format output per session vignesh C 15:35
Re: Volatile write caches on macOS and Windows, redux vignesh C 15:45
Re: Skip collecting decoded changes of already-aborted transactions vignesh C 15:47
Re: ALTER TABLE SET ACCESS METHOD on partitioned tables Alvaro Herrera 15:50
Re: Flushing large data immediately in pqcomm Robert Haas 15:52
Re: Revisiting {CREATE INDEX, REINDEX} CONCURRENTLY improvements Michail Nikolaev 16:06
Re: Forbid the use of invalidated physical slots in streaming replication. vignesh C 16:18
Re: Move bki file pre-processing from initdb to bootstrap vignesh C 16:24
Re: Unified File API vignesh C 16:26
Re: Using AF_UNIX sockets always for tests on Windows vignesh C 16:28
Re: GenBKI emits useless open;close for catalogs without rows vignesh C 17:18
Re: 003_extrafiles.pl test fails on Windows with the newer Perl versions Tom Lane 17:32
Re: Add connection active, idle time to pg_stat_activity 📎 Sergey Dudoladov 17:41
Re: Asynchronous execution support for Custom Scan vignesh C 17:42
Re: Oversight in reparameterize_path_by_child leading to executor crash Tom Lane 17:45
Re: Allow parallel plan for referential integrity checks? vignesh C 17:49
Re: [PATCH] Support % wildcard in extension upgrade filenames Sandro Santilli 17:58
Re: odd buildfarm failure - "pg_ctl: control file appears to be corrupt" vignesh C 18:19
Re: Assertion failure in SnapBuildInitialSnapshot() vignesh C 18:20
Re: Issue in postgres_fdw causing unnecessary wait for cancel request reply vignesh C 18:22
Re: Should the archiver process always make sure that the timeline history files exist in the archive? vignesh C 18:23
Re: Where can I find the doxyfile? vignesh C 18:31
Re: Add system identifier to backup manifest Robert Haas 18:32
Re: pgbench - adding pl/pgsql versions of tests vignesh C 18:32
Re: Avoid unncessary always true test (src/backend/storage/buffer/bufmgr.c) vignesh C 18:34
Re: Reduce timing overhead of EXPLAIN ANALYZE using rdtsc? vignesh C 18:44
Re: PATCH: Using BRIN indexes for sorted output vignesh C 18:47
Re: Reducing connection overhead in pg_upgrade compat check phase vignesh C 18:48
Re: Add connection active, idle time to pg_stat_activity 📎 Sergey Dudoladov 19:50
Re: Call pqPipelineFlush from PQsendFlushRequest Tom Lane 20:00
Re: Flushing large data immediately in pqcomm Robert Haas 20:02
Re: 003_extrafiles.pl test fails on Windows with the newer Perl versions Andrew Dunstan 20:36
Re: Collation version tracking for macOS Robert Haas 20:58
Re: [PATCH] LockAcquireExtended improvement Robert Haas 21:05
Fwd: Re: [HACKERS] make async slave to wait for lsn to be replayed 📎 Kartyshov Ivan 21:29
Re: ALTER TABLE SET ACCESS METHOD on partitioned tables Michael Paquier 21:46
Re: Make COPY format extendable: Extract COPY TO format implementations Michael Paquier 21:51
Re: Call pqPipelineFlush from PQsendFlushRequest Jelte Fennema-Nio 22:33
Re: Adding comments to help understand psql hidden queries 📎 David Christensen 22:39
[Doc] Improve hostssl related descriptions and option presentation 📎 David G. Johnston 22:47

Feb. 2, 2024

Thread Author Time
Checking MINIMUM_VERSION_FOR_WAL_SUMMARIES 📎 Artur Zakirov 00:11
Re: Where can I find the doxyfile? 📎 John Morris 00:19
Re: Make COPY format extendable: Extract COPY TO format implementations Sutou Kouhei 00:40
Re: Fix log_line_prefix to display the transaction id (%x) for statements not in a transaction block 📎 Quan Zongliang 00:47
Re: set_cheapest without checking pathlist Richard Guo 00:50
Re: Make COPY format extendable: Extract COPY TO format implementations Michael Paquier 00:52
Re: Synchronizing slots from primary to standby Masahiko Sawada 01:15
Re: POC: GROUP BY optimization Tom Lane 02:02
Re: speed up a logical replica setup 📎 Euler Taveira 02:04
Re: set_cheapest without checking pathlist James Coleman 02:06
Re: Oversight in reparameterize_path_by_child leading to executor crash 📎 Richard Guo 02:10
Re: Small fix on COPY ON_ERROR document torikoshia 02:29
Re: An improvement on parallel DISTINCT David Rowley 03:26
Re: POC: GROUP BY optimization Richard Guo 03:32
Re: POC: GROUP BY optimization 📎 Andrei Lepikhov 03:42
Re: POC: GROUP BY optimization 📎 Richard Guo 04:06
Re: Synchronizing slots from primary to standby Peter Smith 04:20
Re: POC: GROUP BY optimization Andrei Lepikhov 04:40
Re: Synchronizing slots from primary to standby Amit Kapila 04:58
Re: Improve eviction algorithm in ReorderBuffer 📎 Shubham Khanna 04:59
Commitfest 2024-01 is now closed vignesh C 05:19
Re: Synchronizing slots from primary to standby Bertrand Drouvot 05:23
Re: Commitfest 2024-01 is now closed Tom Lane 05:27
Re: More new SQL/JSON item methods 📎 Jeevan Chalke 05:31
Re: SQL:2011 application time 📎 jian he 05:53
Re: Race condition in FetchTableStates() breaks synchronization of subscription tables Alexander Lakhin 06:00
Re: Synchronizing slots from primary to standby Bertrand Drouvot 06:02
Re: SLRU optimization - configurable buffer pool and partitioning the SLRU lock Dilip Kumar 06:06
Re: Add new COPY option REJECT_LIMIT torikoshia 06:17
Re: Synchronizing slots from primary to standby Amit Kapila 06:20
Re: Make COPY format extendable: Extract COPY TO format implementations 📎 Michael Paquier 06:21
Re: Commitfest 2024-01 is now closed Amit Kapila 06:26
Re: Synchronizing slots from primary to standby Masahiko Sawada 06:28
Re: Commitfest 2024-01 is now closed Michael Paquier 06:41
Re: Improve eviction algorithm in ReorderBuffer Masahiko Sawada 06:42
Re: Avoid unncessary always true test (src/backend/storage/buffer/bufmgr.c) Michael Paquier 06:48
Re: Commitfest 2024-01 is now closed Masahiko Sawada 06:49
Re: Synchronizing slots from primary to standby Peter Smith 06:54
Re: Synchronizing slots from primary to standby Amit Kapila 06:55
Re: Small fix on COPY ON_ERROR document 📎 Yugo NAGATA 06:59
Re: Is this a problem in GenericXLogFinish()? Michael Paquier 07:10
Re: Make COPY format extendable: Extract COPY TO format implementations Junwang Zhao 07:27
Re: Make COPY format extendable: Extract COPY TO format implementations Sutou Kouhei 07:33
Re: An improvement on parallel DISTINCT Richard Guo 07:46
Re: Make COPY format extendable: Extract COPY TO format implementations Sutou Kouhei 07:47
Re: Commitfest 2024-01 is now closed Richard Guo 07:48
Re: Improve eviction algorithm in ReorderBuffer Masahiko Sawada 07:53
Re: Make COPY format extendable: Extract COPY TO format implementations Michael Paquier 08:04
Re: Synchronizing slots from primary to standby Amit Kapila 08:10
Re: Improve eviction algorithm in ReorderBuffer Masahiko Sawada 08:16
Re: Emitting JSON to file using COPY TO jian he 08:25
Re: Statistics Import and Export Corey Huinker 08:33
Re: Statistics Import and Export 📎 Corey Huinker 08:37
Re: Checking MINIMUM_VERSION_FOR_WAL_SUMMARIES Nazir Bilal Yavuz 08:41
Re: Checking MINIMUM_VERSION_FOR_WAL_SUMMARIES Yugo NAGATA 08:41
Re: Make COPY format extendable: Extract COPY TO format implementations Sutou Kouhei 08:46
Re: ResourceOwner refactoring Alexander Lakhin 09:00
Re: Checking MINIMUM_VERSION_FOR_WAL_SUMMARIES 📎 Artur Zakirov 09:11
Re: Check lateral references within PHVs for memoize cache keys 📎 Richard Guo 09:18
Re: Change GUC hashtable to use simplehash? 📎 John Naylor 09:21
RE: speed up a logical replica setup 📎 Hayato Kuroda (Fujitsu) 09:41
Re: Emitting JSON to file using COPY TO Alvaro Herrera 09:47
Re: Emitting JSON to file using COPY TO jian he 10:05
Re: Synchronizing slots from primary to standby Bertrand Drouvot 10:15
InstallXLogFileSegment() vs concurrent WAL flush 📎 Thomas Munro 10:18
Re: An improvement on parallel DISTINCT David Rowley 10:39
Re: Avoid unncessary always true test (src/backend/storage/buffer/bufmgr.c) Ranier Vilela 11:20
Re: An improvement on parallel DISTINCT 📎 David Rowley 11:35
Re: [PoC] Improve dead tuple storage for lazy vacuum 📎 John Naylor 11:47
Re: InstallXLogFileSegment() vs concurrent WAL flush 📎 Yugo NAGATA 11:56
Re: Checking MINIMUM_VERSION_FOR_WAL_SUMMARIES Nazir Bilal Yavuz 12:11
Re: Synchronizing slots from primary to standby 📎 shveta malik 12:16
Re: Synchronizing slots from primary to standby shveta malik 12:18
Re: [EXTERNAL] Re: Add non-blocking version of PQcancel 📎 Alvaro Herrera 12:19
Re: POC: Extension for adding distributed tracing - pg_tracing Heikki Linnakangas 12:41
Re: InstallXLogFileSegment() vs concurrent WAL flush Thomas Munro 13:42
Re: XLog size reductions: smaller XLRec block header for PG17 Heikki Linnakangas 13:52
Re: [EXTERNAL] Re: Add non-blocking version of PQcancel 📎 Jelte Fennema-Nio 14:03
Re: [EXTERNAL] Re: Add non-blocking version of PQcancel Alvaro Herrera 15:05
Re: XLog size reductions: smaller XLRec block header for PG17 Robert Haas 15:42
Re: cataloguing NOT NULL constraints Alexander Lakhin 16:00
Re: Commitfest 2024-01 is now closed Robert Haas 16:11
Re: POC: Extension for adding distributed tracing - pg_tracing Jan Katins 16:42
Re: ALTER TABLE SET ACCESS METHOD on partitioned tables Robert Haas 17:04
Re: pgbench - adding pl/pgsql versions of tests Hannu Krosing 17:13
Draft release notes for minor releases are up Tom Lane 17:54
pg_language(langispl) column apparently not needed 📎 Antonin Houska 18:03

Browse Archives

Prev | Next
Jump to day: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29