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

Nov. 15, 2022

Thread Author Time
Multitable insert syntax support on Postgres? Alexandre hadjinlian guerra 00:06
Re: Error on missing Python module in Meson setup Andres Freund 00:25
Re: Multitable insert syntax support on Postgres? Andres Freund 00:34
Re: Meson doesn't define HAVE_LOCALE_T for mscv Andres Freund 00:49
Re: Collation version tracking for macOS Jeff Davis 00:55
Re: Avoid overhead open-close indexes (catalog updates) Michael Paquier 00:57
Re: A new strategy for pull-up correlated ANY_SUBLINK Richard Guo 01:02
Re: Assertion failure in SnapBuildInitialSnapshot() Andres Freund 01:25
Re: [BUG] Logical replica crash if there was an error in a function. 📎 Anton A. Melnikov 01:39
Re: [BUG] Logical replica crash if there was an error in a function. Tom Lane 01:59
Re: List of Bitmapset (was Re: ExecRTCheckPerms() and many prunable partitions) Amit Langote 02:04
Re: Assertion failure in SnapBuildInitialSnapshot() Andres Freund 02:38
Re: Direct I/O Andres Freund 02:50
Re: Assertion failure in SnapBuildInitialSnapshot() Thomas Munro 03:26
Re: libpq compression (part 2) 📎 Andrey Borodin 03:44
Re: Suppressing useless wakeups in walreceiver 📎 Nathan Bossart 04:49
Re: [PoC] Improve dead tuple storage for lazy vacuum Masahiko Sawada 04:58
Re: Schema variables - new implementation for Postgres 15 Pavel Stehule 05:00
Re: predefined role(s) for VACUUM and ANALYZE 📎 Nathan Bossart 05:08
RE: Assertion failure in SnapBuildInitialSnapshot() Takamichi Osumi (Fujitsu) 05:15
Re: Add sub-transaction overflow status in pg_stat_activity Dilip Kumar 05:23
Re: Add sub-transaction overflow status in pg_stat_activity Dilip Kumar 05:25
Re: PGDOCS - Logical replication GUCs - added some xrefs 📎 Peter Smith 05:47
Re: Avoid overhead open-close indexes (catalog updates) 📎 Michael Paquier 07:02
Re: Time delayed LR (WAS Re: logical replication restrictions) Amit Kapila 07:03
Re: Typo about subxip in comments Amit Kapila 07:05
Re: Making Vars outer-join aware Richard Guo 08:59
Re: Synchronizing slots from primary to standby Drouvot, Bertrand 09:02
Re: List of Bitmapset (was Re: ExecRTCheckPerms() and many prunable partitions) Alvaro Herrera 09:07
Re: Allow single table VACUUM in transaction block 📎 Simon Riggs 09:13
Re: archive modules Peter Eisentraut 09:31
Re: SUBTRANS: Minimizing calls to SubTransSetParent() 📎 Simon Riggs 09:34
Re: Split index and table statistics into different types of stats 📎 Drouvot, Bertrand 09:48
Re: Add LSN along with offset to error messages reported for WAL file read/write/validate header failures 📎 Bharath Rupireddy 10:02
Re: pg_basebackup's --gzip switch misbehaves 📎 Daniel Gustafsson 10:09
Re: Unit tests for SLRU 📎 Aleksander Alekseev 10:15
Re: New docs chapter on Transaction Management and related changes Simon Riggs 10:16
Re: libpq support for NegotiateProtocolVersion Peter Eisentraut 10:18
Re: Non-decimal integer literals Peter Eisentraut 10:31
Re: Add palloc_aligned() to allow arbitrary power of 2 memory alignment David Rowley 10:36
Re: Unit tests for SLRU Daniel Gustafsson 10:39
Re: [PATCH] Teach pg_waldump to extract FPIs from the WAL Bharath Rupireddy 10:41
Re: Unit tests for SLRU Pavel Borisov 10:43
Re: Add palloc_aligned() to allow arbitrary power of 2 memory alignment David Rowley 10:46
Re: Assertion failure in SnapBuildInitialSnapshot() Amit Kapila 10:50
Re: Add non-blocking version of PQcancel 📎 Jelte Fennema 11:38
Re: Report checkpoint progress with pg_stat_progress_checkpoint (was: Report checkpoint progress in server logs) Nitin Jadhav 11:41
Re: Assertion failure in SnapBuildInitialSnapshot() 📎 Amit Kapila 11:51
RE: Perform streaming logical transactions by background workers and parallel apply 📎 houzj.fnst@fujitsu.com 11:57
Re: Error on missing Python module in Meson setup 📎 Daniel Gustafsson 12:41
Re: meson oddities Andrew Dunstan 13:04
Re: psql: Add command to use extended query protocol Peter Eisentraut 13:29
Re: SUBTRANS: Minimizing calls to SubTransSetParent() Japin Li 13:31
Re: when the startup process doesn't (logging startup delays) 📎 Bharath Rupireddy 13:33
Re: plpgsql-trigger.html: Format TG_ variables as table (patch) Daniel Gustafsson 14:00
Re: Add sub-transaction overflow status in pg_stat_activity Robert Haas 14:04
Re: when the startup process doesn't (logging startup delays) Simon Riggs 14:27
Re: Meson doesn't define HAVE_LOCALE_T for mscv 📎 Juan José Santamaría Flecha 14:35
Re: Avoid overhead open-close indexes (catalog updates) Ranier Vilela 14:42
Vacuumdb --force-index-cleanup option not available in postgres 12.9 Karthik Jagadish (kjagadis) 14:45
Re: Check return value of pclose() correctly Peter Eisentraut 14:52
Re: dynamic result sets support in extended query protocol Peter Eisentraut 14:58
Re: Vacuumdb --force-index-cleanup option not available in postgres 12.9 Justin Pryzby 15:32
Index not getting cleaned even though vacuum is running Karthik Jagadish (kjagadis) 15:38
Re: Vacuumdb --force-index-cleanup option not available in postgres 12.9 Karthik Jagadish (kjagadis) 15:40
Re: Vacuumdb --force-index-cleanup option not available in postgres 12.9 Justin Pryzby 15:43
Re: meson oddities Peter Eisentraut 16:07
Re: Error-safe user functions Andrew Dunstan 16:35
Re: HOT chain validation in verify_heapam() Robert Haas 16:36
Re: archive modules Nathan Bossart 16:45
Re: allowing for control over SET ROLE Robert Haas 17:07
Re: archive modules Alvaro Herrera 17:14
Re: when the startup process doesn't (logging startup delays) Robert Haas 17:24
Re: [PATCH] Teach pg_waldump to extract FPIs from the WAL David Christensen 17:51
Re: List of Bitmapset (was Re: ExecRTCheckPerms() and many prunable partitions) 📎 Tom Lane 18:23
Standardizing how pg_waldump presents recovery conflict XID cutoffs 📎 Peter Geoghegan 18:24
Re: List of Bitmapset (was Re: ExecRTCheckPerms() and many prunable partitions) Tom Lane 18:25
Re: Reducing the WAL overhead of freezing in VACUUM by deduplicating per-tuple freeze plans Peter Geoghegan 18:26
closing file in adjust_data_dir 📎 Ted Yu 18:43
Distinct tightly coupled with Agg Ankit Kumar Pandey 18:47
Re: Distinct tightly coupled with Agg Ankit Kumar Pandey 18:50
Re: Distinct tightly coupled with Agg Tom Lane 18:56
Re: meson oddities Andres Freund 19:04
Re: Moving forward with TDE Jacob Champion 19:07
Re: Add palloc_aligned() to allow arbitrary power of 2 memory alignment Andres Freund 19:19
Re: Add sub-transaction overflow status in pg_stat_activity Andres Freund 19:29
Re: Moving forward with TDE David Christensen 19:39
Re: HOT chain validation in verify_heapam() Andres Freund 19:50
Re: [PATCH] Teach pg_waldump to extract FPIs from the WAL 📎 David Christensen 19:50
Re: Meson doesn't define HAVE_LOCALE_T for mscv Andres Freund 19:53
Re: Meson doesn't define HAVE_LOCALE_T for mscv Andres Freund 20:02
Re: Report checkpoint progress with pg_stat_progress_checkpoint (was: Report checkpoint progress in server logs) Robert Haas 20:04
Re: Moving forward with TDE 📎 Jacob Champion 20:08
Re: Report checkpoint progress with pg_stat_progress_checkpoint (was: Report checkpoint progress in server logs) Andres Freund 20:18
Re: Schema variables - new implementation for Postgres 15 📎 Pavel Stehule 20:22
Re: HOT chain validation in verify_heapam() Robert Haas 20:28
Re: Standardizing how pg_waldump presents recovery conflict XID cutoffs Andres Freund 20:29
Re: meson oddities Andrew Dunstan 20:47
Re: ssl tests aren't concurrency safe due to get_free_port() 📎 Andrew Dunstan 20:56
Re: archive modules Nathan Bossart 20:57
Re: SUBTRANS: Minimizing calls to SubTransSetParent() Tom Lane 21:03
Re: Speed up transaction completion faster after many relations are accessed in a transaction David Rowley 21:03
Re: meson oddities Tom Lane 21:08
Re: allowing for control over SET ROLE Nathan Bossart 21:14
Re: archive modules Michael Paquier 21:51
Re: Standardizing how pg_waldump presents recovery conflict XID cutoffs Peter Geoghegan 21:54
Re: Avoid overhead open-close indexes (catalog updates) Michael Paquier 21:58
Re: Add palloc_aligned() to allow arbitrary power of 2 memory alignment Greg Stark 21:58
Re: closing file in adjust_data_dir 📎 Ted Yu 22:34
Re: Slow standby snapshot Tom Lane 22:53
Re: SUBTRANS: Minimizing calls to SubTransSetParent() Simon Riggs 22:59
Re: Slow standby snapshot Tom Lane 23:06
Meson add host_system to PG_VERSION_STR 📎 Juan José Santamaría Flecha 23:08
Re: Add palloc_aligned() to allow arbitrary power of 2 memory alignment Andres Freund 23:12
Re: Slow standby snapshot Simon Riggs 23:14
Bug in row_number() optimization 📎 Sergey Shinderuk 23:38
Re: meson oddities Andres Freund 23:40

