pgsql-hackers since 2021-12-30 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)

Browse Archives

Prev | Next

Dec. 30, 2021

Thread Author Time
Re: Column Filtering in Logical Replication πŸ“Ž Alvaro Herrera 00:15
Re: PublicationActions - use bit flags. πŸ“Ž Peter Smith 00:31
Re: PublicationActions - use bit flags. Tom Lane 00:36
Tests "with" and "alter_table" suffer from name clash πŸ“Ž Thomas Munro 02:12
Re: Tests "with" and "alter_table" suffer from name clash Tom Lane 02:27
Re: Tests "with" and "alter_table" suffer from name clash Thomas Munro 04:25
Re: Tests "with" and "alter_table" suffer from name clash Tom Lane 04:50
Re: Throttling WAL inserts when the standby falls behind more than the configured replica_lag_in_bytes Dilip Kumar 06:38
RE: Confused comment about drop replica identity index houzj.fnst@fujitsu.com 06:45
Re: Throttling WAL inserts when the standby falls behind more than the configured replica_lag_in_bytes SATYANARAYANA NARLAPURAM 07:06
Re: Per-table storage parameters for TableAM/IndexAM extensions Dilip Kumar 07:44
Re: Throttling WAL inserts when the standby falls behind more than the configured replica_lag_in_bytes Dilip Kumar 07:50
Re: Throttling WAL inserts when the standby falls behind more than the configured replica_lag_in_bytes Bharath Rupireddy 08:11
Re: Throttling WAL inserts when the standby falls behind more than the configured replica_lag_in_bytes Dilip Kumar 08:19
Re: warn if GUC set to an invalid shared library Bharath Rupireddy 08:20
Re: Throttling WAL inserts when the standby falls behind more than the configured replica_lag_in_bytes SATYANARAYANA NARLAPURAM 08:44
RE: row filtering for logical replication wangw.fnst@fujitsu.com 08:57
Re: Add Boolean node Peter Eisentraut 08:58
Autovacuum and idle_session_timeout Guillaume Lelarge 09:18
Re: Non-decimal integer literals πŸ“Ž Peter Eisentraut 09:43
Re: Autovacuum and idle_session_timeout Japin Li 10:44
Re: Autovacuum and idle_session_timeout Guillaume Lelarge 10:53
Re: Foreign key joins revisited Joel Jacobson 10:56
Re: Autovacuum and idle_session_timeout πŸ“Ž Japin Li 11:01
Fix BUG #17335: Duplicate result rows in Gather node πŸ“Ž Yura Sokolov 11:14
Re: Pre-allocating WAL files Pavel Borisov 11:45
Re: Pre-allocating WAL files Maxim Orlov 11:51
Re: ICU for global collation πŸ“Ž Peter Eisentraut 12:07
Add 64-bit XIDs into PostgreSQL 15 πŸ“Ž Maxim Orlov 12:15
Re: Fix BUG #17335: Duplicate result rows in Gather node Dilip Kumar 12:29
Re: Autovacuum and idle_session_timeout Guillaume Lelarge 13:18
RE: row filtering for logical replication πŸ“Ž houzj.fnst@fujitsu.com 13:39
Re: Autovacuum and idle_session_timeout Tom Lane 16:24
Pluggable toaster πŸ“Ž Teodor Sigaev 16:40
Re: Strange path from pgarch_readyXlog() Bossart, Nathan 16:50
Re: Autovacuum and idle_session_timeout Guillaume Lelarge 17:01
Re: Throttling WAL inserts when the standby falls behind more than the configured replica_lag_in_bytes Andres Freund 19:26
Why is src/test/modules/committs/t/002_standby.pl flaky? Thomas Munro 20:01
Re: Column Filtering in Logical Replication πŸ“Ž Alvaro Herrera 20:21
Re: pg_stat_bgwriter.buffers_backend is pretty meaningless (and more?) Melanie Plageman 20:30
Re: Why is src/test/modules/committs/t/002_standby.pl flaky? Andrew Dunstan 20:35
Re: Column Filtering in Logical Replication Justin Pryzby 22:16
More pg_dump performance hacking πŸ“Ž Tom Lane 22:28
Re: Column Filtering in Logical Replication πŸ“Ž Alvaro Herrera 23:32

Dec. 31, 2021

