pgsql-hackers - June 2023

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

June 1, 2023

Thread Author Time
RE: Support logical replication of DDLs Yu Shi (Fujitsu) 02:12
Re: An inefficient query caused by unnecessary PlaceHolderVar Richard Guo 02:30
Re: Do we want a hashset type? Joel Jacobson 07:02
Re: Do we want a hashset type? Joel Jacobson 07:14
RE: Support logical replication of DDLs Yu Shi (Fujitsu) 07:39
[PATCH] Add LoongArch spinlock support in s_lock.h. 📎 zang ruochen 07:53
Re: [PATCH] Add LoongArch spinlock support in s_lock.h. Daniel Gustafsson 07:57
Re: [PATCH] Add LoongArch spinlock support in s_lock.h. Daniel Gustafsson 08:06
Re: Docs: Encourage strong server verification with SCRAM Daniel Gustafsson 08:22
RE: [16Beta1][doc] pgstat: Track time of the last scan of a relation Shinoda, Noriyoshi (PN Japan FSIP) 09:38
Re: Avoiding another needless ERROR during nbtree page deletion Greg Stark 10:47
Re: Do we want a hashset type? Andrew Dunstan 10:51
Re: [PATCH] Reuse Workers and Replication Slots during Logical Replication 📎 Melih Mutlu 10:54
Re: [PATCH] Reuse Workers and Replication Slots during Logical Replication Melih Mutlu 11:22
[PATCH] Using named captures in Catalog::ParseHeader() 📎 Dagfinn Ilmari Mannsåker 12:12
Re: Avoiding another needless ERROR during nbtree page deletion Peter Geoghegan 12:14
Re: [PATCH] Reuse Workers and Replication Slots during Logical Replication Peter Smith 12:22
Re: Docs: Encourage strong server verification with SCRAM Michael Paquier 12:28
[PATCH] Missing dep on Catalog.pm in meson rules 📎 Dagfinn Ilmari Mannsåker 12:41
Re: ALTER TABLE SET ACCESS METHOD on partitioned tables Michael Paquier 12:50
Re: [PATCH] Missing dep on Catalog.pm in meson rules Michael Paquier 13:11
Re: Support logical replication of DDLs 📎 vignesh C 15:42
Re: Adding SHOW CREATE TABLE Kirk Wolak 16:57
Request for new function in view update 📎 Terry Brennan 17:18
Re: An inefficient query caused by unnecessary PlaceHolderVar James Coleman 17:33
Re: Adding SHOW CREATE TABLE Andrew Dunstan 19:13
Re: Adding SHOW CREATE TABLE Kirk Wolak 20:39
Re: Adding SHOW CREATE TABLE Andrew Dunstan 20:46
Re: [PATCH] Missing dep on Catalog.pm in meson rules Tristan Partin 21:16
Re: [PATCH] Missing dep on Catalog.pm in meson rules Dagfinn Ilmari Mannsåker 21:22

June 2, 2023

Thread Author Time
Re: Request for new function in view update Heikki Linnakangas 01:43
Re: postgres_fdw: wrong results with self join + enable_nestloop off Suraj Kharage 03:30
RE: Partial aggregates pushdown 📎 [email protected] 03:54
Re: [PATCH] Missing dep on Catalog.pm in meson rules Tristan Partin 04:06
Tighten a little bit the computation of potential commutator pairs Richard Guo 07:05
Re: Do we want a hashset type? Ants Aasma 08:01
Re: Cutting support for OpenSSL 1.0.1 and 1.0.2 in 17~? Daniel Gustafsson 08:35
Re: [BUG] pg_dump does not properly deal with BEGIN ATOMIC function 📎 Tom Lane 12:16
Re: Request for new function in view update Terry Brennan 12:17
Re: postgres_fdw: wrong results with self join + enable_nestloop off Nishant Sharma 12:31
Re: [PATCH] Missing dep on Catalog.pm in meson rules Andres Freund 13:00
Re: [PATCH] Missing dep on Catalog.pm in meson rules Tristan Partin 13:10
Wrong syntax in feature description Peter Smith 13:30
Re: [PATCH] Missing dep on Catalog.pm in meson rules Andres Freund 13:47
Re: Adding SHOW CREATE TABLE Kirk Wolak 14:57
Re: [BUG] pg_dump does not properly deal with BEGIN ATOMIC function Kirk Wolak 15:08
Re: [PATCH] Missing dep on Catalog.pm in meson rules Tristan Partin 15:13
Prevent psql \watch from running queries that return no rows 📎 Greg Sabino Mullane 15:47
Re: RFC: Logging plan of the running query 📎 James Coleman 17:51
pg_upgrade --copy-file-range 📎 Thomas Munro 19:30
[Question] pgwal increasing over max_wal_size Ankit Pandey 19:42
Re: Cutting support for OpenSSL 1.0.1 and 1.0.2 in 17~? Michael Paquier 21:21
Re: Cutting support for OpenSSL 1.0.1 and 1.0.2 in 17~? Daniel Gustafsson 21:23
Re: [BUG] pg_dump does not properly deal with BEGIN ATOMIC function Imseih (AWS), Sami 21:26