Nov. 16, 2022

Thread Author Time
Re: Meson add host_system to PG_VERSION_STR Michael Paquier 00:01
Re: Meson doesn't define HAVE_LOCALE_T for mscv Juan José Santamaría Flecha 00:06
Re: Slow standby snapshot Andres Freund 00:06
Re: SUBTRANS: Minimizing calls to SubTransSetParent() Tom Lane 00:09
Re: Meson doesn't define HAVE_LOCALE_T for mscv Juan José Santamaría Flecha 00:10
Re: Slow standby snapshot Tom Lane 00:15
Re: Unit tests for SLRU Michael Paquier 00:22
Re: allowing for control over SET ROLE Jeff Davis 00:23
Re: Add test module for Custom WAL Resource Manager feature Jeff Davis 00:29
Re: Slow standby snapshot Tom Lane 00:31
Re: Slow standby snapshot Andres Freund 00:31
Re: Slow standby snapshot Andres Freund 00:44
Re: Slow standby snapshot Tom Lane 00:46
Re: Unit tests for SLRU Michael Paquier 00:56
Re: pg_basebackup's --gzip switch misbehaves Michael Paquier 01:02
Re: Slow standby snapshot Andres Freund 01:12
Re: Add test module for Custom WAL Resource Manager feature Michael Paquier 01:26
Re: Add test module for Custom WAL Resource Manager feature Michael Paquier 01:27
Re: Standardizing how pg_waldump presents recovery conflict XID cutoffs Andres Freund 01:29
Re: [DOCS] Stats views and functions not in order? 📎 Peter Smith 01:38
Re: ssl tests aren't concurrency safe due to get_free_port() Andres Freund 01:51
Re: Documentation for building with meson Ian Lawrence Barwick 01:52
Re: Assertion failure in SnapBuildInitialSnapshot() Andres Freund 02:00
Re: closing file in adjust_data_dir Japin Li 02:02
Re: hash_xlog_split_allocate_page: failed to acquire cleanup lock 📎 Amit Kapila 02:03
Re: closing file in adjust_data_dir Ted Yu 02:06
Re: closing file in adjust_data_dir Japin Li 02:09
Re: Documentation for building with meson Justin Pryzby 02:22
Re: List of Bitmapset (was Re: ExecRTCheckPerms() and many prunable partitions) Amit Langote 02:35
Re: closing file in adjust_data_dir Japin Li 02:35
Re: Slow standby snapshot Simon Riggs 02:40
Re: closing file in adjust_data_dir Ted Yu 02:52
Re: Allow file inclusion in pg_hba and pg_ident files Julien Rouhaud 02:53
Re: New strategies for freezing, advancing relfrozenxid early 📎 Peter Geoghegan 03:02
Re: SUBTRANS: Minimizing calls to SubTransSetParent() Simon Riggs 03:10
Re: closing file in adjust_data_dir Japin Li 03:11
Re: closing file in adjust_data_dir Ted Yu 03:15
Re: libpq compression (part 2) 📎 Justin Pryzby 03:17
Re: closing file in adjust_data_dir Japin Li 03:26
Re: closing file in adjust_data_dir Ted Yu 03:31
contrib: auth_delay module 📎 成之焕 03:37
Re: Suppressing useless wakeups in walreceiver 📎 Thomas Munro 03:57
Re: logical replication restrictions Ian Lawrence Barwick 03:57
Re: Skipping schema changes in publication Ian Lawrence Barwick 04:04
Re: Switching XLog source from archive to streaming when primary available Ian Lawrence Barwick 04:08
Re: Add test module for Custom WAL Resource Manager feature Jeff Davis 04:09
Re: Suppressing useless wakeups in walreceiver Nathan Bossart 04:24
Re: SUBTRANS: Minimizing calls to SubTransSetParent() Dilip Kumar 04:26
Re: Hash index build performance tweak from sorting 📎 Simon Riggs 04:33
Re: Testing autovacuum wraparound (including failsafe) Ian Lawrence Barwick 04:38
Re: logical decoding and replication of sequences, take 2 Ian Lawrence Barwick 04:43
Re: [PoC] Improve dead tuple storage for lazy vacuum John Naylor 04:46
Re: vacuumlo: add test to vacuumlo for test coverage Ian Lawrence Barwick 04:48
Re: Standardizing how pg_waldump presents recovery conflict XID cutoffs Peter Geoghegan 04:48
Re: Allow file inclusion in pg_hba and pg_ident files Ian Lawrence Barwick 05:01
Re: [PoC] Improve dead tuple storage for lazy vacuum John Naylor 05:17
Re: pg_rewind: warn when checkpoint hasn't happened after promotion 📎 kuroda.keisuke 05:17
Re: New strategies for freezing, advancing relfrozenxid early Andres Freund 05:20
Re: Memory leak in adjust_data_dir Japin Li 05:21
Re: Allow file inclusion in pg_hba and pg_ident files Julien Rouhaud 05:30
Re: [PoC] Improve dead tuple storage for lazy vacuum Masahiko Sawada 05:33
Re: [PoC] Improve dead tuple storage for lazy vacuum Masahiko Sawada 05:34
MERGE regress test Teja Mupparti 05:46
Re: Switching XLog source from archive to streaming when primary available 📎 Bharath Rupireddy 06:09
Re: when the startup process doesn't (logging startup delays) 📎 Bharath Rupireddy 06:47
Re: HOT chain validation in verify_heapam() Andres Freund 06:55
Re: Standardizing how pg_waldump presents recovery conflict XID cutoffs Andres Freund 06:55
Re: Small miscellaneous fixes Michael Paquier 06:59
Re: [PoC] Let libpq reject unexpected authentication requests Michael Paquier 07:06
Re: HOT chain validation in verify_heapam() Himanshu Upadhyaya 07:11
Re: Avoid overhead open-close indexes (catalog updates) Michael Paquier 07:23
Re: [PoC] Improve dead tuple storage for lazy vacuum 📎 John Naylor 07:39
out of memory in crosstab() 📎 Amit Langote 07:47
RE: Perform streaming logical transactions by background workers and parallel apply 📎 houzj.fnst@fujitsu.com 08:19
Re: closing file in adjust_data_dir Peter Eisentraut 08:28
RE: Fix some newly modified tab-complete changes 📎 shiy.fnst@fujitsu.com 08:29
Fix the README file for MERGE command 📎 Waithant Myo (Fujitsu) 08:37
Re: XID formatting and SLRU refactorings (was: Add 64-bit XIDs into PostgreSQL 15) 📎 Aleksander Alekseev 08:37
Re: Assertion failure in SnapBuildInitialSnapshot() Amit Kapila 08:52
Re: Support logical replication of DDLs 📎 vignesh C 08:57
Re: when the startup process doesn't (logging startup delays) Simon Riggs 08:58
RE: Data is copied twice when specifying both child and parent table in publication 📎 wangw.fnst@fujitsu.com 08:58
Re: Reducing power consumption on idle servers 📎 Simon Riggs 09:03

Browse Archives

Prev | Next