pgsql-hackers since 2022-09-22 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

Sept. 22, 2022

Thread Author Time
pg_basebackup --create-slot-if-not-exists? Ashwin Agrawal 00:07
Re: pg_basebackup's --gzip switch misbehaves Justin Pryzby 00:31
Re: pg_basebackup --create-slot-if-not-exists? David G. Johnston 00:34
Re: pg_basebackup --create-slot-if-not-exists? Michael Paquier 00:46
Re: make additional use of optimized linear search routines Michael Paquier 00:52
Re: pg_basebackup --create-slot-if-not-exists? Tom Lane 01:12
Re: pg_basebackup's --gzip switch misbehaves 📎 Michael Paquier 01:25
Re: pg_receivewal fail to streams when the partial file to write is not fully initialized present in the wal receiver directory 📎 Bharath Rupireddy 01:46
Re: Making C function declaration parameter names consistent with corresponding definition names 📎 Peter Geoghegan 01:58
Re: why can't a table be part of the same publication as its schema Amit Kapila 02:00
Re: binary version of pg_current_wal_insert_lsn and pg_walfile_name functions Bharath Rupireddy 02:10
RE: Allow logical replication to copy tables in binary format [email protected] 03:22
RE: Perform streaming logical transactions by background workers and parallel apply 📎 [email protected] 03:29
RE: [PATCH] Use indexes on the subscriber when REPLICA IDENTITY is full on the publisher [email protected] 03:36
Re: pg_basebackup's --gzip switch misbehaves Justin Pryzby 03:37
Re: pg_basebackup's --gzip switch misbehaves Tom Lane 03:43
Re: Query JITing with LLVM ORC João Paulo Labegalini de Carvalho 03:53
Re: Fix snapshot name for SET TRANSACTION documentation Fujii Masao 04:00
Re: make additional use of optimized linear search routines Nathan Bossart 04:12
Re: Reducing the WAL overhead of freezing in VACUUM by deduplicating per-tuple freeze plans Nathan Bossart 04:21
Re: Reducing the WAL overhead of freezing in VACUUM by deduplicating per-tuple freeze plans Nathan Bossart 04:22
Re: pg_basebackup's --gzip switch misbehaves Michael Paquier 04:34
Re: pg_receivewal fail to streams when the partial file to write is not fully initialized present in the wal receiver directory Michael Paquier 04:37
Re: [PoC] Improve dead tuple storage for lazy vacuum John Naylor 04:46
Re: pg_basebackup's --gzip switch misbehaves Tom Lane 04:47
Re: [EXTERNAL] Re: [PoC] Federated Authn/z with OAUTHBEARER Andrey Chudnovsky 04:55
Re: Background writer and checkpointer in crash recovery Michael Paquier 05:33
Re: pg_receivewal fail to streams when the partial file to write is not fully initialized present in the wal receiver directory Bharath Rupireddy 05:37
pgsql: meson: Add initial version of meson based build system Andres Freund 05:47
Re: [RFC] building postgres with meson - v13 Andres Freund 05:57
Re: [PoC] Improve dead tuple storage for lazy vacuum Masahiko Sawada 06:26
Re: Schema variables - new implementation for Postgres 15 📎 Julien Rouhaud 06:40
Re: Multi-insert related comment in CopyFrom() Etsuro Fujita 07:11
Re: Refactor backup related code (was: Is it correct to say, "invalid data in file \"%s\"", BACKUP_LABEL_FILE in do_pg_backup_stop?) 📎 Michael Paquier 07:43
RE: Perform streaming logical transactions by background workers and parallel apply [email protected] 08:07
Re: [RFC] building postgres with meson - v13 Andrew Dunstan 08:29
RE: Perform streaming logical transactions by background workers and parallel apply [email protected] 08:57
Re: Perform streaming logical transactions by background workers and parallel apply Amit Kapila 09:00
Re: Refactor backup related code (was: Is it correct to say, "invalid data in file \"%s\"", BACKUP_LABEL_FILE in do_pg_backup_stop?) Fujii Masao 09:47
Re: Perform streaming logical transactions by background workers and parallel apply Amit Kapila 10:11
cannot to compile master in llvm_resolve_symbols Pavel Stehule 10:42
Re: cannot to compile master in llvm_resolve_symbols Thomas Munro 10:54
Re: cannot to compile master in llvm_resolve_symbols Pavel Stehule 10:59
RE: Perform streaming logical transactions by background workers and parallel apply [email protected] 11:20
Re: pg_basebackup's --gzip switch misbehaves Michael Paquier 11:21
Re: [PoC] Let libpq reject unexpected authentication requests Peter Eisentraut 11:52
Re: archive modules Peter Eisentraut 11:54
Re: why can't a table be part of the same publication as its schema Alvaro Herrera 12:02
Re: [PoC] Improve dead tuple storage for lazy vacuum John Naylor 12:52
Re: Pruning never visible changes Simon Riggs 13:10
Re: Fix snapshot name for SET TRANSACTION documentation Japin Li 13:16
Re: why can't a table be part of the same publication as its schema Jonathan S. Katz 14:04
Re: RFC: Logging plan of the running query torikoshia 14:12
Re: Pruning never visible changes Alvaro Herrera 14:15
Re: [PoC] Improve dead tuple storage for lazy vacuum John Naylor 14:37
Re: [RFC] building postgres with meson - v13 Tom Lane 14:49
Re: [RFC] building postgres with meson - v13 Alvaro Herrera 14:56
Re: [RFC] building postgres with meson - v13 Tom Lane 15:04
Re: [RFC] building postgres with meson - v13 Andres Freund 15:05
Re: [RFC] building postgres with meson - v13 Andres Freund 15:05
Re: Tab complete for CREATE SUBSCRIPTION ... CONECTION does not work 📎 Japin Li 15:08
Re: proposal: possibility to read dumped table's name from file Andres Freund 15:10
Re: [PoC] Improve dead tuple storage for lazy vacuum John Naylor 15:11
Re: [PATCH] Improve amcheck to also check UNIQUE constraint in btree index. Andres Freund 15:13
Re: pg_waldump: add test for coverage Andres Freund 15:16
Re: Amcheck verification of GiST and GIN Andres Freund 15:19
Re: [RFC] building postgres with meson - v13 Alvaro Herrera 15:21
Re: Summary function for pg_buffercache 📎 Melih Mutlu 15:22
Re: [PATCH] Introduce array_shuffle() and array_sample() Andres Freund 15:23
Re: Refactor backup related code (was: Is it correct to say, "invalid data in file \"%s\"", BACKUP_LABEL_FILE in do_pg_backup_stop?) Andres Freund 15:25
Re: Add last_vacuum_index_scans in pg_stat_all_tables Andres Freund 15:28
Re: Extending outfuncs support to utility statements Andres Freund 15:32
Re: [PATCH] Introduce array_shuffle() and array_sample() 📎 Martin Kalcher 15:40
Re: Temporary file access API John Morris 15:42
Re: libpq error message refactoring Andres Freund 15:42
Re: Summary function for pg_buffercache Andres Freund 16:10
Re: [PATCH] Use indexes on the subscriber when REPLICA IDENTITY is full on the publisher Önder Kalacı 16:13
Re: [PATCH] Use indexes on the subscriber when REPLICA IDENTITY is full on the publisher 📎 Önder Kalacı 16:13
Re: Extending outfuncs support to utility statements Tom Lane 16:16
Re: Extending outfuncs support to utility statements Tom Lane 16:48
Re: Reducing the WAL overhead of freezing in VACUUM by deduplicating per-tuple freeze plans Peter Geoghegan 16:51
Re: binary version of pg_current_wal_insert_lsn and pg_walfile_name functions 📎 Ashutosh Sharma 16:54
Re: Extending outfuncs support to utility statements Andres Freund 17:01
Re: Mingw task for Cirrus CI Andres Freund 17:03
Re: ICU for global collation 📎 Marina Polyakova 18:06
Re: archive modules Nathan Bossart 18:46
Re: Pruning never visible changes Simon Riggs 20:04
Re: [RFC] building postgres with meson - v13 Nathan Bossart 20:05
Re: [RFC] building postgres with meson - v13 Peter Geoghegan 20:21
Re: [RFC] building postgres with meson - v13 Andres Freund 20:28
Re: Extending outfuncs support to utility statements 📎 Tom Lane 20:57
Re: CI and test improvements Justin Pryzby 21:07
Re: Adding CommandID to heap xlog records 📎 Matthias van de Meent 21:12
Re: Consider parallel for lateral subqueries with limit James Coleman 21:19
Re: Extending outfuncs support to utility statements Tom Lane 21:21
Re: Making C function declaration parameter names consistent with corresponding definition names 📎 Peter Geoghegan 21:41
cfbot vs. changes in the set of CI tasks Tom Lane 21:44
Re: [RFC] building postgres with meson - v13 Andres Freund 21:50
Re: CI and test improvements Andres Freund 21:53
Re: [EXTERNAL] Re: [PoC] Federated Authn/z with OAUTHBEARER Jacob Champion 21:53
Re: Making C function declaration parameter names consistent with corresponding definition names Tom Lane 21:55
Re: [RFC] building postgres with meson - v13 Peter Geoghegan 22:04
Re: Making C function declaration parameter names consistent with corresponding definition names Peter Geoghegan 22:14
Re: cfbot vs. changes in the set of CI tasks Thomas Munro 22:17
Re: Making C function declaration parameter names consistent with corresponding definition names Tom Lane 22:20
Re: [RFC] building postgres with meson - v13 Nathan Bossart 22:37
Re: cfbot vs. changes in the set of CI tasks Thomas Munro 22:42
Re: cfbot vs. changes in the set of CI tasks Tom Lane 22:57
Re: cfbot vs. changes in the set of CI tasks Andres Freund 23:46
Re: Making C function declaration parameter names consistent with corresponding definition names Peter Geoghegan 23:46
Re: cfbot vs. changes in the set of CI tasks Tom Lane 23:50