June 3, 2023

Thread Author Time
Re: PostgreSQL 16 Beta 1 Released! Marco Atzeri 05:35
Improve join_search_one_level readibilty (one line change) 📎 謝東霖 09:24
Avoid unused value (src/fe_utils/print.c) 📎 Ranier Vilela 10:14
Re: [PATCH] Slight improvement of worker_spi.c example 📎 Aleksander Alekseev 11:09
Re: [PATCH] Slight improvement of worker_spi.c example Julien Rouhaud 11:15
Re: [PATCH] Slight improvement of worker_spi.c example Aleksander Alekseev 11:38
Should "REGRESS_OPTS = --temp-config" be working for 3rd party extensions? Aleksander Alekseev 11:56
Re: Avoid unused value (src/fe_utils/print.c) Alexander Lakhin 12:00
Re: PostgreSQL 16 Beta 1 Released! Tom Lane 12:27
Re: [PATCH] Slight improvement of worker_spi.c example Julien Rouhaud 12:28
Re: [PATCH] Slight improvement of worker_spi.c example Aleksander Alekseev 12:34
Re: Avoid unused value (src/fe_utils/print.c) Ranier Vilela 12:46
Re: Should "REGRESS_OPTS = --temp-config" be working for 3rd party extensions? Julien Rouhaud 12:50
Re: Should "REGRESS_OPTS = --temp-config" be working for 3rd party extensions? Aleksander Alekseev 15:09
Improving FTS for Greek Florents Tselai 17:47
Re: [BUG] pg_dump does not properly deal with BEGIN ATOMIC function 📎 Tom Lane 18:28
Re: Docs: Encourage strong server verification with SCRAM Michael Paquier 21:50
Re: Prevent psql \watch from running queries that return no rows Michael Paquier 21:58
Re: Implement generalized sub routine find_in_log for tap test 📎 Michael Paquier 22:21
Re: [PATCH] Slight improvement of worker_spi.c example Michael Paquier 22:35
Re: New Table Access Methods for Multi and Single Inserts Andres Freund 22:38
Re: Avoid unused value (src/fe_utils/print.c) Michael Paquier 22:42
Add test module for Table Access Method 📎 Fabrízio de Royes Mello 23:42

June 4, 2023

Thread Author Time
Re: [BUG] pg_dump does not properly deal with BEGIN ATOMIC function Kirk Wolak 03:10
Re: Avoid unused value (src/fe_utils/print.c) Alexander Lakhin 04:00
Re: Improve join_search_one_level readibilty (one line change) Julien Rouhaud 06:02
Re: LLVM 16 (opaque pointers) 📎 Dmitry Dolgov 09:33
Re: Avoid unused value (src/fe_utils/print.c) Ranier Vilela 11:59
Avoid unncessary always true test (src/backend/storage/buffer/bufmgr.c) 📎 Ranier Vilela 12:42
Re: Wrong syntax in feature description Amit Kapila 16:48
Re: [BUG] pg_dump does not properly deal with BEGIN ATOMIC function Tom Lane 17:36
Re: [BUG] pg_dump does not properly deal with BEGIN ATOMIC function Tom Lane 17:41
Re: running logical replication as the subscription owner Amit Kapila 18:14
Re: Prevent psql \watch from running queries that return no rows 📎 Greg Sabino Mullane 18:55
Re: Do we want a hashset type? Tomas Vondra 23:44

June 5, 2023

