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

Feb. 11, 2023

Thread Author Time
Re: Move defaults toward ICU in 16? 📎 Jeff Davis 00:17
Re: UUID v7 Andres Freund 01:14
Re: UUID v7 Tom Lane 01:18
Re: Move defaults toward ICU in 16? Andres Freund 02:00
Re: Time delayed LR (WAS Re: logical replication restrictions) Andres Freund 02:09
Re: UUID v7 Andrey Borodin 02:53
Re: daitch_mokotoff module Andres Freund 02:58
Re: ICU locale validation / canonicalization Robert Haas 03:50
Re: [PoC] Improve dead tuple storage for lazy vacuum 📎 John Naylor 05:33
RE: Time delayed LR (WAS Re: logical replication restrictions) Takamichi Osumi (Fujitsu) 05:44
Re: possible memory leak in VACUUM ANALYZE Pavel Stehule 06:06
Re: possible memory leak in VACUUM ANALYZE Justin Pryzby 06:53
Re: possible memory leak in VACUUM ANALYZE Andres Freund 07:18
Re: possible memory leak in VACUUM ANALYZE Pavel Stehule 07:20
Re: pg_stat_statements and "IN" conditions David Geier 10:03
Re: pg_stat_statements and "IN" conditions Dmitry Dolgov 10:47
Re: pg_stat_statements and "IN" conditions Dmitry Dolgov 12:08
Sort optimizations: Making in-memory sort cache-aware Ankit Kumar Pandey 12:19
Re: UUID v7 Peter Eisentraut 15:50
Re: pg_stat_bgwriter.buffers_backend is pretty meaningless (and more?) Andres Freund 18:24
Improving inferred query column names Andres Freund 19:24
Re: Sort optimizations: Making in-memory sort cache-aware Andres Freund 20:29
Re: Improving inferred query column names Vladimir Churyukin 20:47
Re: proposal: psql: psql variable BACKEND_PID Andres Freund 21:03
Re: refactoring relation extension and BufferAlloc(), faster COPY Heikki Linnakangas 21:03
Re: proposal: psql: psql variable BACKEND_PID Andres Freund 21:05
Re: refactoring relation extension and BufferAlloc(), faster COPY Andres Freund 21:36
Re: Improving inferred query column names Corey Huinker 21:51
Re: Transparent column encryption Mark Dilger 21:54
Re: refactoring relation extension and BufferAlloc(), faster COPY Andres Freund 22:04
Re: refactoring relation extension and BufferAlloc(), faster COPY Andres Freund 22:20
Re: refactoring relation extension and BufferAlloc(), faster COPY Andres Freund 22:25
Re: refactoring relation extension and BufferAlloc(), faster COPY Andres Freund 22:33
Re: Use pg_pwritev_with_retry() instead of write() in dir_open_for_write() to avoid partial writes? Andres Freund 22:44
Re: Importing pg_bsd_indent into our source tree 📎 Tom Lane 23:54

Feb. 12, 2023

Thread Author Time
Re: Importing pg_bsd_indent into our source tree 📎 Tom Lane 00:33
Re: Importing pg_bsd_indent into our source tree Andres Freund 00:42
Re: Importing pg_bsd_indent into our source tree Tom Lane 01:04
Re: Importing pg_bsd_indent into our source tree Tom Lane 01:32
Re: Importing pg_bsd_indent into our source tree 📎 Tom Lane 01:43
Re: Importing pg_bsd_indent into our source tree Thomas Munro 02:14
Making aggregate deserialization (and WAL receive) functions slightly faster 📎 David Rowley 05:38
Re: Making aggregate deserialization (and WAL receive) functions slightly faster Tom Lane 06:39
Re: Sort optimizations: Making in-memory sort cache-aware Ankit Kumar Pandey 08:13
Re: Making aggregate deserialization (and WAL receive) functions slightly faster David Rowley 10:43
Re: run pgindent on a regular basis / scripted manner Andrew Dunstan 14:16
Re: Use pg_pwritev_with_retry() instead of write() in dir_open_for_write() to avoid partial writes? 📎 Bharath Rupireddy 14:29
Re: Transparent column encryption Mark Dilger 14:48
Re: run pgindent on a regular basis / scripted manner Tom Lane 16:24
Re: Use pg_pwritev_with_retry() instead of write() in dir_open_for_write() to avoid partial writes? Andres Freund 17:31
Re: pgindent vs variable declaration across multiple lines 📎 Tom Lane 18:24
Re: run pgindent on a regular basis / scripted manner 📎 Andrew Dunstan 20:41
Re: run pgindent on a regular basis / scripted manner Justin Pryzby 20:59
Re: run pgindent on a regular basis / scripted manner Tom Lane 21:13
Re: ExecRTCheckPerms() and many prunable partitions (sqlsmith) Justin Pryzby 23:37
Re: Making Vars outer-join aware Justin Pryzby 23:58

