pgsql-hackers since 2022-11-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 29 30

Nov. 11, 2022

Thread Author Time
Re: Reducing the WAL overhead of freezing in VACUUM by deduplicating per-tuple freeze plans 📎 Peter Geoghegan 00:48
Re: Lack of PageSetLSN in heap_xlog_visible 📎 Jeff Davis 01:20
RE: Perform streaming logical transactions by background workers and parallel apply [email protected] 02:26
RE: Perform streaming logical transactions by background workers and parallel apply [email protected] 02:27
Re: Printing backtrace of postgres processes Kyotaro Horiguchi 02:29
Re: Reducing the WAL overhead of freezing in VACUUM by deduplicating per-tuple freeze plans Justin Pryzby 02:59
Typo about subxip in comments Japin Li 03:26
Re: New strategies for freezing, advancing relfrozenxid early Justin Pryzby 03:44
Re: User functions for building SCRAM secrets 📎 Jonathan S. Katz 04:14
Re: Support logical replication of DDLs Peter Smith 04:47
Re: Avoid overhead open-close indexes (catalog updates) 📎 Michael Paquier 04:53
Re: Support logical replication of DDLs Peter Smith 05:09
Re: Typo about subxip in comments Amit Kapila 05:09
Re: Unit tests for SLRU Michael Paquier 05:11
Re: Support logical replication of DDLs Peter Smith 05:17
Re: Support logical replication of DDLs Peter Smith 05:33
Re: Typo about subxip in comments Julien Rouhaud 05:33
Re: Reviving lost replication slots Amit Kapila 05:36
RE: Data is copied twice when specifying both child and parent table in publication 📎 [email protected] 05:43
Re: Use pg_pwritev_with_retry() instead of write() in dir_open_for_write() to avoid partial writes? John Naylor 05:44
RE: Data is copied twice when specifying both child and parent table in publication [email protected] 05:44
RE: Data is copied twice when specifying both child and parent table in publication [email protected] 05:45
Re: Use pg_pwritev_with_retry() instead of write() in dir_open_for_write() to avoid partial writes? Bharath Rupireddy 06:23
Re: Reviving lost replication slots Bharath Rupireddy 06:28
Re: Typo about subxip in comments Richard Guo 06:46
Re: Use pg_pwritev_with_retry() instead of write() in dir_open_for_write() to avoid partial writes? Michael Paquier 07:11
Re: Perform streaming logical transactions by background workers and parallel apply Amit Kapila 07:21
Re: Typo about subxip in comments Amit Kapila 07:23
Re: proposal: possibility to read dumped table's name from file Julien Rouhaud 08:11
RE: Perform streaming logical transactions by background workers and parallel apply 📎 [email protected] 08:42
Re: Typo about subxip in comments Japin Li 09:14
Re: slab allocator performance issues John Naylor 09:20
Re: Use pg_pwritev_with_retry() instead of write() in dir_open_for_write() to avoid partial writes? John Naylor 09:21
Re: [Proposal] Add foreign-server health checks infrastructure Önder Kalacı 10:30
Re: Lack of PageSetLSN in heap_xlog_visible Konstantin Knizhnik 10:43
Re: [PATCH] Teach pg_waldump to extract FPIs from the WAL Bharath Rupireddy 10:57
A problem about join ordering Richard Guo 11:28
Add test module for Custom WAL Resource Manager feature 📎 Bharath Rupireddy 11:31
Re: Perform streaming logical transactions by background workers and parallel apply Amit Kapila 11:37
Re: Lockless queue of waiters in LWLock 📎 Pavel Borisov 11:39
Optimize join selectivity estimation by not reading MCV stats for unique join attributes 📎 David Geier 12:01
Re: Add LSN along with offset to error messages reported for WAL file read/write/validate header failures Maxim Orlov 12:21
Re: Printing backtrace of postgres processes Bharath Rupireddy 12:34
Re: Lockless queue of waiters in LWLock 📎 Pavel Borisov 12:39
Re: [PoC] Let libpq reject unexpected authentication requests Aleksander Alekseev 13:52
Re: Privileges on PUBLICATION Peter Eisentraut 14:08
Re: [PATCH] Teach pg_waldump to extract FPIs from the WAL Justin Pryzby 14:15
Re: [PATCH] Teach pg_waldump to extract FPIs from the WAL David Christensen 14:27
Re: Support logical replication of DDLs 📎 vignesh C 14:39
Re: Lockless queue of waiters in LWLock Alexander Korotkov 14:41
Re: Collation version tracking for macOS 📎 Peter Eisentraut 14:57
Re: Meson doesn't define HAVE_LOCALE_T for mscv Peter Eisentraut 15:02
Re: psql: Add command to use extended query protocol Peter Eisentraut 15:09
Re: libpq support for NegotiateProtocolVersion Peter Eisentraut 15:13
Re: Lockless queue of waiters in LWLock 📎 Pavel Borisov 15:16
Re: Optimize join selectivity estimation by not reading MCV stats for unique join attributes Tom Lane 15:16
Re: A problem about join ordering Tom Lane 15:24
Re: Call lazy_check_wraparound_failsafe earlier for parallel vacuum Imseih (AWS), Sami 15:28
Re: [PATCH] Support % wildcard in extension upgrade filenames Christoph Berg 15:59
Re: [PATCH] Support % wildcard in extension upgrade filenames Christoph Berg 16:07
Re: [PATCH] Use indexes on the subscriber when REPLICA IDENTITY is full on the publisher 📎 Önder Kalacı 16:16
Re: ExecRTCheckPerms() and many prunable partitions Tom Lane 16:46
Re: Add LSN along with offset to error messages reported for WAL file read/write/validate header failures Alvaro Herrera 17:35
Re: Reducing the WAL overhead of freezing in VACUUM by deduplicating per-tuple freeze plans 📎 Peter Geoghegan 18:38
Re: Add index scan progress to pg_stat_progress_vacuum 📎 Imseih (AWS), Sami 19:10
Making Bitmapsets be valid Nodes 📎 Tom Lane 20:05
Document WAL rules related to PD_ALL_VISIBLE in README 📎 Jeff Davis 22:14
Re: libpq support for NegotiateProtocolVersion Jacob Champion 22:28
Re: Document WAL rules related to PD_ALL_VISIBLE in README Peter Geoghegan 22:40
Re: logical decoding and replication of sequences, take 2 📎 Tomas Vondra 22:49
Re: Add test module for Custom WAL Resource Manager feature Jeff Davis 23:10

