pgsql-hackers before 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)

Browse Archives

Prev | Next

Nov. 8, 2022

Thread Author Time
Re: [patch] Have psql's \d+ indicate foreign partitions Michael Paquier 05:49
Re: generic plans and "initial" pruning 📎 Amit Langote 06:22
Re: Use proc instead of MyProc in ProcArrayGroupClearXid()/TransactionGroupUpdateXidStatus() Bharath Rupireddy 06:26
Re: Use proc instead of MyProc in ProcArrayGroupClearXid()/TransactionGroupUpdateXidStatus() Amit Kapila 06:28
Re: Reviving lost replication slots sirisha chamarthi 06:37
Re: [patch] Have psql's \d+ indicate foreign partitions Ian Lawrence Barwick 06:38
Re: Add proper planner support for ORDER BY / DISTINCT aggregates Pavel Luzanov 06:39
Re: Add proper planner support for ORDER BY / DISTINCT aggregates Richard Guo 06:51
Re: Use proc instead of MyProc in ProcArrayGroupClearXid()/TransactionGroupUpdateXidStatus() rajesh singarapu 06:58
Re: Reviving lost replication slots Bharath Rupireddy 07:17
Re: Suppressing useless wakeups in walreceiver Thomas Munro 07:46
Re: Add index scan progress to pg_stat_progress_vacuum Masahiko Sawada 07:49
Re: Suppressing useless wakeups in walreceiver Bharath Rupireddy 08:20
Re: libpq support for NegotiateProtocolVersion 📎 Peter Eisentraut 08:40
Re: Add proper planner support for ORDER BY / DISTINCT aggregates Ronan Dunklau 08:43
Re: Suppressing useless wakeups in walreceiver Thomas Munro 08:45
Re: Condition pushdown: why (=) is pushed down into join, but BETWEEN or >= is not? Andy Fan 09:04
Re: Tracking last scan time Dave Page 09:25
Re: Reviving lost replication slots Amit Kapila 09:36
Re: hash_xlog_split_allocate_page: failed to acquire cleanup lock Amit Kapila 09:37
Re: Use proc instead of MyProc in ProcArrayGroupClearXid()/TransactionGroupUpdateXidStatus() Bharath Rupireddy 10:13
Re: when the startup process doesn't (logging startup delays) Thomas Munro 11:04
Re: refactor ownercheck and aclcheck functions 📎 Peter Eisentraut 11:16
Tables not getting vacuumed in postgres Karthik Jagadish (kjagadis) 11:30
Re: [PoC] Reducing planning time when tables have many partitions Andrey Lepikhov 11:31
Re: Perform streaming logical transactions by background workers and parallel apply Amit Kapila 11:49
Re: psql: Add command to use extended query protocol Daniel Verite 12:02
Re: Tables not getting vacuumed in postgres Amul Sul 12:07
Re: when the startup process doesn't (logging startup delays) 📎 Bharath Rupireddy 12:32
Re: psql: Add command to use extended query protocol 📎 Peter Eisentraut 12:37
Re: psql: Add command to use extended query protocol Peter Eisentraut 12:39
Re: Tables not getting vacuumed in postgres Karthik Jagadish (kjagadis) 12:41
Re: Tables not getting vacuumed in postgres Amul Sul 13:08
Re: Check return value of pclose() correctly 📎 Peter Eisentraut 13:14
Re: Tables not getting vacuumed in postgres Karthik Jagadish (kjagadis) 13:21
Re: [PoC] Improve dead tuple storage for lazy vacuum Masahiko Sawada 14:14
Re: Tables not getting vacuumed in postgres Mark Dilger 14:24
Re: [PATCHES] Post-special page storage TDE support 📎 David Christensen 16:17
Non-emergency patch for bug #17679 📎 Tom Lane 16:28
Re: [PoC] Improve dead tuple storage for lazy vacuum Peter Geoghegan 17:57
Out-of-date clang/llvm version lists in PGAC_LLVM_SUPPORT Tom Lane 18:08
Re: Add connection active, idle time to pg_stat_activity Sergey Dudoladov 18:11
Re: Documentation for building with meson 📎 samay sharma 18:23
Re: Introduce "log_connection_stages" setting. 📎 Sergey Dudoladov 18:30
Re: [PATCHES] Post-special page storage TDE support David Christensen 20:07
Re: User functions for building SCRAM secrets Peter Eisentraut 20:26
Re: Non-emergency patch for bug #17679 Andres Freund 20:31
Re: Non-emergency patch for bug #17679 Tom Lane 20:40
Re: Suppressing useless wakeups in walreceiver Nathan Bossart 21:06
Re: Suppressing useless wakeups in walreceiver Nathan Bossart 21:08
Re: Slow standby snapshot Thomas Munro 22:42
Re: [PATCH] Teach pg_waldump to extract FPIs from the WAL 📎 Justin Pryzby 22:45
Re: [PATCH] Teach pg_waldump to extract FPIs from the WAL David Christensen 22:49
Re: WIN32 pg_import_system_collations 📎 Juan José Santamaría Flecha 23:02
Re: libpq support for NegotiateProtocolVersion Jacob Champion 23:08
Re: psql: Add command to use extended query protocol Corey Huinker 23:12
Re: Commit fest 2022-11 Justin Pryzby 23:12
Re: Crash in BRIN minmax-multi indexes Justin Pryzby 23:13
Re: [PATCH] Teach pg_waldump to extract FPIs from the WAL 📎 David Christensen 23:37

