pgsql-hackers since 2025-01-24 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
Jump to day: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31

Jan. 24, 2025

Thread Author Time
Re: Extended Statistics set/restore/clear functions. Corey Huinker 00:06
Re: Log a warning in pg_createsubscriber for max_slot_wal_keep_size Peter Smith 00:24
Re: [PATCH] Optionally record Plan IDs to track plan changes for a query 📎 Sami Imseih 01:25
Re: Allow NOT VALID foreign key constraints on partitioned tables. Tom Lane 02:16
Re: Pgoutput not capturing the generated columns Amit Kapila 02:24
Re: Enhance 'pg_createsubscriber' to retrieve databases automatically when no database is provided. Peter Smith 02:43
Re: SQL:2011 application time Tom Lane 02:55
Re: Pgoutput not capturing the generated columns Tom Lane 03:09
Re: Pgoutput not capturing the generated columns Amit Kapila 04:15
Re: Pgoutput not capturing the generated columns Tom Lane 04:21
Re: create subscription with (origin = none, copy_data = on) 📎 Shlok Kyal 04:22
Re: Pgoutput not capturing the generated columns vignesh C 05:06
Re: Extended Statistics set/restore/clear functions. 📎 Corey Huinker 05:20
Re: pg_createsubscriber TAP test wrapping makes command options hard to read. Michael Paquier 06:22
RE: Proposal: Filter irrelevant change before reassemble transactions during logical decoding Zhijie Hou (Fujitsu) 06:28
Re: XMLDocument (SQL/XML X030) Pavel Stehule 06:28
Re: Disabling vacuum truncate for autovacuum 📎 Gurjeet Singh 06:33
Re: Improve verification of recovery_target_timeline GUC. Michael Paquier 06:44
Re: pure parsers and reentrant scanners Peter Eisentraut 06:46
Re: POC: track vacuum/analyze cumulative time per relation Michael Paquier 07:32
Re: Pgoutput not capturing the generated columns 📎 vignesh C 07:38
Re: [PATCH] Optionally record Plan IDs to track plan changes for a query Lukas Fittl 07:44
Re: why -Fdance archive format option works with ./pg_restore but not with ./pg_dump? 📎 Srinath Reddy 08:04
Re: XMLDocument (SQL/XML X030) Jim Jones 08:11
Re: Add RESPECT/IGNORE NULLS and FROM FIRST/LAST options 📎 Oliver Ford 08:27
Re: Enhance 'pg_createsubscriber' to retrieve databases automatically when no database is provided. Ashutosh Bapat 08:27
Re: Show WAL write and fsync stats in pg_stat_io 📎 Nazir Bilal Yavuz 08:31
Re: [RFC] Lock-free XLog Reservation from WAL Japin Li 09:07
Re: [PATCH] Optionally record Plan IDs to track plan changes for a query Andrei Lepikhov 09:23
Re: [PATCH] Optionally record Plan IDs to track plan changes for a query 📎 Lukas Fittl 09:59
Re: Showing applied extended statistics in explain Part 2 Andrei Lepikhov 10:17
Re: Proposal to Enable/Disable Index using ALTER INDEX (with patch) Benoit Lobréau 10:32
Re: doc: explain pgstatindex fragmentation Bertrand Drouvot 10:47
Re: Allow NOT VALID foreign key constraints on partitioned tables. 📎 Amul Sul 10:50
Re: XMLDocument (SQL/XML X030) Pavel Stehule 11:31
Re: doc: explain pgstatindex fragmentation 📎 Frédéric Yhuel 11:34
Re: create subscription with (origin = none, copy_data = on) Sergey Tatarintsev 12:13
RE: Windows meson build 📎 Kohei Harikae (Fujitsu) 12:13
Re: XMLDocument (SQL/XML X030) Jim Jones 12:21
Re: Convert sepgsql tests to TAP Peter Eisentraut 12:25
Re: XMLDocument (SQL/XML X030) Pavel Stehule 12:48
Re: Casts from jsonb to other types should cope with json null Maxim Orlov 12:56
Re: [PATCH] Add get_bytes() and set_bytes() functions 📎 Aleksander Alekseev 13:00
Re: Quadratic planning time for ordered paths over partitioned tables Aleksander Alekseev 13:15
Re: doc: explain pgstatindex fragmentation Bertrand Drouvot 13:34
Re: SQL Property Graph Queries (SQL/PGQ) 📎 Ashutosh Bapat 13:36
Re: Improve verification of recovery_target_timeline GUC. 📎 David Steele 13:36
Re: Quadratic planning time for ordered paths over partitioned tables Alvaro Herrera 13:37
Re: Enhancing Memory Context Statistics Reporting Rahila Syed 13:47
Re: XMLDocument (SQL/XML X030) Jim Jones 13:48
Re: Replace current implementations in crypt() and gen_salt() to OpenSSL Daniel Gustafsson 13:55
Re: doc: explain pgstatindex fragmentation Laurenz Albe 13:58
Re: Replace current implementations in crypt() and gen_salt() to OpenSSL Joe Conway 13:59
Re: Convert sepgsql tests to TAP Andrew Dunstan 14:00
Re: Convert sepgsql tests to TAP Joe Conway 14:11
Re: why -Fdance archive format option works with ./pg_restore but not with ./pg_dump? Andrew Dunstan 14:14
Re: Eagerly scan all-visible pages to amortize aggressive vacuum Melanie Plageman 14:15
Re: Proposal to Enable/Disable Index using ALTER INDEX (with patch) Benoit Lobréau 14:20
Re: Show WAL write and fsync stats in pg_stat_io Bertrand Drouvot 14:20
Re: Quadratic planning time for ordered paths over partitioned tables Alexander Kuzmenkov 14:40
Re: doc: explain pgstatindex fragmentation 📎 Frédéric Yhuel 14:41
Re: Orphaned users in PG16 and above can only be managed by Superusers Andrew Dunstan 14:53
Re: postgres_fdw could deparse ArrayCoerceExpr Maxim Orlov 15:09
Re: Non-text mode for pg_dumpall 📎 jian he 15:20
Re: Purpose of wal_init_zero Hannu Krosing 15:22
Re: why -Fdance archive format option works with ./pg_restore but not with ./pg_dump? Tom Lane 15:24
Re: Proposal to Enable/Disable Index using ALTER INDEX (with patch) 📎 Benoit Lobréau 15:26
Re: XMLDocument (SQL/XML X030) Pavel Stehule 15:27
Re: Show WAL write and fsync stats in pg_stat_io Nazir Bilal Yavuz 15:29
vacuumdb changes for stats import/export 📎 Nathan Bossart 15:44
Re: SQL Property Graph Queries (SQL/PGQ) 📎 Junwang Zhao 15:46
Re: Casts from jsonb to other types should cope with json null Tom Lane 15:48
Re: XMLDocument (SQL/XML X030) Chapman Flack 15:49
Re: Orphaned users in PG16 and above can only be managed by Superusers Nathan Bossart 15:55
Re: SQL Property Graph Queries (SQL/PGQ) Junwang Zhao 15:56
Re: Convert sepgsql tests to TAP Tom Lane 15:57
Re: Orphaned users in PG16 and above can only be managed by Superusers Nathan Bossart 16:01
Re: pg_createsubscriber TAP test wrapping makes command options hard to read. Tom Lane 16:03
Re: Orphaned users in PG16 and above can only be managed by Superusers Ashutosh Sharma 16:04
Re: XMLDocument (SQL/XML X030) Chapman Flack 16:18
Re: vacuumdb changes for stats import/export Corey Huinker 16:19
Re: Eagerly scan all-visible pages to amortize aggressive vacuum Robert Haas 16:20
BF member drongo doesn't like 035_standby_logical_decoding.pl Tom Lane 16:42
Re: Modern SHA2- based password hashes for pgcrypto Bernd Helmle 17:14
Re: Modern SHA2- based password hashes for pgcrypto Alvaro Herrera 18:06
Re: Return pg_control from pg_backup_stop(). 📎 David Steele 18:43
Re: pg_createsubscriber TAP test wrapping makes command options hard to read. 📎 Dagfinn Ilmari Mannsåker 18:59
Re: BF member drongo doesn't like 035_standby_logical_decoding.pl Alexander Lakhin 19:00
Re: POC: enable logical decoding when wal_level = 'replica' without a server restart 📎 Masahiko Sawada 19:16
Re: Casts from jsonb to other types should cope with json null 📎 Tom Lane 19:20
Re: BF member drongo doesn't like 035_standby_logical_decoding.pl Andres Freund 19:23
Re: POC: enable logical decoding when wal_level = 'replica' without a server restart Masahiko Sawada 19:28
Re: BF member drongo doesn't like 035_standby_logical_decoding.pl Andres Freund 19:44
Re: Convert sepgsql tests to TAP Andrew Dunstan 19:44
Re: why -Fdance archive format option works with ./pg_restore but not with ./pg_dump? Andrew Dunstan 19:47
Re: BF member drongo doesn't like 035_standby_logical_decoding.pl Andres Freund 19:52
Re: BF member drongo doesn't like 035_standby_logical_decoding.pl Tom Lane 19:56
Re: XMLDocument (SQL/XML X030) 📎 Jim Jones 19:59
Re: Eagerly scan all-visible pages to amortize aggressive vacuum 📎 Melanie Plageman 20:02
Re: Reorder shutdown sequence, to flush pgstats later 📎 Andres Freund 20:06
Re: Windows: openssl & gssapi dislike each other Andrew Dunstan 20:07
Re: POC: track vacuum/analyze cumulative time per relation Sami Imseih 20:19
Re: Windows: openssl & gssapi dislike each other Dave Page 20:24
RE: Proposal for Updating CRC32C with AVX-512 Algorithm. Devulapalli, Raghuveer 20:34
Re: Eagerly scan all-visible pages to amortize aggressive vacuum Robert Haas 20:43
Re: BF member drongo doesn't like 035_standby_logical_decoding.pl Andres Freund 20:49
Re: Eager aggregation, take 3 Robert Haas 20:53
Re: XMLDocument (SQL/XML X030) Chapman Flack 21:01
Re: Convert sepgsql tests to TAP Tom Lane 21:07
Re: vacuumdb changes for stats import/export Masahiko Sawada 21:25
Re: [PATCH] SVE popcount support Nathan Bossart 21:37
Re: Windows: openssl & gssapi dislike each other Daniel Gustafsson 21:45
Re: XMLDocument (SQL/XML X030) 📎 Jim Jones 22:11
Re: Convert sepgsql tests to TAP Andrew Dunstan 22:16
Re: Enhancing Memory Context Statistics Reporting Tomas Vondra 22:20
Re: Convert sepgsql tests to TAP Tom Lane 22:29
Re: Convert sepgsql tests to TAP Tom Lane 22:46
Re: Convert sepgsql tests to TAP Tom Lane 23:08
Re: pg_createsubscriber TAP test wrapping makes command options hard to read. Michael Paquier 23:09
Re: Convert sepgsql tests to TAP Robins Tharakan 23:11
Re: Separate GUC for replication origins Masahiko Sawada 23:12
Re: Convert sepgsql tests to TAP Andrew Dunstan 23:20
Re: Convert sepgsql tests to TAP Tom Lane 23:41

