pgsql-hackers - January 2022

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 30 31

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 [email protected] 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
Re: PostgreSQL stops when adding a breakpoint in CLion Stanislav Bashkyrtsev 08:26
Re: SQL/JSON: functions Himanshu Upadhyaya 09:18
Re: Patch to avoid orphaned dependencies 📎 Drouvot, Bertrand 09:28
Re: SQL/JSON: functions Pavel Stehule 09:55
Re: Clarify planner_hook calling convention Andrey V. Lepikhov 10:44
Re: [PATCH] pg_stat_toast v6 Gunnar "Nick" Bluth 11:11
Re: [PATCH] pg_stat_toast v6 📎 Gunnar "Nick" Bluth 11:29
RE: Failed transaction statistics to measure the logical replication progress 📎 [email protected] 11:47
Re: Documenting when to retry on serialization failure Simon Riggs 11:49
RE: Failed transaction statistics to measure the logical replication progress [email protected] 11:52
Re: pg_dump/restore --no-tableam Michael Paquier 12:01
Re: Report checkpoint progress in server logs Michael Paquier 12:11
Re: [PATCH] allow src/tools/msvc/*.bat files to be called from the root of the source tree Michael Paquier 12:20
Re: Converting WAL to SQL Michael Paquier 12:22
Re: toast tables and toast indexes Michael Paquier 12:30
Re: [PATCH] allow src/tools/msvc/*.bat files to be called from the root of the source tree Andrew Dunstan 13:37
Re: Converting WAL to SQL Fabrízio de Royes Mello 13:47
Re: daitch_mokotoff module 📎 Dag Lem 13:49
Re: SQL/JSON: functions Andrew Dunstan 13:53
Index-only scan for btree_gist turns bpchar to char Alexander Lakhin 14:00
Re: SQL/JSON: functions 📎 Andrew Dunstan 14:01
Re: SQL/JSON: JSON_TABLE 📎 Andrew Dunstan 14:03
Re: [PATCH] Allow multiple recursive self-references Peter Eisentraut 14:18
Re: [PATCH] Allow multiple recursive self-references Peter Eisentraut 14:24
Re: CREATEROLE and role ownership hierarchies Joshua Brindle 14:35
Re: refactoring basebackup.c Robert Haas 14:37
Re: Proposal: remove obsolete hot-standby testing infrastructure Tom Lane 15:33
Re: ICU for global collation Peter Eisentraut 16:03
Re: SKIP LOCKED assert triggered Alvaro Herrera 16:03
Re: SKIP LOCKED assert triggered Alvaro Herrera 16:13
Re: SKIP LOCKED assert triggered Tom Lane 16:15
Re: pg_walinspect - a new extension to get raw WAL data and WAL stats 📎 Bharath Rupireddy 16:31
Re: SKIP LOCKED assert triggered Justin Pryzby 16:55
Re: CREATEROLE and role ownership hierarchies Mark Dilger 17:07
biblio.sgml dead link Erik Rijkers 17:10
Re: Add 64-bit XIDs into PostgreSQL 15 Finnerty, Jim 17:49
Re: Proposal: remove obsolete hot-standby testing infrastructure Alexander Lakhin 19:00
Re: Index-only scan for btree_gist turns bpchar to char Tom Lane 19:19
Re: Add 64-bit XIDs into PostgreSQL 15 Stephen Frost 19:32
Re: generalized conveyor belt storage 📎 Robert Haas 19:42
Re: SKIP LOCKED assert triggered Simon Riggs 20:09
Re: daitch_mokotoff module Thomas Munro 20:18
Re: CREATEROLE and role ownership hierarchies Mark Dilger 20:39
Re: psql: \dl+ to list large objects privileges 📎 Tom Lane 20:42
Re: CREATEROLE and role ownership hierarchies Joshua Brindle 20:47
Re: [PATCH v2] use has_privs_for_role for predefined roles Tom Lane 20:56
Re: preserve timestamps when installing headers Tom Lane 21:21
Re: [PATCH v2] use has_privs_for_role for predefined roles 📎 Joshua Brindle 21:51
Re: A spot of redundant initialization of brin memtuple Tom Lane 21:54
Re: Add 64-bit XIDs into PostgreSQL 15 Finnerty, Jim 22:22
Re: Consider parallel for lateral subqueries with limit Tom Lane 22:30
Re: [PATCH] Accept IP addresses in server certificate SANs 📎 Jacob Champion 22:58
Re: pg_stat_statements and "IN" conditions Tom Lane 23:02
Re: Patch to avoid orphaned dependencies Zhihong Yu 23:04
Re: using extended statistics to improve join estimates Andres Freund 23:55
Re: [PoC] Delegating pg_ident to a third party Jacob Champion 23:56
Re: PoC: using sampling to estimate joins / complex conditions Andres Freund 23:58

Jan. 5, 2022

Thread Author Time
Re: In-placre persistance change of a relation Andres Freund 00:05
Re: biblio.sgml dead link Michael Paquier 01:26
Re: Delay the variable initialization in get_rel_sync_entry Michael Paquier 01:30
RE: row filtering for logical replication [email protected] 02:05
Re: Converting WAL to SQL Michael Paquier 02:37
Re: GUC flags Kyotaro Horiguchi 02:47
Re: [HACKERS] logical decoding of two-phase transactions Amit Kapila 02:51
Re: Consider parallel for lateral subqueries with limit James Coleman 02:59
Re: GUC flags Justin Pryzby 03:06
Re: Suggestion: optionally return default value instead of error on failed cast Corey Huinker 03:17
Re: [PoC] Delegating pg_ident to a third party Stephen Frost 03:24
Re: Skipping logical replication transactions on subscriber side Amit Kapila 03:30
Re: Skipping logical replication transactions on subscriber side Dilip Kumar 04:18
Re: pg_stat_statements and "IN" conditions Andrey V. Lepikhov 04:37
Emit "checkpoint skipped because system is idle" message at LOG level if log_checkpoints is set 📎 Bharath Rupireddy 04:54

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 30 31