pgsql-hackers since 2022-04-21 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

April 21, 2022

Thread Author Time
Re: DataRow message for Integer(int4) returns result as text? David G. Johnston 00:00
Re: DataRow message for Integer(int4) returns result as text? Tyler Brock 00:11
Re: DataRow message for Integer(int4) returns result as text? David G. Johnston 00:16
Re: CLUSTER sort on abbreviated expressions is broken Peter Geoghegan 00:18
Re: DataRow message for Integer(int4) returns result as text? Tyler Brock 00:21
Re: DataRow message for Integer(int4) returns result as text? David G. Johnston 00:26
Assorted small doc patches 📎 David G. Johnston 00:59
Re: CLUSTER sort on abbreviated expressions is broken Thomas Munro 01:52
RE: Logical replication timeout problem 📎 [email protected] 02:14
Re: Logical replication timeout problem Amit Kapila 02:19
Re: typos Amit Kapila 02:25
Re: More problems with VacuumPageHit style global variables Thomas Munro 02:50
Re: More problems with VacuumPageHit style global variables Peter Geoghegan 03:00
RE: Data is copied twice when specifying both child and parent table in publication 📎 [email protected] 03:05
Re: DataRow message for Integer(int4) returns result as text? Tom Lane 03:09
Re: Skipping schema changes in publication 📎 vignesh C 03:15
Re: [PATCH] Add native windows on arm64 support Michael Paquier 04:07
Re: Postgres perl module namespace Michael Paquier 04:11
Re: Fix NULL pointer reference in _outPathTarget() Richard Guo 04:25
Re: Add --{no-,}bypassrls flags to createuser Michael Paquier 04:29
Re: typos Michael Paquier 04:36
How to debug JIT-ed code in PostgreSQL using GDB Japin Li 04:46
Re: Logical replication timeout problem Masahiko Sawada 04:59
Two small issues related to table_relation_copy_for_cluster() and CTAS with no data. Paul Guo 06:29
Re: Re: fix cost subqueryscan wrong parallel cost [email protected] 06:38
Re: postgres_fdw: batch inserts vs. before row triggers Etsuro Fujita 06:49
Re: A qsort template John Naylor 07:09
Re: Assert failure in CTE inlining with view and correlated subquery Richard Guo 07:28
Re: Assert failure in CTE inlining with view and correlated subquery Richard Guo 07:51
Re: Checking pgwin32_is_junction() errors Michael Paquier 07:56
Re: effective_io_concurrency and NVMe devices 📎 David Rowley 08:14
Re: Assert failure in CTE inlining with view and correlated subquery Richard Guo 08:29
Re: BufferAlloc: don't take two simultaneous locks Yura Sokolov 09:04
Re: [PATCH] Add native windows on arm64 support Niyas Sait 09:21
Re: Data is copied twice when specifying both child and parent table in publication Amit Kapila 09:41
RE: Logical replication timeout problem 📎 [email protected] 09:50
Re: Dump/Restore of non-default PKs Simon Riggs 11:43
Re: Assert failure in CTE inlining with view and correlated subquery Tomas Vondra 11:48
Re: Re: fix cost subqueryscan wrong parallel cost Robert Haas 12:00
Re: Add version and data directory to initdb output Peter Eisentraut 12:15
Re: Postgres perl module namespace Andrew Dunstan 13:42
Re: effective_io_concurrency and NVMe devices 📎 Tomas Vondra 13:49
Re: DataRow message for Integer(int4) returns result as text? Peter Eisentraut 13:56
Re: typos Peter Eisentraut 13:59
Re: Add version and data directory to initdb output Tom Lane 14:18
Re: Add version and data directory to initdb output Michael Banck 14:24
Re: Add version and data directory to initdb output David G. Johnston 14:39
COPY TO STDOUT Apache Arrow support Adam Lippai 14:41
Re: typos Alvaro Herrera 17:16
Re: Assorted small doc patches Alvaro Herrera 17:46
Re: preserving db/ts/relfilenode OIDs across pg_upgrade (was Re: storing an explicit nonce) 📎 Tom Lane 17:53
Re: Assert failure in CTE inlining with view and correlated subquery 📎 Tom Lane 19:03
Re: Assorted small doc patches David G. Johnston 19:15
Re: preserving db/ts/relfilenode OIDs across pg_upgrade (was Re: storing an explicit nonce) Robert Haas 19:25
Re: Add --{no-,}bypassrls flags to createuser Robert Haas 19:51
Re: error handling in pqRowProcessor broken Peter Eisentraut 20:18
Re: Add --{no-,}bypassrls flags to createuser David G. Johnston 20:21
Re: preserving db/ts/relfilenode OIDs across pg_upgrade (was Re: storing an explicit nonce) Tom Lane 20:24
Re: BufferAlloc: don't take two simultaneous locks Robert Haas 20:24
Re: Replace open mode with PG_BINARY_R/W/A macros Peter Eisentraut 20:25
Re: [RFC] building postgres with meson -v8 Peter Eisentraut 20:36
Re: Replace open mode with PG_BINARY_R/W/A macros Tom Lane 20:38
Re: Assert failure in CTE inlining with view and correlated subquery Tomas Vondra 20:45
Re: [RFC] building postgres with meson -v8 Andres Freund 20:56
Re: error handling in pqRowProcessor broken Tom Lane 21:13
Re: [RFC] building postgres with meson -v8 Tom Lane 21:34
Re: Assert failure in CTE inlining with view and correlated subquery Tom Lane 21:59
Re: BufferAlloc: don't take two simultaneous locks Yura Sokolov 22:58
Re: More problems with VacuumPageHit style global variables Peter Geoghegan 23:28
Re: More problems with VacuumPageHit style global variables Peter Geoghegan 23:53