Jan. 25, 2025

Thread Author Time
Re: Convert sepgsql tests to TAP Robins Tharakan 00:09
Re: Inconsistent string comparison using modified ICU collations Jeff Davis 00:21
Re: Proposal: "query_work_mem" GUC, to distribute working memory to the query's individual operators James Hunter 00:48
Re: Convert sepgsql tests to TAP Andrew Dunstan 00:50
Re: Proposal: "query_work_mem" GUC, to distribute working memory to the query's individual operators James Hunter 01:04
Re: Convert sepgsql tests to TAP Andrew Dunstan 01:27
Re: Proposal: "query_work_mem" GUC, to distribute working memory to the query's individual operators Jeff Davis 01:48
Re: Adding skip scan (including MDAM style range skip scan) to nbtree Heikki Linnakangas 03:07
Re: Adding skip scan (including MDAM style range skip scan) to nbtree Peter Geoghegan 03:38
Re: Allow NOT VALID foreign key constraints on partitioned tables. Alexander Lakhin 05:00
Re: Add CASEFOLD() function. Tom Lane 05:00
Re: POC, WIP: OR-clause support for indexes 📎 Alexander Korotkov 05:04
Re: New process of getting changes into the commitfest app Akshat Jaimini 05:28
Re: XMLDocument (SQL/XML X030) Pavel Stehule 07:16
Re: Index AM API cleanup 📎 Peter Eisentraut 07:18
Re: XMLDocument (SQL/XML X030) 📎 Jim Jones 08:10
Re: Add CASEFOLD() function. Jeff Davis 08:20
Re: Allow NOT VALID foreign key constraints on partitioned tables. Álvaro Herrera 10:29
Re: XMLDocument (SQL/XML X030) Pavel Stehule 10:50
Re: Convert sepgsql tests to TAP Robins Tharakan 11:18
Re: XMLDocument (SQL/XML X030) 📎 Jim Jones 11:45
Re: why -Fdance archive format option works with ./pg_restore but not with ./pg_dump? 📎 Srinath Reddy 12:42
Re: why -Fdance archive format option works with ./pg_restore but not with ./pg_dump? Srinath Reddy 13:12
Re: XMLDocument (SQL/XML X030) Pavel Stehule 13:23
Re: Adding a '--two-phase' option to 'pg_createsubscriber' utility. Shlok Kyal 13:44
Re: XMLDocument (SQL/XML X030) Chapman Flack 14:10
Re: XMLDocument (SQL/XML X030) Pavel Stehule 15:05
Re: why -Fdance archive format option works with ./pg_restore but not with ./pg_dump? Andrew Dunstan 16:18
Re: why -Fdance archive format option works with ./pg_restore but not with ./pg_dump? Tom Lane 16:25
Re: Reorder shutdown sequence, to flush pgstats later Andres Freund 16:44
Re: why -Fdance archive format option works with ./pg_restore but not with ./pg_dump? Srinath Reddy 16:51
Re: Set AUTOCOMMIT to on in script output by pg_dump Tom Lane 17:45
Re: doc: explain pgstatindex fragmentation Laurenz Albe 18:07
Re: System views for versions reporting 📎 Dmitry Dolgov 19:46
Re: Adjusting hash join memory limit to handle batch explosion 📎 Tomas Vondra 20:41
Re: Why we need to check for local buffers in BufferIsExclusiveLocked and BufferIsDirty? Tom Lane 21:50
Re: Convert sepgsql tests to TAP Tom Lane 21:55
Re: [PATCH] Hex-coding optimizations using SVE on ARM. Nathan Bossart 22:07
Re: [PATCH] Hex-coding optimizations using SVE on ARM. Nathan Bossart 22:07
MAX_BACKENDS size (comment accuracy) Jacob Brazeal 23:21