Thread Author Time
Re: Apple's ranlib warns about protocol_openssl.c Andres Freund 00:49
Re: Apple's ranlib warns about protocol_openssl.c Tom Lane 01:03
RE: Failed transaction statistics to measure the logical replication progress tanghy.fnst@fujitsu.com 01:12
RE: row filtering for logical replication πŸ“Ž houzj.fnst@fujitsu.com 01:42
Re: Adding CI to our tree πŸ“Ž Andres Freund 01:46
Re: Autovacuum and idle_session_timeout Japin Li 02:01
Re: generic plans and "initial" pruning Amit Langote 02:26
Re: Adding CI to our tree Justin Pryzby 02:28
Re: Adding CI to our tree Andres Freund 03:03
Re: Adding CI to our tree Andres Freund 03:17
Re: Add index scan progress to pg_stat_progress_vacuum πŸ“Ž Imseih (AWS), Sami 05:59
Re: Patch to avoid orphaned dependencies Andres Freund 06:03
RE: [PATCH]Comment improvement in publication.sql tanghy.fnst@fujitsu.com 06:13
Re: skip replication slot snapshot/map file removal during end-of-recovery checkpoint πŸ“Ž Bharath Rupireddy 06:14
Re: add checkpoint stats of snapshot and mapping files of pg_logical dir Bharath Rupireddy 06:39
libpq compression (part 2) πŸ“Ž Daniil Zakhlystov 09:26
Avoid erroring out when unable to remove or parse logical rewrite files to save checkpoint work πŸ“Ž Bharath Rupireddy 12:42
Re: Parameter for planner estimate of recursive queries Simon Riggs 14:10
Re: Adding CI to our tree Alvaro Herrera 14:14
Introducing PgVA aka PostgresVectorAcceleration using SIMD vector instructions starting with hex_encode Hans Buschmann 15:31
AW: Introducing PgVA aka PostgresVectorAcceleration using SIMD vector instructions starting with hex_encode πŸ“Ž Hans Buschmann 15:34
Re: Extend compatibility of PostgreSQL::Test::Cluster Dagfinn Ilmari MannsΓ₯ker 16:20
Re: Extend compatibility of PostgreSQL::Test::Cluster Andrew Dunstan 16:22
Re: Column Filtering in Logical Replication Justin Pryzby 16:32
Re: Add header support to text format and matching feature πŸ“Ž RΓ©mi Lapeyre 17:36
slowest tap tests - split or accelerate? Andres Freund 19:25
Re: Use generation context to speed up tuplesorts πŸ“Ž David Rowley 21:26
Collecting statistics about contents of JSONB columns πŸ“Ž Tomas Vondra 22:06

Jan. 1, 2022

Thread Author Time
Re: Speed up transaction completion faster after many relations are accessed in a transaction πŸ“Ž David Rowley 01:44
Re: Fix BUG #17335: Duplicate result rows in Gather node David Rowley 02:19
Re: Speed up transaction completion faster after many relations are accessed in a transaction Zhihong Yu 02:43
Re: Probable memory leak with ECPG and AIX Noah Misch 07:40
Re: Foreign key joins revisited Joel Jacobson 09:53
Updatable Views and INSERT INTO ... ON CONFLICT Joel Jacobson 12:52
Re: Collecting statistics about contents of JSONB columns Zhihong Yu 15:33
Re: Probable memory leak with ECPG and AIX Tom Lane 16:35
Re: using extended statistics to improve join estimates πŸ“Ž Tomas Vondra 17:21
Re: libpq compression (part 2) πŸ“Ž Justin Pryzby 17:25
Re: Collecting statistics about contents of JSONB columns Zhihong Yu 21:16

Jan. 2, 2022

Thread Author Time
Re: Probable memory leak with ECPG and AIX Noah Misch 00:07
Re: pg_ls_tmpdir to show directories and shared filesets (and pg_ls_*) Fabien COELHO 12:07
Re: pg_ls_tmpdir to show directories and shared filesets (and pg_ls_*) Fabien COELHO 13:55
Re: Refactoring the regression tests for more independence Justin Pryzby 17:49
Index-only scans vs. partially-retrievable indexes Tom Lane 19:14
Re: O(n) tasks cause lengthy startups and checkpoints Andres Freund 21:26
Re: [PATCH] Tracking statements entry timestamp in pg_stat_statements Andres Freund 21:28
Re: [PATCH] Accept IP addresses in server certificate SANs Andres Freund 21:29
Re: daitch_mokotoff module Andres Freund 21:31
Re: Add jsonlog log_destination for JSON server logs Andres Freund 21:34
Re: Index-only scans vs. partially-retrievable indexes πŸ“Ž Tom Lane 23:22

Jan. 3, 2022