April 22, 2022

Thread Author Time
Re: Replace open mode with PG_BINARY_R/W/A macros Japin Li 01:51
Re: Implementing Incremental View Maintenance 📎 Yugo NAGATA 02:29
Re: Replace open mode with PG_BINARY_R/W/A macros Tom Lane 03:21
Re: fix cost subqueryscan wrong parallel cost bucoo 03:35
Re: Perform streaming logical transactions by background workers and parallel apply Peter Smith 04:12
Re: A qsort template David Rowley 04:13
Re: A qsort template John Naylor 04:37
Allow specifying column list for foreign key ON DELETE SET src_test_regress_sql_foreign_key.sql don't understand the comment. alias 05:06
Re: A qsort template Thomas Munro 05:10
Re: Implementing Incremental View Maintenance 📎 Yugo NAGATA 05:58
Re: wrong fds used for refilenodes after pg_upgrade relfilenode changes Reply-To: 📎 Thomas Munro 07:37
Re: Estimating HugePages Requirements? Magnus Hagander 07:49
[PATCH] Compression dictionaries for JSONB 📎 Aleksander Alekseev 08:30
Re: RFC: compression dictionaries for JSONB Aleksander Alekseev 08:33
Re: BufferAlloc: don't take two simultaneous locks 📎 Yura Sokolov 08:49
Re: [Proposal] vacuumdb --schema only 📎 Gilles Darold 09:57
Re: Proposal for internal Numeric to Uint64 conversion function. 📎 Amul Sul 12:26
Re: pgsql: Allow db.schema.table patterns, but complain about random garbag Andrew Dunstan 13:15
Re: pg_walcleaner - new tool to detect, archive and delete the unneeded wal files (was Re: pg_archivecleanup - add the ability to detect, archive and delete the unneeded wal files on the primary) Bharath Rupireddy 13:37
Re: Dump/Restore of non-default PKs Peter Eisentraut 13:38
Re: pg_receivewal fail to streams when the partial file to write is not fully initialized present in the wal receiver directory Bharath Rupireddy 13:47
Re: How to generate a WAL record spanning multiple WAL files? Bharath Rupireddy 14:02
Re: pgsql: Allow db.schema.table patterns, but complain about random garbag Tom Lane 14:04
Re: Dump/Restore of non-default PKs Tom Lane 14:14
Re: why pg_walfile_name() cannot be executed during recovery? Bharath Rupireddy 14:15
Re: Fix NULL pointer reference in _outPathTarget() Peter Eisentraut 14:16
Re: Fix NULL pointer reference in _outPathTarget() Tom Lane 14:18
Re: How to simulate sync/async standbys being closer/farther (network distance) to primary in core postgres? Bharath Rupireddy 14:23
Re: pgsql: Allow db.schema.table patterns, but complain about random garbag Andrew Dunstan 14:24
Cryptohash OpenSSL error queue in FIPS enabled builds 📎 Daniel Gustafsson 14:56
Re: [PATCH] Compression dictionaries for JSONB Zhihong Yu 15:21
Re: Re: fix cost subqueryscan wrong parallel cost David G. Johnston 15:55
Re: Skipping schema changes in publication Bharath Rupireddy 16:09
Re: Handle infinite recursion in logical replication setup 📎 vignesh C 16:15
Re: Handle infinite recursion in logical replication setup vignesh C 16:23
Re: Handle infinite recursion in logical replication setup vignesh C 16:28
Re: Cryptohash OpenSSL error queue in FIPS enabled builds Tom Lane 17:01
Why is EXECUTE granted to PUBLIC for all routines? Jacek Trocinski 17:31
Re: Why is EXECUTE granted to PUBLIC for all routines? Tom Lane 17:44
Re: Postgres perl module namespace Andres Freund 18:36
Re: Building Postgres with lz4 on Visual Studio Andres Freund 19:54
Re: pgsql: Allow db.schema.table patterns, but complain about random garbag Robert Haas 20:06
Re: pgsql: Allow db.schema.table patterns, but complain about random garbag Thomas Munro 21:12
[PATCH] Teach pg_waldump to extract FPIs from the WAL 📎 David Christensen 22:51

