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

Nov. 10, 2022

Thread	Author	Time
Re: HOT chain validation in verify_heapam()	Andres Freund	00:15
Re: Out-of-date clang/llvm version lists in PGAC_LLVM_SUPPORT	Andres Freund	00:25
Document parameter count limit	David G. Johnston	00:34
Re: heavily contended lwlocks with long wait queues scale badly	Andres Freund	01:03
Re: [PATCH] Support % wildcard in extension upgrade filenames	LEO HSU	01:10
Re: Allow file inclusion in pg_hba and pg_ident files 📎	Michael Paquier	01:29
Re: HOT chain validation in verify_heapam()	Peter Geoghegan	01:32
Re: HOT chain validation in verify_heapam()	Andres Freund	01:46
Re: HOT chain validation in verify_heapam()	Andres Freund	02:10
Re: HOT chain validation in verify_heapam()	Peter Geoghegan	02:13
Re: Refactor to introduce pg_strcoll(). 📎	Jeff Davis	02:23
Re: HOT chain validation in verify_heapam()	Peter Geoghegan	02:35
Ability to reference other extensions by schema in extension scripts	Regina Obe	02:43
Re: Ability to reference other extensions by schema in extension scripts	Tom Lane	03:49
Re: Support logical replication of DDLs 📎	Ajin Cherian	04:04
Re: Tests for psql \g and \o	Michael Paquier	04:37
RE: Ability to reference other extensions by schema in extension scripts	Regina Obe	04:44
Re: BUG #17434: CREATE/DROP DATABASE can be executed in the same transaction with other commands	Yugo NAGATA	04:49
Re: Fix some newly modified tab-complete changes	Michael Paquier	04:53
Re: [PATCH] Allow usage of archive .backup files as backup_label	Michael Paquier	04:56
Re: BUG #17434: CREATE/DROP DATABASE can be executed in the same transaction with other commands	Yugo NAGATA	05:48
Re: Unit tests for SLRU	Michael Paquier	07:01
Re: Direct I/O	John Naylor	07:26
Re: New docs chapter on Transaction Management and related changes	Laurenz Albe	07:39
Re: Avoid overhead open-close indexes (catalog updates)	Michael Paquier	08:16
Re: Unit tests for SLRU	Michael Paquier	08:17
Re: [PATCH] Teach pg_waldump to extract FPIs from the WAL	Bharath Rupireddy	08:33
Meson doesn't define HAVE_LOCALE_T for mscv 📎	Juan José Santamaría Flecha	09:59
Re: WIN32 pg_import_system_collations	Juan José Santamaría Flecha	10:08
Re: Making Vars outer-join aware	Richard Guo	10:13
Re: Printing backtrace of postgres processes	Bharath Rupireddy	10:26
Assertion failure in SnapBuildInitialSnapshot()	Amit Kapila	10:34
Re: Reviving lost replication slots	sirisha chamarthi	10:37
Re: Reviving lost replication slots	sirisha chamarthi	10:42
Re: TAP output format in pg_regress	Nikolay Shaplov	10:44
Re: New docs chapter on Transaction Management and related changes	Alvaro Herrera	11:17
Re: New docs chapter on Transaction Management and related changes	Simon Riggs	11:31
Re: Avoid overhead open-close indexes (catalog updates)	Ranier Vilela	11:56
Re: ExecRTCheckPerms() and many prunable partitions 📎	Alvaro Herrera	11:58
Re: Allow pageinspect's bt_page_stats function to return a set of rows instead of a single row 📎	Hamid Akhtar	12:01
Re: ExecRTCheckPerms() and many prunable partitions	Alvaro Herrera	12:19
Re: Fix comments atop ReorderBufferAddInvalidations	Amit Kapila	12:42
Re: Crash in BRIN minmax-multi indexes	Tomas Vondra	12:46
Re: Documentation for building with meson	Nazir Bilal Yavuz	12:46
What’s the usage of SO_TYPE_ANALYZE	Zhang Mingli	14:06
Database "contrib_regression" does not exist during testing	Jingtang Zhang	15:02
RE: Perform streaming logical transactions by background workers and parallel apply 📎	[email protected]	15:09
RE: Perform streaming logical transactions by background workers and parallel apply	[email protected]	15:14
RE: Perform streaming logical transactions by background workers and parallel apply	[email protected]	15:15
Re: [PATCH] Support % wildcard in extension upgrade filenames	Regina Obe	15:23
Re: Database "contrib_regression" does not exist during testing	Tom Lane	15:28
Re: Unit tests for SLRU 📎	Aleksander Alekseev	15:40
Re: [PATCH] Teach pg_waldump to extract FPIs from the WAL	David Christensen	16:22
Re: Ability to reference other extensions by schema in extension scripts	Tom Lane	17:37
Re: Document parameter count limit	Corey Huinker	17:58
Re: Lock on ShmemVariableCache fields?	Alvaro Herrera	17:59
Re: Document parameter count limit	David G. Johnston	18:01
Re: Call lazy_check_wraparound_failsafe earlier for parallel vacuum	Imseih (AWS), Sami	18:20
RE: Ability to reference other extensions by schema in extension scripts	Regina Obe	18:42
Re: BUG #17434: CREATE/DROP DATABASE can be executed in the same transaction with other commands 📎	Tom Lane	20:33
JSONPath Child Operator?	David E. Wheeler	20:55
Re: User functions for building SCRAM secrets	Jacob Champion	21:07
Re: Call lazy_check_wraparound_failsafe earlier for parallel vacuum	Peter Geoghegan	23:09
Re: [PATCH] ALTER TABLE ... SET STORAGE default	Tom Lane	23:22

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

Browse Archives

Prev | Next