Thread Author Time
Re: Reload configuration more frequently in apply worker. Amit Kapila 00:02
Re: Cleaning up array_in() Nikhil Benesch 01:48
Re: WAL Insertion Lock Improvements Bharath Rupireddy 02:30
Re: New Table Access Methods for Multi and Single Inserts Bharath Rupireddy 02:30
collation settings table in v16 docs 📎 Jeremy Schneider 02:31
Re: Avoid unncessary always true test (src/backend/storage/buffer/bufmgr.c) Richard Guo 02:37
Re: Cleaning up array_in() Tom Lane 02:38
Re: postgres_fdw: wrong results with self join + enable_nestloop off Richard Guo 03:06
Re: postgres_fdw: wrong results with self join + enable_nestloop off Richard Guo 03:09
confusion about this commit "Revert "Skip redundant anti-wraparound vacuums"" jiye 03:30
Re: confusion about this commit "Revert "Skip redundant anti-wraparound vacuums"" Tom Lane 03:37
Re: [16Beta1][doc] pgstat: Track time of the last scan of a relation David Rowley 05:36
Re: confusion about this commit "Revert "Skip redundant anti-wraparound vacuums"" jiye 05:50
RE: [16Beta1][doc] pgstat: Track time of the last scan of a relation Shinoda, Noriyoshi (PN Japan FSIP) 07:04
Re: Mark a transaction uncommittable 📎 Gurjeet Singh 07:22
Re: Mark a transaction uncommittable Laurenz Albe 07:32
RE: Adding percentile metrics to pg_stat_statements module benoit 08:05
Re: pgbench - adding pl/pgsql versions of tests Yugo NAGATA 08:05
Re: [PATCH] Slight improvement of worker_spi.c example 📎 Aleksander Alekseev 08:15
Re: RFC: Logging plan of the running query torikoshia 08:30
Re: PG 16 draft release notes ready Yugo NAGATA 08:33
Re: Partial aggregates pushdown Alexander Pyhalov 09:00
Re: [PoC] pg_upgrade: allow to upgrade publisher node vignesh C 09:18
Re: Do we want a hashset type? Joel Jacobson 09:27
Re: Support logical replication of DDLs 📎 shveta malik 09:30
Re: [PoC] Improve dead tuple storage for lazy vacuum Masahiko Sawada 10:31
Re: Avoid unncessary always true test (src/backend/storage/buffer/bufmgr.c) Ranier Vilela 11:06
RE: [PATCH] Reuse Workers and Replication Slots during Logical Replication Yu Shi (Fujitsu) 11:06
Re: Avoid unncessary always true test (src/backend/storage/buffer/bufmgr.c) Ranier Vilela 11:24
Re: Adding SHOW CREATE TABLE 📎 Jelte Fennema 11:43
Fix missing initialization of delayChkptEnd 📎 蔡梦娟 (玊于) 11:44
Re: [BUG] pg_dump does not properly deal with BEGIN ATOMIC function Morris de Oryx 11:58
Re: [BUG] pg_dump does not properly deal with BEGIN ATOMIC function Morris de Oryx 12:13
Re: [BUG] pg_dump does not properly deal with BEGIN ATOMIC function Tom Lane 13:01
Re: postgres_fdw: wrong results with self join + enable_nestloop off 📎 Etsuro Fujita 13:19
Re: [BUG] pg_dump does not properly deal with BEGIN ATOMIC function Morris de Oryx 13:21
[PATCH] pg_regress.c: Fix "make check" on Mac OS X: Pass DYLD_LIBRARY_PATH 📎 Evan Jones 13:47
QUAL Pushdown causes ERROR on syntactically and semantically correct SQL Query 📎 Hans Buschmann 14:40
Let's make PostgreSQL multi-threaded Heikki Linnakangas 14:51
Re: QUAL Pushdown causes ERROR on syntactically and semantically correct SQL Query David G. Johnston 14:55
Re: QUAL Pushdown causes ERROR on syntactically and semantically correct SQL Query Tom Lane 15:15
Re: Let's make PostgreSQL multi-threaded Tom Lane 15:18
Re: [BUG] pg_dump does not properly deal with BEGIN ATOMIC function Kirk Wolak 15:18
Re: Docs: Encourage strong server verification with SCRAM Jacob Champion 15:22
[PATCH] hstore: Fix parsing on Mac OS X: isspace() is locale specific 📎 Evan Jones 15:26
Re: Let's make PostgreSQL multi-threaded Tristan Partin 15:28
Re: Let's make PostgreSQL multi-threaded Heikki Linnakangas 15:33
Re: PG 16 draft release notes ready Bruce Momjian 15:42
Re: Let's make PostgreSQL multi-threaded Heikki Linnakangas 15:43
RFC: Adding \history [options] [filename] to psql (Snippets and Shared Queries) Kirk Wolak 15:50
Re: BUG #17946: LC_MONETARY & DO LANGUAGE plperl - BUG Heikki Linnakangas 16:00
Re: [BUG] pg_dump does not properly deal with BEGIN ATOMIC function Morris de Oryx 16:03
Re: Implement generalized sub routine find_in_log for tap test vignesh C 16:09
Re: [BUG] pg_dump does not properly deal with BEGIN ATOMIC function Morris de Oryx 16:20
Re: Add test module for Table Access Method 📎 Fabrízio de Royes Mello 16:24
Re: Let's make PostgreSQL multi-threaded Ranier Vilela 16:26
Re: Partial aggregates pushdown Bruce Momjian 16:26
Re: pg_collation.collversion for C.UTF-8 Jeff Davis 16:37
回复:Fix missing initialization of delayChkptEnd 📎 蔡梦娟 (玊于) 16:39
Re: Let's make PostgreSQL multi-threaded Bruce Momjian 16:42
Simplify pg_collation.collversion for Windows libc 📎 Daniel Verite 16:55
Re: Docs: Encourage strong server verification with SCRAM Jonathan S. Katz 17:04
Re: Let's make PostgreSQL multi-threaded Ranier Vilela 17:05
Re: Let's make PostgreSQL multi-threaded Bruce Momjian 17:10
Re: Let's make PostgreSQL multi-threaded Heikki Linnakangas 17:25
Re: Let's make PostgreSQL multi-threaded Heikki Linnakangas 17:29
Re: Let's make PostgreSQL multi-threaded Merlin Moncure 17:32
Re: Let's make PostgreSQL multi-threaded Jonathan S. Katz 17:40
Re: Let's make PostgreSQL multi-threaded Heikki Linnakangas 17:43
Re: pg_collation.collversion for C.UTF-8 Daniel Verite 17:43
Re: Order changes in PG16 since ICU introduction 📎 Jeff Davis 17:54
Re: Let's make PostgreSQL multi-threaded Bruce Momjian 18:04
Re: Partial aggregates pushdown Alexander Pyhalov 18:14
Re: RFC: Logging plan of the running query 📎 James Coleman 18:26
Re: Let's make PostgreSQL multi-threaded Heikki Linnakangas 18:30
Re: Add the ability to limit the amount of memory that can be allocated to backends. reid.thompson 18:33
Re: Let's make PostgreSQL multi-threaded Andrew Dunstan 18:51
Re: Let's make PostgreSQL multi-threaded Pavel Stehule 19:03
Re: Cleaning up nbtree after logical decoding on standby work 📎 Peter Geoghegan 19:04
Re: Do we want a hashset type? Joel Jacobson 19:52
Re: Let's make PostgreSQL multi-threaded Joe Conway 20:08
Re: Mark a transaction uncommittable Gurjeet Singh 20:24
Re: Mark a transaction uncommittable Gurjeet Singh 20:27
Re: Let's make PostgreSQL multi-threaded Jonah H. Harris 21:07
Inconsistent results with libc sorting on Windows 📎 Daniel Verite 22:07
Tracking commit LSNs of tuple xmins for read txns Tejasvi Kashi 22:18
Re: Inconsistent results with libc sorting on Windows Joe Conway 22:32
Re: Let's make PostgreSQL multi-threaded Bruce Momjian 23:26
Re: Let's make PostgreSQL multi-threaded Peter Geoghegan 23:50