Feb. 13, 2023

Thread Author Time
Re: Generating code for query jumbling through gen_node_support.pl Michael Paquier 00:11
Re: [PATCH] Add pretty-printed XML output option Peter Smith 01:15
Re: Time delayed LR (WAS Re: logical replication restrictions) Kyotaro Horiguchi 01:26
Re: Exit walsender before confirming remote flush in logical replication Kyotaro Horiguchi 01:56
Re: Fix GUC_NO_SHOW_ALL test scenario in 003_check_guc.pl Kyotaro Horiguchi 02:27
Re: Rework LogicalOutputPluginWriterUpdateProgress Amit Kapila 02:52
Re: Exit walsender before confirming remote flush in logical replication Amit Kapila 02:57
Re: Fix GUC_NO_SHOW_ALL test scenario in 003_check_guc.pl Michael Paquier 03:18
Re: Use pg_pwritev_with_retry() instead of write() in dir_open_for_write() to avoid partial writes? Michael Paquier 04:08
Re: Exit walsender before confirming remote flush in logical replication Peter Smith 04:09
RE: Time delayed LR (WAS Re: logical replication restrictions) Takamichi Osumi (Fujitsu) 04:18
Re: Support logical replication of DDLs Zheng Li 04:20
Re: Use pg_pwritev_with_retry() instead of write() in dir_open_for_write() to avoid partial writes? 📎 Bharath Rupireddy 04:45
Re: Support logical replication of DDLs Peter Smith 04:55
Force testing of query jumbling code in TAP tests 📎 Michael Paquier 05:00
Re: Introduce a new view for checkpointer related stats 📎 Bharath Rupireddy 06:01
Re: Reconcile stats in find_tabstat_entry() and get rid of PgStat_BackendFunctionEntry 📎 Drouvot, Bertrand 07:09
Re: Making Vars outer-join aware 📎 Richard Guo 07:33
Re: recovery modules Michael Paquier 07:37
Re: Reconcile stats in find_tabstat_entry() and get rid of PgStat_BackendFunctionEntry Kyotaro Horiguchi 07:40
Re: [PoC] Improve dead tuple storage for lazy vacuum Masahiko Sawada 07:50
Re: ExecRTCheckPerms() and many prunable partitions (sqlsmith) Amit Langote 08:14
Re: Rework LogicalOutputPluginWriterUpdateProgress Amit Kapila 08:36
Re: Time delayed LR (WAS Re: logical replication restrictions) Peter Smith 08:52
Re: Reconcile stats in find_tabstat_entry() and get rid of PgStat_BackendFunctionEntry 📎 Drouvot, Bertrand 08:58
Get rid of PgStat_BackendFunctionEntry 📎 Drouvot, Bertrand 09:06
Re: Support logical replication of DDLs Alvaro Herrera 09:07
Re: Consolidate ItemPointer to Datum conversion functions Peter Eisentraut 09:26
Re: Use pg_pwritev_with_retry() instead of write() in dir_open_for_write() to avoid partial writes? Kyotaro Horiguchi 09:33
Re: Killing off removed rels properly Richard Guo 09:57
Re: Time delayed LR (WAS Re: logical replication restrictions) Amit Kapila 10:21
Re: Rework of collation code, extensibility Peter Eisentraut 10:35
Re: psql - factor out echo code Peter Eisentraut 10:41
Re: Helper functions for wait_for_catchup() in Cluster.pm Alvaro Herrera 10:58
RE: [PATCH] Use indexes on the subscriber when REPLICA IDENTITY is full on the publisher [email protected] 11:00
Re: Can we do something to help stop users mistakenly using force_parallel_mode? 📎 David Rowley 11:16
Making CopyFromStateData not internal anymore Jelte Fennema 11:27
Re: [PATCH] Add pretty-printed XML output option Jim Jones 12:15
Re: run pgindent on a regular basis / scripted manner Andrew Dunstan 12:57
Re: run pgindent on a regular basis / scripted manner Andrew Dunstan 13:27
Re: amvalidate(): cache lookup failed for operator class 123 Justin Pryzby 13:50
Re: run pgindent on a regular basis / scripted manner Jelte Fennema 14:02
Re: [EXTERNAL] Re: [PATCH] Support using "all" for the db user in pg_ident.conf Pavel Luzanov 14:06
Re: [EXTERNAL] Re: [PATCH] Support using "all" for the db user in pg_ident.conf Jelte Fennema 14:13
ERROR: permission info at index 1 .... tender wang 14:32
[PATCH] Support SK_SEARCHNULL / SK_SEARCHNOTNULL for heap-only scans 📎 Aleksander Alekseev 14:59
Re: Helper functions for wait_for_catchup() in Cluster.pm Drouvot, Bertrand 15:07
Re: Minimal logical decoding on standbys 📎 Drouvot, Bertrand 15:27
Re: [PATCH] Support SK_SEARCHNULL / SK_SEARCHNOTNULL for heap-only scans Andres Freund 16:36
Re: run pgindent on a regular basis / scripted manner Andrew Dunstan 16:46
Re: Time delayed LR (WAS Re: logical replication restrictions) Andres Freund 16:47
Re: Making Vars outer-join aware Tom Lane 16:50
BRIN indexes vs. SK_SEARCHARRAY (and preprocessing scan keys) 📎 Tomas Vondra 17:01
Re: ExecRTCheckPerms() and many prunable partitions (sqlsmith) Tom Lane 17:01
Re: proposal: psql: psql variable BACKEND_PID Peter Eisentraut 17:06
Re: ERROR: permission info at index 1 .... Tom Lane 17:21
Re: proposal: psql: psql variable BACKEND_PID Pavel Stehule 17:33
Re: Use pg_pwritev_with_retry() instead of write() in dir_open_for_write() to avoid partial writes? Andres Freund 17:39
Re: proposal: psql: psql variable BACKEND_PID Andres Freund 17:42
Re: Force testing of query jumbling code in TAP tests Andres Freund 17:45
Re: proposal: psql: psql variable BACKEND_PID Tom Lane 17:52
Re: proposal: psql: psql variable BACKEND_PID Andres Freund 17:58
Re: Rework LogicalOutputPluginWriterUpdateProgress Andres Freund 18:00
Re: Rework LogicalOutputPluginWriterUpdateProgress Andres Freund 18:03
Re: jsonpath syntax extensions Alexander Iansiti 18:18
Re: proposal: psql: psql variable BACKEND_PID Pavel Stehule 18:24
Re: run pgindent on a regular basis / scripted manner Jelte Fennema 18:29
Re: ERROR: permission info at index 1 .... Alvaro Herrera 18:33
Re: Killing off removed rels properly Tom Lane 18:39
Adding "large" to PG_TEST_EXTRA Andres Freund 18:42
Re: Adding "large" to PG_TEST_EXTRA Stephen Frost 18:45
Re: Making Vars outer-join aware Justin Pryzby 18:48
[PATCH] Align GSS and TLS error handling in PQconnectPoll() 📎 Jacob Champion 18:49
Re: ICU locale validation / canonicalization Jeff Davis 18:52
Re: Adding "large" to PG_TEST_EXTRA Tom Lane 18:54
Re: Adding "large" to PG_TEST_EXTRA Andres Freund 19:06
Re: Adding "large" to PG_TEST_EXTRA Andres Freund 19:10
Re: Adding "large" to PG_TEST_EXTRA Stephen Frost 19:15
Re: Adding "large" to PG_TEST_EXTRA Andres Freund 19:34
Re: Adding "large" to PG_TEST_EXTRA Tom Lane 19:55
Re: Adding "large" to PG_TEST_EXTRA Andres Freund 20:32
Re: old_snapshot_threshold bottleneck on replica Andres Freund 20:45
Re: proposal: psql: psql variable BACKEND_PID Peter Eisentraut 21:05
Re: Adding "large" to PG_TEST_EXTRA Tom Lane 21:11
Re: REASSIGN OWNED vs ALTER TABLE OWNER TO permission inconsistencies Robert Haas 21:24
OID ordering dependency in pg_dump 📎 Tom Lane 21:26
Re: Adding "large" to PG_TEST_EXTRA Andrew Dunstan 21:46
Re: Adding "large" to PG_TEST_EXTRA Peter Smith 22:26
Re: recovery modules 📎 Nathan Bossart 22:56
pg_walinspect memory leaks Peter Geoghegan 23:22
[PATCH] Fix unbounded authentication exchanges during PQconnectPoll() 📎 Jacob Champion 23:22
Re: Improve logging when using Huge Pages 📎 Justin Pryzby 23:22
Re: recovery modules Andres Freund 23:37
Re: Adding "large" to PG_TEST_EXTRA Andres Freund 23:44
Re: Rework of collation code, extensibility 📎 Jeff Davis 23:45