Thread Author Time
Re: daitch_mokotoff module Thomas Munro 01:47
Re: daitch_mokotoff module Tom Lane 02:41
Re: Multi-Column List Partitioning Amul Sul 04:03
Remove inconsistent quotes from date_part error πŸ“Ž Nikhil Benesch 04:47
pg_receivewal fail to streams when the partial file to write is not fully initialized present in the wal receiver directory πŸ“Ž SATYANARAYANA NARLAPURAM 05:27
RE: Failed transaction statistics to measure the logical replication progress houzj.fnst@fujitsu.com 05:46
Use MaxLockMode in lock methods initialization πŸ“Ž Julien Rouhaud 06:47
Re: O(n) tasks cause lengthy startups and checkpoints Amul Sul 06:59
Re: Schema variables - new implementation for Postgres 15 πŸ“Ž Pavel Stehule 07:17
Clarify planner_hook calling convention πŸ“Ž Andrey V. Lepikhov 07:33
Re: Confused comment about drop replica identity index Michael Paquier 07:47
Re: pg_receivewal fail to streams when the partial file to write is not fully initialized present in the wal receiver directory Michael Paquier 07:56
Re: Use MaxLockMode in lock methods initialization Michael Paquier 08:00
Re: Remove inconsistent quotes from date_part error Michael Paquier 08:17
Re: An obsolete comment of pg_stat_statements Michael Paquier 08:36
Re: Add Boolean node πŸ“Ž Peter Eisentraut 11:04
Re: Index-only scans vs. partially-retrievable indexes Andrey Borodin 11:13
Re: libpq compression (part 2) Andrey Borodin 11:16
Remove extra spaces πŸ“Ž Suraj Kharage 13:05
Re: daitch_mokotoff module Dag Lem 13:07
Re: Add Boolean node πŸ“Ž Peter Eisentraut 13:18
Re: Synchronizing slots from primary to standby πŸ“Ž Peter Eisentraut 13:46
Re: refactoring basebackup.c tushar 14:09
Re: Column Filtering in Logical Replication πŸ“Ž Alvaro Herrera 14:31
Re: Foreign key joins revisited Joel Jacobson 14:39
Re: Column Filtering in Logical Replication Justin Pryzby 14:40
Re: Remove inconsistent quotes from date_part error Nikhil Benesch 14:53
Re: Index-only scans vs. partially-retrievable indexes Tom Lane 14:57
Re: Column Filtering in Logical Replication Alvaro Herrera 15:01
Re: Remove inconsistent quotes from date_part error Tom Lane 15:11
Re: Remove inconsistent quotes from date_part error Nikhil Benesch 15:12
Re: Remove inconsistent quotes from date_part error Tom Lane 15:20
Re: Remove inconsistent quotes from date_part error Nikhil Benesch 15:26
Re: Refactoring of compression options in pg_basebackup gkokolatos 15:35
Re: [PATCH] pg_stat_toast v0.4 πŸ“Ž Gunnar "Nick" Bluth 15:52
PostgreSQL stops when adding a breakpoint in CLion Stanislav Bashkyrtsev 15:54
Re: Remove inconsistent quotes from date_part error πŸ“Ž Nikhil Benesch 15:57
Re: Clarify planner_hook calling convention Tom Lane 15:59
Re: [PATCH] pg_stat_toast v0.4 πŸ“Ž Gunnar "Nick" Bluth 16:00
Re: [PATCH] Accept IP addresses in server certificate SANs Jacob Champion 16:19
Re: [PATCH] Accept IP addresses in server certificate SANs Jacob Champion 16:21
Re: Remove extra spaces Tom Lane 16:23
Re: daitch_mokotoff module Tom Lane 16:34
Re: psql - add SHOW_ALL_RESULTS option Peter Eisentraut 16:35
Re: Index-only scans vs. partially-retrievable indexes Andrey Borodin 16:36
Re: [PoC] Delegating pg_ident to a third party Jacob Champion 16:46
Re: [PATCH] pg_stat_toast v0.4 Justin Pryzby 16:50
Re: refactoring basebackup.c tushar 17:12
Re: Proposal: sslmode=tls-only Jacob Champion 17:24
Re: Use MaxLockMode in lock methods initialization Tom Lane 17:27
Re: [PoC] Delegating pg_ident to a third party Stephen Frost 17:36
Re: [PATCH] pg_stat_toast v0.4 πŸ“Ž Gunnar "Nick" Bluth 18:01
Re: Add spin_delay() implementation for Arm in s_lock.h Blake, Geoff 18:11
Re: Remove inconsistent quotes from date_part error πŸ“Ž Tom Lane 18:14
Re: [PoC] Delegating pg_ident to a third party Jacob Champion 18:29
Re: [PATCH] pg_stat_toast v0.4 Alvaro Herrera 18:30
Re: Introducing PgVA aka PostgresVectorAcceleration using SIMD vector instructions starting with hex_encode John Naylor 18:34
Re: Remove inconsistent quotes from date_part error Alvaro Herrera 18:35
TYPCATEGORY_{NETWORK,USER} [was Dubious usage of TYPCATEGORY_STRING] Chapman Flack 18:36
Re: [PATCH] pg_stat_toast v0.4 πŸ“Ž Gunnar "Nick" Bluth 18:42
Re: PostgreSQL stops when adding a breakpoint in CLion Tomas Vondra 18:52
Re: Remove inconsistent quotes from date_part error Nikhil Benesch 18:54
Re: Throttling WAL inserts when the standby falls behind more than the configured replica_lag_in_bytes Ashwin Agrawal 18:55
Re: TYPCATEGORY_{NETWORK,USER} [was Dubious usage of TYPCATEGORY_STRING] Tom Lane 18:55
Re: Remove inconsistent quotes from date_part error Tom Lane 19:05
Re: PostgreSQL stops when adding a breakpoint in CLion Tom Lane 19:08
Re: [PATCH] pg_stat_toast v0.4 Alvaro Herrera 19:11
Re: daitch_mokotoff module Andres Freund 19:16
Re: [PATCH] pg_stat_toast v6 πŸ“Ž Gunnar "Nick" Bluth 19:40
Re: TYPCATEGORY_{NETWORK,USER} [was Dubious usage of TYPCATEGORY_STRING] Chapman Flack 19:54
Re: [PATCH] pg_stat_toast v6 Justin Pryzby 19:56
Re: pg_receivewal fail to streams when the partial file to write is not fully initialized present in the wal receiver directory SATYANARAYANA NARLAPURAM 20:10
Re: PostgreSQL stops when adding a breakpoint in CLion Stanislav Bashkyrtsev 20:26
Re: [PATCH] pg_stat_toast v6 Justin Pryzby 21:03
Re: [PATCH] pg_stat_toast v6 Alvaro Herrera 21:23
Re: pg_dump/restore --no-tableam πŸ“Ž Justin Pryzby 21:44
Proposal: remove obsolete hot-standby testing infrastructure πŸ“Ž Tom Lane 21:50
Re: PostgreSQL stops when adding a breakpoint in CLion Tom Lane 22:02
Re: CREATEROLE and role ownership hierarchies Andrew Dunstan 22:08
Accessing fields past CATALOG_VARLEN Ed Behn 22:23
Re: SKIP LOCKED assert triggered πŸ“Ž Alvaro Herrera 22:27
Re: Accessing fields past CATALOG_VARLEN Chapman Flack 22:32
Re: Accessing fields past CATALOG_VARLEN Tom Lane 22:35
Re: Bug fix for tab completion of ALTER TABLE ... VALIDATE CONSTRAINT ... Tom Lane 23:15
Re: What does RIR as in fireRIRrules stand for? fred yin 23:29
Re: What does RIR as in fireRIRrules stand for? Tom Lane 23:40

