pgsql-hackers - October 2022

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

Oct. 1, 2022

Thread Author Time
Re: pgsql: Avoid improbable PANIC during heap_update. Peter Geoghegan 00:09
Re: problems with making relfilenodes 56-bits Andres Freund 00:20
Re: [PATCH v1] [meson] add a default option prefix=/usr/local/pgsql Andres Freund 01:09
Re: [PATCH v1] [meson] add a default option prefix=/usr/local/pgsql Tom Lane 01:19
Re: An attempt to avoid locally-committed-but-not-replicated-to-standby-transactions in synchronous replication Bharath Rupireddy 01:29
Re: pgsql: Avoid improbable PANIC during heap_update. Peter Geoghegan 01:29
Re: problems with making relfilenodes 56-bits Peter Geoghegan 01:44
Re: [PATCH v1] [meson] add a default option prefix=/usr/local/pgsql 📎 Andres Freund 02:07
Re: Bloom filter Pushdown Optimization for Merge Join Zhihong Yu 03:40
postgres_fdw: dead lock in a same transaction when postgres_fdw server is lookback Xiaoran Wang 04:02
Re: Bloom filter Pushdown Optimization for Merge Join Zhihong Yu 04:20
Re: pgsql: Avoid improbable PANIC during heap_update. Peter Geoghegan 04:23
Re: pgsql: Avoid improbable PANIC during heap_update. Tom Lane 04:38
Re: pgsql: Avoid improbable PANIC during heap_update. Peter Geoghegan 05:09
Re: pgsql: Avoid improbable PANIC during heap_update. Tom Lane 05:13
Re: pgsql: Avoid improbable PANIC during heap_update. Peter Geoghegan 05:25
Re: problems with making relfilenodes 56-bits Dilip Kumar 06:14
Re: Bloom filter Pushdown Optimization for Merge Join Zhihong Yu 07:45
Re: [PATCH] Log details for client certificate failures Peter Eisentraut 10:52
Re: kerberos/001_auth test fails on arm CPU darwin Peter Eisentraut 11:12
Re: ICU for global collation Peter Eisentraut 12:07
Re: postgres_fdw: dead lock in a same transaction when postgres_fdw server is lookback Laurenz Albe 14:38
Re: longfin and tamandua aren't too happy but I'm not sure why Justin Pryzby 16:14
Re: missing indexes in indexlist with partitioned tables 📎 Arne Roland 16:34
Re: pgsql: Avoid improbable PANIC during heap_update. Jeff Davis 16:35
Re: pgsql: Avoid improbable PANIC during heap_update. Peter Geoghegan 16:53
Re: Question: test "aggregates" failed in 32-bit machine 📎 Tom Lane 19:13
Re: Question: test "aggregates" failed in 32-bit machine Peter Geoghegan 19:26
Re: [PATCH v1] [meson] add a default option prefix=/usr/local/pgsql Andres Freund 19:44
Re: Question: test "aggregates" failed in 32-bit machine Tom Lane 19:50
Re: pg_regress: lookup shellprog in $PATH Noah Misch 19:59
Re: interrupted tap tests leave postgres instances around Andres Freund 20:38
Re: Question: test "aggregates" failed in 32-bit machine Jonathan S. Katz 20:58
Re: longfin and tamandua aren't too happy but I'm not sure why Andres Freund 22:15
Re: Question: test "aggregates" failed in 32-bit machine 📎 Tom Lane 22:57
Re: longfin and tamandua aren't too happy but I'm not sure why Justin Pryzby 22:58

Oct. 2, 2022