Nov. 12, 2022

Thread Author Time
Re: [PoC] Let libpq reject unexpected authentication requests 📎 Jacob Champion 00:11
Re: Typo about subxip in comments Amit Kapila 04:12
Re: [PoC] Let libpq reject unexpected authentication requests Aleksander Alekseev 06:57
Re: Allow file inclusion in pg_hba and pg_ident files Julien Rouhaud 08:13
Re: Perform streaming logical transactions by background workers and parallel apply Amit Kapila 11:05
Remove unused param rte in set_plain_rel_pathlist 📎 Zhang Mingli 11:13
Re: logical replication restrictions vignesh C 13:51
Re: Avoid overhead open-close indexes (catalog updates) Ranier Vilela 14:03
Re: Remove unused param rte in set_plain_rel_pathlist Tom Lane 15:00
Re: Lack of PageSetLSN in heap_xlog_visible Jeff Davis 18:26
Re: generate_series for timestamptz and time zone problem Tom Lane 18:44
Re: Fix order of checking ICU options in initdb and create database Jose Arthur Benetasso Villanova 19:43
Re: proposal: possibility to read dumped table's name from file Pavel Stehule 20:35
Re: proposal: possibility to read dumped table's name from file 📎 Pavel Stehule 20:37
Re: libpq compression (part 2) Andrey Borodin 21:47
Re: Use fadvise in wal replay Andrey Borodin 22:01
Re: A new strategy for pull-up correlated ANY_SUBLINK 📎 Tom Lane 22:45

Nov. 13, 2022