Feb. 14, 2023

Thread Author Time
Re: pglz compression performance, take two Andres Freund 00:03
Re: pglz compression performance, take two Andrey Borodin 00:09
Re: Support for dumping extended statistics Andres Freund 00:16
Re: pgbench: using prepared BEGIN statement in a pipeline could cause an error Andres Freund 00:20
Buffer usage detailed by RelKind in EXPLAIN ANALYZE BUFFERS 📎 Andrey Borodin 00:23
Re: Add the ability to limit the amount of memory that can be allocated to backends. Andres Freund 00:26
Re: Buffer usage detailed by RelKind in EXPLAIN ANALYZE BUFFERS Andres Freund 00:29
Re: Make EXPLAIN generate a generic plan for a parameterized query Andres Freund 00:33
Re: Buffer usage detailed by RelKind in EXPLAIN ANALYZE BUFFERS Andrey Borodin 00:36
Re: Inconsistency in reporting checkpointer stats Andres Freund 00:38
Re: Adding "large" to PG_TEST_EXTRA Peter Smith 00:38
Re: Buffer usage detailed by RelKind in EXPLAIN ANALYZE BUFFERS Andres Freund 00:39
Re: Adding "large" to PG_TEST_EXTRA Andres Freund 00:43
Re: pg_walinspect memory leaks Andres Freund 00:55
Re: recovery modules 📎 Nathan Bossart 00:55
Re: recovery modules 📎 Nathan Bossart 01:02
Re: Exit walsender before confirming remote flush in logical replication Kyotaro Horiguchi 01:05
Re: Use pg_pwritev_with_retry() instead of write() in dir_open_for_write() to avoid partial writes? Andres Freund 01:10
Re: Move defaults toward ICU in 16? Jeff Davis 01:11
Re: Exit walsender before confirming remote flush in logical replication Andres Freund 01:13
Re: Fix GUC_NO_SHOW_ALL test scenario in 003_check_guc.pl Kyotaro Horiguchi 01:42
Re: Support logical replication of DDLs Peter Smith 01:43
Re: A new strategy for pull-up correlated ANY_SUBLINK Andy Fan 02:11
Re: Buffer usage detailed by RelKind in EXPLAIN ANALYZE BUFFERS 📎 Andrey Borodin 02:14
Re: Time delayed LR (WAS Re: logical replication restrictions) Kyotaro Horiguchi 02:27
Re: Buffer usage detailed by RelKind in EXPLAIN ANALYZE BUFFERS Andres Freund 02:43
Re: Some revises in adding sorting path David Rowley 02:53
RE: [PATCH] Reuse Workers and Replication Slots during Logical Replication [email protected] 03:36
Re: odd buildfarm failure - "pg_ctl: control file appears to be corrupt" Anton A. Melnikov 03:38
Re: Improve logging when using Huge Pages Nathan Bossart 04:18
Re: Todo: Teach planner to evaluate multiple windows in the optimal order 📎 John Naylor 04:21
Re: ExecRTCheckPerms() and many prunable partitions (sqlsmith) Amit Langote 05:44
Re: Perform streaming logical transactions by background workers and parallel apply Amit Kapila 06:04
Re: Reconcile stats in find_tabstat_entry() and get rid of PgStat_BackendFunctionEntry Kyotaro Horiguchi 06:11
RE: Time delayed LR (WAS Re: logical replication restrictions) Takamichi Osumi (Fujitsu) 06:22
Re: Perform streaming logical transactions by background workers and parallel apply Peter Smith 06:58
Re: Force testing of query jumbling code in TAP tests Michael Paquier 07:04
Re: Use pg_pwritev_with_retry() instead of write() in dir_open_for_write() to avoid partial writes? Michael Paquier 07:06
Re: [PATCH] Support SK_SEARCHNULL / SK_SEARCHNOTNULL for heap-only scans 📎 Aleksander Alekseev 09:10
Re: Support logical replication of DDLs Alvaro Herrera 09:27
RE: [PATCH] Use indexes on the subscriber when REPLICA IDENTITY is full on the publisher [email protected] 09:35
Re: [PoC] Reducing planning time when tables have many partitions Andrey Lepikhov 10:01
RE: Support logical replication of DDLs [email protected] 10:28
Re: pg_walinspect memory leaks Bharath Rupireddy 10:37
Re: Todo: Teach planner to evaluate multiple windows in the optimal order David Rowley 10:45
Re: Support logical replication of DDLs Amit Kapila 11:02
Re: Reduce timing overhead of EXPLAIN ANALYZE using rdtsc? 📎 David Geier 11:11
Re: [PoC] Improve dead tuple storage for lazy vacuum 📎 John Naylor 11:24
Re: Use pg_pwritev_with_retry() instead of write() in dir_open_for_write() to avoid partial writes? 📎 Bharath Rupireddy 12:30

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