Jan. 4, 2022

Thread Author Time
Re: [PoC] Delegating pg_ident to a third party Stephen Frost 00:42
Re: An obsolete comment of pg_stat_statements Kyotaro Horiguchi 00:54
Re: more descriptive message for process termination due to max_slot_wal_keep_size Kyotaro Horiguchi 01:29
Re: pg_stat_bgwriter.buffers_backend is pretty meaningless (and more?) πŸ“Ž Melanie Plageman 01:39
Re: Add checkpoint and redo LSN to LogCheckpointEnd log message Kyotaro Horiguchi 01:49
Re: ICU for global collation Julien Rouhaud 02:21
Re: Allow escape in application_name Kyotaro Horiguchi 03:04
Re: [HACKERS] logical decoding of two-phase transactions Masahiko Sawada 03:30
Re: Allow escape in application_name Masahiko Sawada 03:36
Re: why does reindex invalidate relcache without modifying system tables wenjing zeng 03:46
Re: row filtering for logical replication πŸ“Ž Peter Smith 04:28
Re: row filtering for logical replication Peter Smith 04:53
Re: row filtering for logical replication Peter Smith 04:55
Re: Allow escape in application_name Kyotaro Horiguchi 05:03
Re: Inconsistent ellipsis in regression test error message? Peter Smith 06:03
Re: psql: \dl+ to list large objects privileges Justin Pryzby 06:24
Re: row filtering for logical replication Peter Smith 06:45
Re: Per-table storage parameters for TableAM/IndexAM extensions Rushabh Lathia 07:32
Re: psql - add SHOW_ALL_RESULTS option Fabien COELHO 07:55
Re: Proposal: remove obsolete hot-standby testing infrastructure Alexander Lakhin 08:00

Browse Archives

Prev | Next