Thread Author Time
Re: ci: reduce macos test concurrency Andres Freund 00:00
Re: CI and test improvements Andres Freund 00:45
Re: CI and test improvements Justin Pryzby 00:58
Re: TAP output format in pg_regress Andres Freund 01:01
Re: Tightening behaviour for non-immutable behaviour in immutable functions Andres Freund 01:05
Re: Eliminating SPI from RI triggers - take 2 Andres Freund 01:21
Re: Eliminating SPI from RI triggers - take 2 Andres Freund 01:24
Re: CI and test improvements Andres Freund 01:36
Re: Documentation building fails on HTTPS redirect (again) Andres Freund 01:49
Re: Add last_vacuum_index_scans in pg_stat_all_tables Kshetrapaldesi Tutika 06:56
Re: proposal: possibility to read dumped table's name from file 📎 Andres Freund 06:56
Re: Amcheck verification of GiST and GIN 📎 Andres Freund 07:12
Re: pgstattuple: add test for coverage Andres Freund 07:14
Re: Transparent column encryption Andres Freund 07:16
Re: proposal: possibility to read dumped table's name from file 📎 Andres Freund 07:19
Re: [PATCH] Add sortsupport for range types and btree_gist 📎 Andres Freund 07:23
Re: [PATCH] Add sortsupport for range types and btree_gist 📎 Andres Freund 07:29
Re: disfavoring unparameterized nested loops Robert Haas 10:43
Re: Bloom filter Pushdown Optimization for Merge Join Zhihong Yu 13:40
Re: Bloom filter Pushdown Optimization for Merge Join Zhihong Yu 14:42
Re: [Proposal] Add foreign-server health checks infrastructure Andres Freund 15:39
Re: pgstattuple: add test for coverage Dong Wook Lee 15:42
Re: pg_upgrade test failure Andres Freund 15:46
Re: proposal: possibility to read dumped table's name from file 📎 Andres Freund 16:04
Re: Question: test "aggregates" failed in 32-bit machine Jonathan S. Katz 16:36
ssl tests aren't concurrency safe due to get_free_port() Andres Freund 16:49
Re: Table AM and DROP TABLE [ Was: Table AM and DDLs] Andres Freund 16:53
Re: Proposal for internal Numeric to Uint64 conversion function. Andres Freund 16:55
Re: How to retain lesser paths at add_path()? Andres Freund 16:59
Re: Improve TAP tests of pg_upgrade for cross-version tests Andres Freund 17:02
Re: [PoC] Improve dead tuple storage for lazy vacuum Andres Freund 17:04
Re: ExecRTCheckPerms() and many prunable partitions Andres Freund 17:10
Re: Question: test "aggregates" failed in 32-bit machine Tom Lane 17:12
Re: Add support for DEFAULT specification in COPY FROM Andres Freund 17:17
Re: pg_stat_bgwriter.buffers_backend is pretty meaningless (and more?) Andres Freund 17:24
Re: [RFC] building postgres with meson - v13 Justin Pryzby 17:25
Re: Question: test "aggregates" failed in 32-bit machine Jonathan S. Katz 17:32
Re: Making pg_rewind faster 📎 Andres Freund 17:44
Re: [RFC] building postgres with meson - v13 Andres Freund 18:05
Re: Question: test "aggregates" failed in 32-bit machine Tom Lane 18:11
Re: [RFC] building postgres with meson - v13 Justin Pryzby 18:38
Re: disfavoring unparameterized nested loops Peter Geoghegan 18:39
Re: Question: test "aggregates" failed in 32-bit machine 📎 Tom Lane 19:10
Re: pg_upgrade test failure Thomas Munro 20:07
Re: disfavoring unparameterized nested loops Peter Geoghegan 20:22
Re: Question: test "aggregates" failed in 32-bit machine David Rowley 20:35
Re: CI and test improvements 📎 Andres Freund 20:52
Re: proposal: possibility to read dumped table's name from file Daniel Gustafsson 20:52
Re: Question: test "aggregates" failed in 32-bit machine Tom Lane 20:59
Re: Documentation building fails on HTTPS redirect (again) Daniel Gustafsson 21:00
Re: proposal: possibility to read dumped table's name from file Tom Lane 21:02
Re: proposal: possibility to read dumped table's name from file Andres Freund 21:11
Re: Question: test "aggregates" failed in 32-bit machine David Rowley 21:28
Re: CI and test improvements Justin Pryzby 21:35
Re: Question: test "aggregates" failed in 32-bit machine Tom Lane 21:36
Re: CI and test improvements Andres Freund 21:51
Re: CI and test improvements Andres Freund 21:54
Re: missing indexes in indexlist with partitioned tables David Rowley 22:51
Re: missing indexes in indexlist with partitioned tables Tom Lane 23:07
Re: pg_upgrade test failure 📎 Thomas Munro 23:10
Re: Reducing the chunk header sizes on all memory context types David Rowley 23:43

Oct. 3, 2022