Thread Author Time
Re: PGDOCS - Logical replication GUCs - added some xrefs vignesh C 00:47
Re: libpq compression (part 2) Andrey Borodin 04:04
Re: proposal: possibility to read dumped table's name from file Julien Rouhaud 08:58
Re: libpq support for NegotiateProtocolVersion Peter Eisentraut 09:21
Re: refactor ownercheck and aclcheck functions Peter Eisentraut 09:26
Re: libpq error message refactoring Peter Eisentraut 11:13
Re: New docs chapter on Transaction Management and related changes Laurenz Albe 11:56
Re: Making Bitmapsets be valid Nodes Peter Eisentraut 12:22
Re: Schema variables - new implementation for Postgres 15 Pavel Stehule 14:58
Re: Schema variables - new implementation for Postgres 15 📎 Pavel Stehule 15:01
Re: Typo about subxip in comments Japin Li 15:02
Re: Making Bitmapsets be valid Nodes Tom Lane 15:23
Re: Reducing power consumption on idle servers 📎 Simon Riggs 16:51
Re: Data is copied twice when specifying both child and parent table in publication vignesh C 16:55
Re: Schema variables - new implementation for Postgres 15 📎 Pavel Stehule 17:59
Re: proposal: possibility to read dumped table's name from file 📎 Pavel Stehule 19:32
Re: WIP: Aggregation push-down - take2 📎 Tomas Vondra 21:15
Re: Reducing power consumption on idle servers Thomas Munro 21:28
Re: Suppressing useless wakeups in walreceiver Tom Lane 22:08
Re: Suppressing useless wakeups in walreceiver Thomas Munro 22:18
Re: Suppressing useless wakeups in walreceiver Nathan Bossart 22:26
Re: Reducing power consumption on idle servers 📎 Simon Riggs 23:07
Re: Suppressing useless wakeups in walreceiver Thomas Munro 23:11
Re: Suppressing useless wakeups in walreceiver 📎 Thomas Munro 23:35
Re: Suppressing useless wakeups in walreceiver Thomas Munro 23:51
Re: CI and test improvements 📎 Justin Pryzby 23:53

Nov. 14, 2022