April 23, 2022

Thread Author Time
Re: pgsql: Allow db.schema.table patterns, but complain about random garbag Noah Misch 02:59
Re: [Proposal] vacuumdb --schema only 📎 Nathan Bossart 05:57
Re: Implementing Incremental View Maintenance Greg Stark 06:18
multirange of arrays not working on postgresql 14 Jian He 06:26
Re: Throttling WAL inserts when the standby falls behind more than the configured replica_lag_in_bytes Bharath Rupireddy 06:59
Re: multirange of arrays not working on postgresql 14 David G. Johnston 07:03
Re: [Patch] ALTER SYSTEM READ ONLY Bharath Rupireddy 08:03
Re: [PATCH] Teach pg_waldump to extract FPIs from the WAL Alvaro Herrera 13:39
Re: [PATCH] Teach pg_waldump to extract FPIs from the WAL Matthias van de Meent 14:49
Re: [PATCH] Allow multiple recursive self-references Tom Lane 15:14
Re: [PATCH] Teach pg_waldump to extract FPIs from the WAL 📎 David Christensen 18:43
Re: Cryptohash OpenSSL error queue in FIPS enabled builds Daniel Gustafsson 21:40

April 24, 2022

Thread Author Time
Re: Use generation context to speed up tuplesorts Noah Misch 00:59
Re: Use generation context to speed up tuplesorts Peter Geoghegan 01:11
Re: Why is EXECUTE granted to PUBLIC for all routines? Isaac Morland 02:43
Re: Use generation context to speed up tuplesorts David Rowley 05:16
RE: Data is copied twice when specifying both child and parent table in publication 📎 [email protected] 06:16
Re: pgsql: Allow db.schema.table patterns, but complain about random garbag Andrew Dunstan 17:09
Re: pgsql: Allow db.schema.table patterns, but complain about random garbag Noah Misch 18:19
Re: pgsql: Allow db.schema.table patterns, but complain about random garbag Andrew Dunstan 19:37
Re: [RFC] building postgres with meson -v8 Andrew Dunstan 19:44

April 25, 2022