Thread Author Time
Re: [RFC] building postgres with meson - v13 Justin Pryzby 00:19
Re: pg_upgrade test failure Michael Paquier 00:40
Re: Question: test "aggregates" failed in 32-bit machine Michael Paquier 00:45
Re: CI and test improvements Justin Pryzby 02:15
Re: Improve TAP tests of pg_upgrade for cross-version tests 📎 Michael Paquier 02:23
Re: [PoC] Improve dead tuple storage for lazy vacuum Masahiko Sawada 02:58
Re: [PATCH] Log details for client certificate failures Masahiko Sawada 02:59
Re: pg_upgrade test failure Thomas Munro 03:03
[PATCH] Fix build with LLVM 15 or above 📎 Po-Chuan Hsieh 03:55
Re: proposal: possibility to read dumped table's name from file Pavel Stehule 04:00
Re: proposal: possibility to read dumped table's name from file Julien Rouhaud 04:34
Re: [PATCH] Fix build with LLVM 15 or above Thomas Munro 05:34
Re: pg_upgrade test failure Michael Paquier 06:28
Re: [RFC] building postgres with meson - v13 samay sharma 07:39
Re: [PATCH] Add peer authentication TAP test Michael Paquier 07:46
RE: [Proposal] Add foreign-server health checks infrastructure [email protected] 07:50
Re: Small miscellaneous fixes Masahiko Sawada 08:01
Re: Improve description of XLOG_RUNNING_XACTS Michael Paquier 08:15
Re: Improve description of XLOG_RUNNING_XACTS Masahiko Sawada 08:49
Re: [Proposal] Add foreign-server health checks infrastructure Önder Kalacı 08:59
Re: [PATCH] Add peer authentication TAP test Drouvot, Bertrand 08:59
Re: ExecRTCheckPerms() and many prunable partitions 📎 Amit Langote 09:10
RE: [Proposal] Add foreign-server health checks infrastructure [email protected] 09:58
Re: Small miscellaneous fixes Ranier Vilela 11:05
Re: Allow logical replication to copy tables in binary format 📎 Melih Mutlu 11:50
Re: Tracking last scan time Dave Page 11:55
re: PostgreSQL 15 GA release date Ranier Vilela 12:05
Re: problems with making relfilenodes 56-bits Robert Haas 12:12
Re: Support load balancing in libpq 📎 Jelte Fennema 12:15
Re: PostgreSQL 15 GA release date Justin Pryzby 12:39
Re: PostgreSQL 15 GA release date Julien Rouhaud 12:40
Re: [BUG] parenting a PK constraint to a self-FK one (Was: Self FK oddity when attaching a partition) 📎 Jehan-Guillaume de Rorthais 12:47
Re: PostgreSQL 15 GA release date Ranier Vilela 12:49
Re: PostgreSQL 15 GA release date Ranier Vilela 12:50
[Commitfest 2022-09] Date is Over. Ibrar Ahmed 13:11
Re: Avoid memory leaks during base backups 📎 Bharath Rupireddy 13:48
Re: Question: test "aggregates" failed in 32-bit machine Jonathan S. Katz 13:58
Re: Question: test "aggregates" failed in 32-bit machine Tom Lane 14:05
PostgreSQL 15 RC2 + GA release dates Jonathan S. Katz 14:07
Re: [Proposal] Add foreign-server health checks infrastructure Önder Kalacı 14:19
Miscellaneous tab completion issue fixes 📎 vignesh C 15:11
Possible solution for masking chosen columns when using pg_dump 📎 Олег Целебровский 15:30
Re: Possible solution for masking chosen columns when using pg_dump Julien Rouhaud 15:44
Re: Question: test "aggregates" failed in 32-bit machine Tom Lane 16:08
Re: Bloom filter Pushdown Optimization for Merge Join 📎 Tomas Vondra 16:14
Re: [patch] \g with multiple result sets and \watch with copy queries Tom Lane 17:00
Re: problems with making relfilenodes 56-bits Andres Freund 17:01
Re: Question: test "aggregates" failed in 32-bit machine Tomas Vondra 17:21
Re: Miscellaneous tab completion issue fixes Dagfinn Ilmari Mannsåker 17:29
Re: problems with making relfilenodes 56-bits Matthias van de Meent 17:40
Re: Crash in BRIN minmax-multi indexes Tomas Vondra 17:53
Re: [PoC] Federated Authn/z with OAUTHBEARER Andrey Chudnovsky 18:04
Re: [patch] \g with multiple result sets and \watch with copy queries Tom Lane 19:09
Re: [PATCH] Fix build with LLVM 15 or above 📎 Andres Freund 19:16
Re: Crash in BRIN minmax-multi indexes Jaime Casanova 19:25
Re: pgsql: Avoid improbable PANIC during heap_update. Jaime Casanova 19:34
Re: Reducing the chunk header sizes on all memory context types Tom Lane 19:37
Error-safe user functions 📎 Nikita Glukhov 19:44
Re: Crash in BRIN minmax-multi indexes Tomas Vondra 20:29
Re: problems with making relfilenodes 56-bits Andres Freund 21:25
Re: [PATCH] Fix build with LLVM 15 or above 📎 Andres Freund 21:41
Re: [PATCH] Fix build with LLVM 15 or above Zhihong Yu 21:45
Re: Pluggable toaster 📎 Nikita Malakhov 22:02
installing static libraries (was building postgres with meson) Andres Freund 22:42
Re: Error-safe user functions 📎 Nikita Glukhov 23:13
installcheck-world concurrency issues 📎 Andres Freund 23:41