Thread Author Time
Re: Suppressing useless wakeups in walreceiver Nathan Bossart 00:05
RE: logical replication restrictions 📎 Takamichi Osumi (Fujitsu) 01:08
Re: Bitmapsets as Nodes Amit Langote 01:43
Re: Suppressing useless wakeups in walreceiver Thomas Munro 01:47
Re: Add palloc_aligned() to allow arbitrary power of 2 memory alignment John Naylor 02:25
Re: Add test module for Custom WAL Resource Manager feature 📎 Bharath Rupireddy 04:04
RE: [PATCH] Support % wildcard in extension upgrade filenames Regina Obe 04:46
Re: Allow file inclusion in pg_hba and pg_ident files Michael Paquier 05:40
Re: Support logical replication of DDLs 📎 vignesh C 06:33
Time delayed LR (WAS Re: logical replication restrictions) Amit Kapila 06:44
Re: Schema variables - new implementation for Postgres 15 Sergey Shinderuk 07:00
Re: Time delayed LR (WAS Re: logical replication restrictions) Amit Kapila 07:03
Re: Non-decimal integer literals John Naylor 07:25
Re: Making Bitmapsets be valid Nodes Amit Langote 07:26
Re: ExecRTCheckPerms() and many prunable partitions Amit Langote 07:32
Re: Allow file inclusion in pg_hba and pg_ident files Julien Rouhaud 07:47
Re: [PoC] Improve dead tuple storage for lazy vacuum 📎 Masahiko Sawada 08:43
RE: Time delayed LR (WAS Re: logical replication restrictions) Hayato Kuroda (Fujitsu) 08:58
Re: Optimize join selectivity estimation by not reading MCV stats for unique join attributes David Geier 09:19
Re: A problem about join ordering Richard Guo 10:10
Re: libpq error message refactoring Alvaro Herrera 10:11
Re: Time delayed LR (WAS Re: logical replication restrictions) Amit Kapila 10:15
Re: Time delayed LR (WAS Re: logical replication restrictions) Amit Kapila 10:33
Re: hash_xlog_split_allocate_page: failed to acquire cleanup lock Amit Kapila 10:36
Re: Split index and table statistics into different types of stats Drouvot, Bertrand 10:36
Re: Fix order of checking ICU options in initdb and create database Marina Polyakova 10:56
Re: Privileges on PUBLICATION Antonin Houska 11:07
Re: Unit tests for SLRU 📎 Michael Paquier 11:19
Re: Add 64-bit XIDs into PostgreSQL 15 Thom Brown 11:25
Re: Allow logical replication to copy tables in binary format 📎 Melih Mutlu 12:07
Re: Commit fest 2022-11 Ian Lawrence Barwick 12:08
Re: pg_basebackup's --gzip switch misbehaves 📎 Daniel Gustafsson 12:36
Re: when the startup process doesn't (logging startup delays) Simon Riggs 12:37
Re: [PoC] Improve dead tuple storage for lazy vacuum John Naylor 12:59
RE: Time delayed LR (WAS Re: logical replication restrictions) Hayato Kuroda (Fujitsu) 13:22
Error on missing Python module in Meson setup 📎 Daniel Gustafsson 13:23
Re: Commit fest 2022-11 James Coleman 13:23
Re: Commit fest 2022-11 Ian Lawrence Barwick 13:38
Re: psql: Add command to use extended query protocol Daniel Verite 13:47
Re: Add 64-bit XIDs into PostgreSQL 15 📎 Maxim Orlov 13:56
Re: pg_basebackup's --gzip switch misbehaves Tom Lane 14:23
Re: pg_basebackup's --gzip switch misbehaves Daniel Gustafsson 14:27
List of Bitmapset (was Re: ExecRTCheckPerms() and many prunable partitions) 📎 Tom Lane 14:57
Re: Add sub-transaction overflow status in pg_stat_activity Robert Haas 15:09
Re: Small TAP improvements Andrew Dunstan 15:18
Re: Add sub-transaction overflow status in pg_stat_activity Tom Lane 15:41
Re: Add sub-transaction overflow status in pg_stat_activity Robert Haas 15:52
Re: Add sub-transaction overflow status in pg_stat_activity Justin Pryzby 15:57
Re: when the startup process doesn't (logging startup delays) Robert Haas 16:01
Re: Add sub-transaction overflow status in pg_stat_activity Robert Haas 16:04
Re: Add sub-transaction overflow status in pg_stat_activity David G. Johnston 16:17
Re: Add sub-transaction overflow status in pg_stat_activity Robert Haas 16:28
Re: Add sub-transaction overflow status in pg_stat_activity Amit Singh 16:34
Re: Add sub-transaction overflow status in pg_stat_activity Robert Haas 16:41
Re: Add sub-transaction overflow status in pg_stat_activity David G. Johnston 16:48
Re: Add sub-transaction overflow status in pg_stat_activity Tom Lane 17:29
Re: HOT chain validation in verify_heapam() Andres Freund 17:38
Re: Add sub-transaction overflow status in pg_stat_activity Andres Freund 17:47
Re: hash_xlog_split_allocate_page: failed to acquire cleanup lock Andres Freund 17:48
Re: HOT chain validation in verify_heapam() Peter Geoghegan 17:50
Re: Add 64-bit XIDs into PostgreSQL 15 Aleksander Alekseev 18:07
Re: libpq support for NegotiateProtocolVersion Jacob Champion 18:11
Re: Documentation for building with meson 📎 samay sharma 18:41
Re: [PATCH] Teach pg_waldump to extract FPIs from the WAL David Christensen 18:41
Re: Add sub-transaction overflow status in pg_stat_activity Robert Haas 18:43
Re: Suppressing useless wakeups in walreceiver 📎 Nathan Bossart 19:01
Re: [PoC] Let libpq reject unexpected authentication requests Jacob Champion 19:01
Re: Add sub-transaction overflow status in pg_stat_activity David G. Johnston 19:16
Re: HOT chain validation in verify_heapam() Robert Haas 19:27
Re: Add sub-transaction overflow status in pg_stat_activity Robert Haas 19:32
Re: Allow single table VACUUM in transaction block 📎 Simon Riggs 19:52
Re: [PATCH] Teach pg_waldump to extract FPIs from the WAL 📎 David Christensen 19:59
Change error to warning and increase thresholds of tsearch 📎 Ankit Kumar Pandey 20:16
Re: Suppressing useless wakeups in walreceiver Thomas Munro 20:42
Re: HOT chain validation in verify_heapam() 📎 Andres Freund 20:58
Re: Add sub-transaction overflow status in pg_stat_activity Tom Lane 21:03
Re: Add sub-transaction overflow status in pg_stat_activity Andres Freund 21:17
Re: HOT chain validation in verify_heapam() Peter Geoghegan 21:20
Re: HOT chain validation in verify_heapam() Andres Freund 22:02
Re: Add palloc_aligned() to allow arbitrary power of 2 memory alignment Andres Freund 22:11
Re: HOT chain validation in verify_heapam() Peter Geoghegan 22:13
Re: HOT chain validation in verify_heapam() Andres Freund 22:33
meson oddities Andrew Dunstan 22:41
Re: HOT chain validation in verify_heapam() Peter Geoghegan 22:42
Re: HOT chain validation in verify_heapam() Andres Freund 22:58
Re: HOT chain validation in verify_heapam() Peter Geoghegan 23:07

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