Sept. 23, 2022

Thread Author Time
Re: [PoC] Let libpq reject unexpected authentication requests 📎 Jacob Champion 00:02
Re: pg_basebackup --create-slot-if-not-exists? Ashwin Agrawal 00:18
Re: Refactor backup related code (was: Is it correct to say, "invalid data in file \"%s\"", BACKUP_LABEL_FILE in do_pg_backup_stop?) Bharath Rupireddy 00:31
Re: Refactor backup related code (was: Is it correct to say, "invalid data in file \"%s\"", BACKUP_LABEL_FILE in do_pg_backup_stop?) 📎 Bharath Rupireddy 00:32
Re: binary version of pg_current_wal_insert_lsn and pg_walfile_name functions Bharath Rupireddy 00:35
Re: libpq error message refactoring Peter Eisentraut 02:00
Re: libpq error message refactoring Andres Freund 02:27
Re: libpq error message refactoring Tom Lane 02:37
Re: libpq error message refactoring Tom Lane 02:40
Re: libpq error message refactoring Andres Freund 02:45
Re: libpq error message refactoring Tom Lane 02:48
Re: Removing unused parameter in SnapBuildGetOrBuildSnapshot Amit Kapila 03:28
Re: CI and test improvements Thomas Munro 03:32
Re: Perform streaming logical transactions by background workers and parallel apply Amit Kapila 03:47
Re: binary version of pg_current_wal_insert_lsn and pg_walfile_name functions Ashutosh Sharma 03:58
Re: making relfilenodes 56 bits 📎 Dilip Kumar 04:23
Re: making relfilenodes 56 bits Dilip Kumar 04:27
Re: Use pg_pwritev_with_retry() instead of write() in dir_open_for_write() to avoid partial writes? 📎 Bharath Rupireddy 06:16
Re: binary version of pg_current_wal_insert_lsn and pg_walfile_name functions Ashutosh Sharma 06:54
Re: binary version of pg_current_wal_insert_lsn and pg_walfile_name functions 📎 Ashutosh Sharma 06:55
Re: LogwrtResult contended spinlock Alvaro Herrera 08:49
Re: RFC: Logging plan of the running query Alena Rybakina 09:43
Re: archive modules Peter Eisentraut 09:58
Re: Refactor backup related code (was: Is it correct to say, "invalid data in file \"%s\"", BACKUP_LABEL_FILE in do_pg_backup_stop?) Michael Paquier 12:12
Re: Temporary file access API Antonin Houska 13:45
Re: First draft of the PG 15 release notes Tom Lane 15:25
Re: archive modules Nathan Bossart 16:14
Re: First draft of the PG 15 release notes Jonathan S. Katz 16:37
Re: First draft of the PG 15 release notes Tom Lane 17:33
Re: O(n) tasks cause lengthy startups and checkpoints 📎 Nathan Bossart 17:41
Re: Pluggable toaster 📎 Nikita Malakhov 19:54
Re: Summary function for pg_buffercache 📎 Melih Mutlu 20:14
Re: Use pg_pwritev_with_retry() instead of write() in dir_open_for_write() to avoid partial writes? Nathan Bossart 20:24
Re: libpq error message refactoring 📎 Peter Eisentraut 20:31
Re: pg_stat_have_stats() returns true for dropped indexes (or for index creation transaction rolled back) Andres Freund 20:45
Re: First draft of the PG 15 release notes Jonathan S. Katz 21:07
Re: Fix typos in code comments Justin Pryzby 22:30
Re: [PoC] Federated Authn/z with OAUTHBEARER 📎 Jacob Champion 22:39