Nov. 9, 2022

Thread Author Time
Re: EINTR in ftruncate() Thomas Munro 00:11
Re: Allow file inclusion in pg_hba and pg_ident files 📎 Michael Paquier 00:51
Re: security_context_t marked as deprecated in libselinux 3.1 Michael Paquier 00:53
Re: Slow standby snapshot Andres Freund 00:54
Re: User functions for building SCRAM secrets Jacob Champion 00:57
Re: Cygwin cleanup 📎 Justin Pryzby 01:04
Re: Slow standby snapshot Thomas Munro 01:05
Re: Add connection active, idle time to pg_stat_activity Andres Freund 01:56
Re: Add proper planner support for ORDER BY / DISTINCT aggregates 📎 David Rowley 01:58
Re: Add connection active, idle time to pg_stat_activity David G. Johnston 02:25
Re: allow segment size to be set to < 1GiB Andres Freund 02:28
Re: [PATCH] Teach pg_waldump to extract FPIs from the WAL sho kato 02:33
Re: Add connection active, idle time to pg_stat_activity Andres Freund 02:37
Re: Collation version tracking for macOS Thomas Munro 02:37
Re: Add connection active, idle time to pg_stat_activity David G. Johnston 02:43
Re: Improve logging when using Huge Pages Kyotaro Horiguchi 02:47
RE: Perform streaming logical transactions by background workers and parallel apply 📎 Hayato Kuroda (Fujitsu) 02:54
Re: Add index scan progress to pg_stat_progress_vacuum Andres Freund 03:00
Re: Asynchronous and "direct" IO support for PostgreSQL. Andres Freund 03:02
Locks release order in LogStandbySnapshot 📎 Japin Li 03:03
Re: Locks release order in LogStandbySnapshot Andres Freund 03:21
Re: Reviving lost replication slots sirisha chamarthi 03:26
Re: Reviving lost replication slots sirisha chamarthi 03:39
Re: Allow file inclusion in pg_hba and pg_ident files Julien Rouhaud 04:09
Re: allow segment size to be set to < 1GiB Michael Paquier 04:52
Re: Suppressing useless wakeups in walreceiver Bharath Rupireddy 04:52
Re: Improve logging when using Huge Pages Michael Paquier 05:04
Re: [patch] Have psql's \d+ indicate foreign partitions Michael Paquier 05:06
Re: An attempt to avoid locally-committed-but-not-replicated-to-standby-transactions in synchronous replication Andrey Borodin 05:06
Re: Locks release order in LogStandbySnapshot Japin Li 05:10
Re: User functions for building SCRAM secrets Michael Paquier 05:28
Re: logical replication restrictions Kyotaro Horiguchi 06:41
Re: New docs chapter on Transaction Management and related changes Laurenz Albe 08:12
Re: security_context_t marked as deprecated in libselinux 3.1 Alvaro Herrera 08:20
Re: Reviving lost replication slots Kyotaro Horiguchi 08:32
Re: thinko in basic_archive.c 📎 Bharath Rupireddy 09:17
Re: Reviving lost replication slots Bharath Rupireddy 09:30
Re: BUG #17434: CREATE/DROP DATABASE can be executed in the same transaction with other commands 📎 Yugo NAGATA 10:01
Re: Reviving lost replication slots Amit Kapila 10:23
Re: heavily contended lwlocks with long wait queues scale badly Bharath Rupireddy 10:24
Re: Reviving lost replication slots Bharath Rupireddy 10:25
Re: Small TAP improvements Andrew Dunstan 10:35
Re: Reviving lost replication slots Amit Kapila 10:37
Remove redundant declaration for XidInMVCCSnapshot 📎 Japin Li 10:50
Re: Perform streaming logical transactions by background workers and parallel apply Amit Kapila 12:24
Re: libpq error message refactoring Alvaro Herrera 12:29
Re: [PATCH] Teach pg_waldump to extract FPIs from the WAL Bharath Rupireddy 12:30
Re: Add tracking of backend memory allocated to pg_stat_activity Reid Thompson 13:54
Re: HOT chain validation in verify_heapam() Aleksander Alekseev 14:06
Re: [PATCH] Teach pg_waldump to extract FPIs from the WAL Justin Pryzby 14:14
Re: New docs chapter on Transaction Management and related changes Robert Treat 14:16
Re: Add tracking of backend memory allocated to pg_stat_activity Reid Thompson 14:23
Update some more ObjectType switch statements to not have default 📎 Peter Eisentraut 14:26
Call lazy_check_wraparound_failsafe earlier for parallel vacuum Imseih (AWS), Sami 14:29
Re: [PATCH] Teach pg_waldump to extract FPIs from the WAL Alvaro Herrera 14:32
Re: Add tracking of backend memory allocated to pg_stat_activity Andres Freund 16:13
Re: BUG #17434: CREATE/DROP DATABASE can be executed in the same transaction with other commands Tom Lane 16:17
Re: BUG #17434: CREATE/DROP DATABASE can be executed in the same transaction with other commands Peter Eisentraut 16:24
Re: BUG #17434: CREATE/DROP DATABASE can be executed in the same transaction with other commands Tom Lane 16:38
Re: Error for WITH options on partitioned tables Tom Lane 17:33
Re: Remove redundant declaration for XidInMVCCSnapshot Alvaro Herrera 17:33
Re: heavily contended lwlocks with long wait queues scale badly Andres Freund 17:38
Re: [PATCH] Support % wildcard in extension upgrade filenames 📎 Sandro Santilli 17:53
Re: refactor ownercheck and aclcheck functions Corey Huinker 18:12
Re: psql: Add command to use extended query protocol Daniel Verite 19:10
Re: allow segment size to be set to < 1GiB Andres Freund 19:42
Re: allow segment size to be set to < 1GiB Tom Lane 19:44
Re: [PATCH] Teach pg_waldump to extract FPIs from the WAL David Christensen 20:01
Re: [PATCH] Teach pg_waldump to extract FPIs from the WAL David Christensen 20:08
Re: allow segment size to be set to < 1GiB 📎 Andres Freund 20:25
Re: [PATCH] Teach pg_waldump to extract FPIs from the WAL 📎 David Christensen 20:37
Re: real/float example for testlibpq3 Mark Wong 20:47
Re: Expand palloc/pg_malloc API Tom Lane 21:05
Re: Call lazy_check_wraparound_failsafe earlier for parallel vacuum Peter Geoghegan 21:42
Re: HOT chain validation in verify_heapam() Andres Freund 22:08
Re: HOT chain validation in verify_heapam() Peter Geoghegan 23:03
Re: [DOCS] Stats views and functions not in order? David G. Johnston 23:03

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

Browse Archives

Prev | Next