Thread Author Time
Re: Estimating HugePages Requirements? Michael Paquier 00:15
Re: Cryptohash OpenSSL error queue in FIPS enabled builds Michael Paquier 00:50
Re: pg_receivewal fail to streams when the partial file to write is not fully initialized present in the wal receiver directory Michael Paquier 01:08
Re: [PATCH] Add native windows on arm64 support Michael Paquier 01:17
RE: Data is copied twice when specifying both child and parent table in publication [email protected] 01:23
Re: [Proposal] vacuumdb --schema only 📎 Nathan Bossart 01:27
Re: Defer selection of asynchronous subplans until the executor initialization stage 📎 Etsuro Fujita 04:29
json_object returning jsonb reuslt different from returning json, returning text alias 05:11
Re: json_object returning jsonb reuslt different from returning json, returning text alias 05:19
Re: [PATCH] Teach pg_waldump to extract FPIs from the WAL Michael Paquier 06:11
Re: why pg_walfile_name() cannot be executed during recovery? Andrey Borodin 06:18
Re: TRAP: FailedAssertion("tabstat->trans == trans", File: "pgstat_relation.c", Line: 508 Michael Paquier 06:18
Re: [Proposal] vacuumdb --schema only Gilles Darold 06:50
Re: [PATCH] Teach pg_waldump to extract FPIs from the WAL Drouvot, Bertrand 07:00
Re: A problem about partitionwise join 📎 Richard Guo 07:21
variable filename for psql \copy Jiří Fejfar 08:24
RE: Perform streaming logical transactions by background workers and parallel apply [email protected] 08:35
Re: variable filename for psql \copy Daniel Verite 10:24
Re: [PATCH] Teach pg_waldump to extract FPIs from the WAL Bharath Rupireddy 11:03
Re: pg_receivewal fail to streams when the partial file to write is not fully initialized present in the wal receiver directory Bharath Rupireddy 11:47
Re: tweak to a few index tests to hits ambuildempty() routine. Alvaro Herrera 13:05
Re: [PATCH] Compression dictionaries for JSONB 📎 Aleksander Alekseev 13:15
Re: tweak to a few index tests to hits ambuildempty() routine. Alvaro Herrera 13:34
Re: tweak to a few index tests to hits ambuildempty() routine. Alvaro Herrera 13:53
Re: tweak to a few index tests to hits ambuildempty() routine. Amul Sul 13:57
Re: tweak to a few index tests to hits ambuildempty() routine. Tom Lane 14:05
Re: json_object returning jsonb reuslt different from returning json, returning text 📎 Andrew Dunstan 14:14
An attempt to avoid locally-committed-but-not-replicated-to-standby-transactions in synchronous replication 📎 Bharath Rupireddy 14:21
Re: Estimating HugePages Requirements? Magnus Hagander 14:55
Re: [PATCH] Teach pg_waldump to extract FPIs from the WAL David Christensen 15:11
Re: [PATCH] Teach pg_waldump to extract FPIs from the WAL David Christensen 15:12
Re: [PATCH] Teach pg_waldump to extract FPIs from the WAL David Christensen 15:24
Move Section 9.27.7 (Data Object Management Functions) to System Information Chapter David G. Johnston 15:33
bogus: logical replication rows/cols combinations Alvaro Herrera 15:48
Re: variable filename for psql \copy David G. Johnston 16:07
Re: [Proposal] vacuumdb --schema only Nathan Bossart 16:18
Re: An attempt to avoid locally-committed-but-not-replicated-to-standby-transactions in synchronous replication Nathan Bossart 16:48
Re: proposal: possibility to read dumped table's name from file 📎 Pavel Stehule 17:39
Re: WIP: WAL prefetch (another approach) Tom Lane 18:11
Re: WIP: WAL prefetch (another approach) Tom Lane 18:31
Re: pg_walcleaner - new tool to detect, archive and delete the unneeded wal files (was Re: pg_archivecleanup - add the ability to detect, archive and delete the unneeded wal files on the primary) Stephen Frost 18:39
Re: pgsql: Allow db.schema.table patterns, but complain about random garbag Andrew Dunstan 18:57
Re: Use "WAL segment" instead of "log segment" consistently in user-facing messages Nathan Bossart 19:54
Re: Add --{no-,}bypassrls flags to createuser Nathan Bossart 20:19
Re: add checkpoint stats of snapshot and mapping files of pg_logical dir Nathan Bossart 20:34
Re: Cryptohash OpenSSL error queue in FIPS enabled builds 📎 Daniel Gustafsson 22:07
Re: bogus: logical replication rows/cols combinations Tomas Vondra 22:30
Re: Cryptohash OpenSSL error queue in FIPS enabled builds Tom Lane 22:44

April 26, 2022

Thread Author Time
Re: add checkpoint stats of snapshot and mapping files of pg_logical dir Michael Paquier 01:01
Re: Estimating HugePages Requirements? Michael Paquier 01:34
Re: Skipping schema changes in publication Peter Smith 01:55
Re: Cryptohash OpenSSL error queue in FIPS enabled builds Michael Paquier 01:55
Re: Building Postgres with lz4 on Visual Studio Michael Paquier 02:19
Re: [Proposal] vacuumdb --schema only Michael Paquier 02:36
Re: [PATCH] Teach pg_waldump to extract FPIs from the WAL Michael Paquier 02:42
Re: [PATCH] Teach pg_waldump to extract FPIs from the WAL Michael Paquier 02:53
Re: [Proposal] vacuumdb --schema only 📎 Nathan Bossart 04:46
Re: BUG #17448: In Windows 10, version 1703 and later, huge_pages doesn't work. Julien Rouhaud 04:54
Re: pgsql: Add contrib/pg_walinspect. Michael Paquier 05:13
Re: CLUSTER on partitioned index Michael Paquier 05:17
Re: Making JIT more granular 📎 David Rowley 05:24
Re: pgsql: Add contrib/pg_walinspect. Tom Lane 05:25
Re: CLUSTER on partitioned index Alvaro Herrera 05:28
Re: pgsql: Add contrib/pg_walinspect. Michael Paquier 05:36
RE: Skipping schema changes in publication [email protected] 06:02

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