June 6, 2023

Thread Author Time
Re: Partial aggregates pushdown Bruce Momjian 00:10
Re: Let's make PostgreSQL multi-threaded Bruce Momjian 00:15
Re: Let's make PostgreSQL multi-threaded Jeremy Schneider 00:27
Re: Let's make PostgreSQL multi-threaded Peter Geoghegan 00:50
Re: Simplify pg_collation.collversion for Windows libc Thomas Munro 01:21
Re: Let's make PostgreSQL multi-threaded Tatsuo Ishii 01:30
Re: Inconsistent results with libc sorting on Windows Thomas Munro 01:30
Re: Inconsistent results with libc sorting on Windows Thomas Munro 01:52
Re: Improve join_search_one_level readibilty (one line change) tender wang 02:09
RE: Reload configuration more frequently in apply worker. Zhijie Hou (Fujitsu) 02:15
Re: [PATCH] pg_regress.c: Fix "make check" on Mac OS X: Pass DYLD_LIBRARY_PATH Julien Rouhaud 02:25
Re: [PATCH] pg_regress.c: Fix "make check" on Mac OS X: Pass DYLD_LIBRARY_PATH Tom Lane 02:33
Re: confusion about this commit "Revert "Skip redundant anti-wraparound vacuums"" jiye 02:34
Re: Implement generalized sub routine find_in_log for tap test Amit Kapila 02:35
RE: Partial aggregates pushdown 📎 [email protected] 03:08
Add support for AT LOCAL 📎 Vik Fearing 03:13
Re: postgres_fdw: wrong results with self join + enable_nestloop off Richard Guo 03:20
Re: Implement generalized sub routine find_in_log for tap test Michael Paquier 04:06
Re: Partial aggregates pushdown Alexander Pyhalov 04:19
Re: Implement generalized sub routine find_in_log for tap test Bharath Rupireddy 04:30
Re: [PoC] Improve dead tuple storage for lazy vacuum John Naylor 05:13
RE: Support logical replication of DDLs 📎 Wei Wang (Fujitsu) 06:01

Browse Archives

Prev | Next