Jan. 26, 2025

Thread Author Time
Re: MAX_BACKENDS size (comment accuracy) 📎 Jacob Brazeal 00:06
Re: MAX_BACKENDS size (comment accuracy) Jacob Brazeal 07:35
Re: Using Expanded Objects other than Arrays from plpgsql Andrey Borodin 10:07
Re: Convert sepgsql tests to TAP Peter Eisentraut 10:26
Re: XMLDocument (SQL/XML X030) Jim Jones 13:48
Re: pg_createsubscriber TAP test wrapping makes command options hard to read. 📎 Andrew Dunstan 14:02
Re: pg_createsubscriber TAP test wrapping makes command options hard to read. Andrew Dunstan 14:12
Re: Why we need to check for local buffers in BufferIsExclusiveLocked and BufferIsDirty? 📎 Srinath Reddy 14:24
Re: Non-text mode for pg_dumpall 📎 jian he 14:46
Re: [RFC] Lock-free XLog Reservation from WAL 📎 Yura Sokolov 14:59
Re: [RFC] Lock-free XLog Reservation from WAL 📎 Yura Sokolov 15:09
Re: Convert sepgsql tests to TAP Joe Conway 15:29
Re: Using Expanded Objects other than Arrays from plpgsql Tom Lane 15:37
Re: Non-text mode for pg_dumpall Mahendra Singh Thalor 15:48
Re: Why we need to check for local buffers in BufferIsExclusiveLocked and BufferIsDirty? Tom Lane 16:19
Re: Eagerly scan all-visible pages to amortize aggressive vacuum Robert Treat 16:30
Re: Convert sepgsql tests to TAP Andrew Dunstan 16:36
Re: Allow NOT VALID foreign key constraints on partitioned tables. Álvaro Herrera 16:38
Re: Why we need to check for local buffers in BufferIsExclusiveLocked and BufferIsDirty? Srinath Reddy 16:54
Re: Using Expanded Objects other than Arrays from plpgsql Andrey Borodin 17:04
Re: New process of getting changes into the commitfest app Yura Sokolov 18:09
Re: MAX_BACKENDS size (comment accuracy) Andres Freund 18:10
Re: MAX_BACKENDS size (comment accuracy) Andres Freund 18:15
Re: Using Expanded Objects other than Arrays from plpgsql Tom Lane 19:04
Re: MAX_BACKENDS size (comment accuracy) 📎 Andres Freund 19:23
Re: Convert sepgsql tests to TAP Joe Conway 19:42
Re: Eagerly scan all-visible pages to amortize aggressive vacuum Robert Treat 20:11
Re: MAX_BACKENDS size (comment accuracy) Jacob Brazeal 20:55
Re: MAX_BACKENDS size (comment accuracy) Jacob Brazeal 20:57
Re: MAX_BACKENDS size (comment accuracy) Jacob Brazeal 21:08
Re: pg_createsubscriber TAP test wrapping makes command options hard to read. Michael Paquier 22:45

Jan. 27, 2025

Thread Author Time
Re: Set AUTOCOMMIT to on in script output by pg_dump Shinya Kato 00:23
Re: POC: track vacuum/analyze cumulative time per relation 📎 Michael Paquier 00:30
Re: Show WAL write and fsync stats in pg_stat_io 📎 Michael Paquier 00:52
Re: speedup COPY TO for partitioned table. jian he 01:47
Re: add function argument name to substring and substr 📎 jian he 02:20
Re: [PATCH] Optionally record Plan IDs to track plan changes for a query 📎 Michael Paquier 03:53

Browse Archives

Prev | Next
Jump to day: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31