Sept. 24, 2022

Thread Author Time
Re: Use pg_pwritev_with_retry() instead of write() in dir_open_for_write() to avoid partial writes? Thomas Munro 04:14
Re: Perform streaming logical transactions by background workers and parallel apply 📎 Amit Kapila 11:40
Re: HOT chain validation in verify_heapam() Himanshu Upadhyaya 12:44
Re: Pluggable toaster 📎 Nikita Malakhov 12:50
Re: pg_stat_statements and "IN" conditions Dmitry Dolgov 14:07
Re: tweak to a few index tests to hits ambuildempty() routine. Noah Misch 17:20
Re: [BUG] Logical replica crash if there was an error in a function. Tom Lane 17:27
Re: identifying the backend that owns a temporary schema Tom Lane 17:41
Re: [RFC] building postgres with meson - v13 Tom Lane 17:52
Re: [RFC] building postgres with meson - v13 📎 Andres Freund 18:09
Re: cpluspluscheck complains about use of register 📎 Andres Freund 19:11
Re: cpluspluscheck complains about use of register Peter Geoghegan 19:59
Re: cpluspluscheck complains about use of register Tom Lane 20:01
Re: cpluspluscheck complains about use of register Andres Freund 22:13
Re: Pluggable toaster 📎 Nikita Malakhov 22:41
Re: [RFC] building postgres with meson - v13 Peter Geoghegan 23:56
Re: pg_stat_statements and "IN" conditions 📎 Dmitry Dolgov 23:59