Oct. 4, 2022

Thread Author Time
Re: Reducing the chunk header sizes on all memory context types 📎 Ranier Vilela 00:35
Re: New strategies for freezing, advancing relfrozenxid early Jeff Davis 00:41
Re: shadow variables - pg15 edition 📎 David Rowley 01:27
RE: [Proposal] Add foreign-server health checks infrastructure [email protected] 02:26
Re: shadow variables - pg15 edition Justin Pryzby 02:30
Re: New strategies for freezing, advancing relfrozenxid early Peter Geoghegan 03:11
Re: [RFC] building postgres with meson - v13 📎 Andres Freund 03:25
Re: Miscellaneous tab completion issue fixes Michael Paquier 03:43
Re: ExecRTCheckPerms() and many prunable partitions Amit Langote 03:45
Re: ExecRTCheckPerms() and many prunable partitions Tom Lane 03:54
Re: ExecRTCheckPerms() and many prunable partitions Amit Langote 04:11
Re: Small miscellaneous fixes Michael Paquier 04:18
Re: Crash in BRIN minmax-multi indexes Jaime Casanova 04:26
Re: Add last_vacuum_index_scans in pg_stat_all_tables 📎 Ken Kato 04:49
Re: New strategies for freezing, advancing relfrozenxid early Jeff Davis 05:13
Re: GUC tables - use designated initializers 📎 Peter Smith 05:20
Re: [POC] Allow flattening of subquery with a link to upper query 📎 Andrey Lepikhov 05:35
Use XLogFromFileName() in pg_resetwal to parse position from WAL file 📎 Bharath Rupireddy 05:36
Re: ssl tests aren't concurrency safe due to get_free_port() Andrew Dunstan 05:39
Re: New strategies for freezing, advancing relfrozenxid early Peter Geoghegan 05:45
possibility of partial data dumps with pg_dump 📎 Никита Старовойтов 05:57
Re: Use XLogFromFileName() in pg_resetwal to parse position from WAL file Kyotaro Horiguchi 06:17
Re: Use XLogFromFileName() in pg_resetwal to parse position from WAL file Bharath Rupireddy 06:22
Re: Use XLogFromFileName() in pg_resetwal to parse position from WAL file Kyotaro Horiguchi 06:23
Re: Use XLogFromFileName() in pg_resetwal to parse position from WAL file Michael Paquier 06:28
Re: Convert macros to static inline functions 📎 Peter Eisentraut 06:30
Re: Use XLogFromFileName() in pg_resetwal to parse position from WAL file Kyotaro Horiguchi 06:41
Re: GUC tables - use designated initializers Michael Paquier 06:48
Re: Convert macros to static inline functions Amul Sul 06:57
Re: GUC tables - use designated initializers Peter Smith 07:01
get rid of Abs() 📎 Peter Eisentraut 07:07
Re: log_heap_visible(): remove unused parameter and update comment Bharath Rupireddy 07:19
future of serial and identity columns 📎 Peter Eisentraut 07:41
Assorted fixes related to WAL files (was: Use XLogFromFileName() in pg_resetwal to parse position from WAL file) 📎 Bharath Rupireddy 07:50
Re: installcheck-world concurrency issues Michael Paquier 08:05
pid_t on mingw 📎 Peter Eisentraut 08:15
Re: Fix some newly modified tab-complete changes Peter Smith 08:16

Browse Archives

Prev | Next