Sept. 25, 2022

Thread Author Time
Re: [RFC] building postgres with meson - v13 Andres Freund 00:13
Re: [RFC] building postgres with meson - v13 Peter Geoghegan 00:33
Re: Consider parallel for lateral subqueries with limit 📎 James Coleman 00:35
Re: Allow foreign keys to reference a superset of unique columns James Coleman 01:34
Re: WIP: WAL prefetch (another approach) Thomas Munro 02:31
Re: Schema variables - new implementation for Postgres 15 📎 Julien Rouhaud 06:56
Re: Allow foreign keys to reference a superset of unique columns Wolfgang Walther 08:49
Re: has_privs_of_role vs. is_member_of_role, redux Wolfgang Walther 09:08
Re: tweak to a few index tests to hits ambuildempty() routine. a.kozhemyakin 13:49
Re: tweak to a few index tests to hits ambuildempty() routine. Tom Lane 14:49
Re: tweak to a few index tests to hits ambuildempty() routine. Tom Lane 15:51
Add ON CONFLICT DO RETURN clause 📎 Wolfgang Walther 15:55
Re: tweak to a few index tests to hits ambuildempty() routine. Alvaro Herrera 15:57
Re: tweak to a few index tests to hits ambuildempty() routine. Tom Lane 16:19
Re: Add ON CONFLICT DO RETURN clause Peter Geoghegan 17:53
Re: Allow foreign keys to reference a superset of unique columns James Coleman 19:28
Re: [RFC] building postgres with meson - v13 Andres Freund 19:38
Re: pg_basebackup --create-slot-if-not-exists? Michael Banck 19:41
Re: add checkpoint stats of snapshot and mapping files of pg_logical dir Hamid Akhtar 20:50
Re: First draft of the PG 15 release notes Justin Pryzby 21:50
Re: add checkpoint stats of snapshot and mapping files of pg_logical dir Justin Pryzby 21:51
postgres_fdw uninterruptible during connection establishment / ProcSignalBarrier Andres Freund 23:22

Sept. 26, 2022

Thread Author Time
Re: [RFC] building postgres with meson - v13 📎 Andres Freund 00:38
Re: Allow foreign keys to reference a superset of unique columns James Coleman 02:00
Re: Refactor backup related code (was: Is it correct to say, "invalid data in file \"%s\"", BACKUP_LABEL_FILE in do_pg_backup_stop?) Michael Paquier 02:11
RE: Data is copied twice when specifying both child and parent table in publication [email protected] 02:31
Re: Refactor backup related code (was: Is it correct to say, "invalid data in file \"%s\"", BACKUP_LABEL_FILE in do_pg_backup_stop?) 📎 Michael Paquier 02:43
RE: Perform streaming logical transactions by background workers and parallel apply 📎 [email protected] 03:09
RE: Perform streaming logical transactions by background workers and parallel apply [email protected] 03:11
Re: Add common function ReplicationOriginName. 📎 Peter Smith 03:15
Re: Removing unused parameter in SnapBuildGetOrBuildSnapshot Amit Kapila 04:22
RE: Data is copied twice when specifying both child and parent table in publication 📎 [email protected] 04:44
Add an assert to the length of shared hashtable name 📎 Xiaoran Wang 05:08
Differentiate MERGE queries with different structures 📎 bt22nakamorit 06:12

Browse Archives

Prev | Next