pgsql-hackers since 2022-03-31 22:01

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

March 31, 2022

Thread Author Time
Re: pg_receivewal fail to streams when the partial file to write is not fully initialized present in the wal receiver directory Cary Huang 22:01
Re: head fails to build on SLES 12 (wal_compression=zstd) 📎 Justin Pryzby 22:42
Re: should vacuum's first heap pass be read-only? Peter Geoghegan 22:42
Re: unlogged sequences Tomas Vondra 22:43
Re: Slow standby snapshot 📎 Michail Nikolaev 23:18
Re: unlogged sequences David G. Johnston 23:36
Re: head fails to build on SLES 12 (wal_compression=zstd) Tom Lane 23:38
[WIP] ALTER COLUMN IF EXISTS 📎 Bradley Ayers 23:39
Re: pg_ls_tmpdir to show directories and shared filesets (and pg_ls_*) 📎 Justin Pryzby 23:42
Re: [PATCH] Full support for index LP_DEAD hint bits on standby Michail Nikolaev 23:57
Re: [PATCH] Full support for index LP_DEAD hint bits on standby Michail Nikolaev 23:58

April 1, 2022

Thread Author Time
Re: [WIP] ALTER COLUMN IF EXISTS David G. Johnston 00:01
Re: unlogged sequences Robert Haas 00:25
Re: [WIP] ALTER COLUMN IF EXISTS Tom Lane 00:30
Re: should vacuum's first heap pass be read-only? Robert Haas 00:30
Re: head fails to build on SLES 12 (wal_compression=zstd) Robert Haas 00:39
Re: unlogged sequences Tomas Vondra 00:42
Re: unlogged sequences David G. Johnston 00:44
Re: [WIP] ALTER COLUMN IF EXISTS Robert Haas 00:52
Re: unlogged sequences Robert Haas 00:54
Re: [HACKERS] WIP aPatch: Pgbench Serialization and deadlock errors Tatsuo Ishii 00:57
Re: unlogged sequences Robert Haas 01:03
Re: head fails to build on SLES 12 (wal_compression=zstd) Tom Lane 01:10
Re: unlogged sequences David G. Johnston 01:16
Re: Rewriting the test of pg_upgrade as a TAP test - take three - remastered set Michael Paquier 01:16
Re: Use "WAL segment" instead of "log segment" consistently in user-facing messages 📎 Kyotaro Horiguchi 01:31
Re: generic plans and "initial" pruning David Rowley 01:31
Re: Logical replication timeout problem Amit Kapila 02:00
Re: Logical replication timeout problem Euler Taveira 02:03
Re: should vacuum's first heap pass be read-only? Peter Geoghegan 02:05
Re: Logical replication timeout problem Amit Kapila 02:27
Re: unlogged sequences David G. Johnston 02:31
Re: Higher level questions around shared memory stats Kyotaro Horiguchi 02:33
Re: Logical replication timeout problem Euler Taveira 02:57
Re: Higher level questions around shared memory stats David G. Johnston 03:06
Re: generic plans and "initial" pruning Amit Langote 03:09
Re: Rewriting the test of pg_upgrade as a TAP test - take three - remastered set Noah Misch 03:42
Re: generic plans and "initial" pruning Tom Lane 03:45
Re: Unit tests for SLRU Noah Misch 03:47
Re: Rewriting the test of pg_upgrade as a TAP test - take three - remastered set Justin Pryzby 03:51
Re: Rewriting the test of pg_upgrade as a TAP test - take three - remastered set Michael Paquier 03:54
Re: Rewriting the test of pg_upgrade as a TAP test - take three - remastered set Michael Paquier 04:00
Re: should vacuum's first heap pass be read-only? Dilip Kumar 04:08
Re: generic plans and "initial" pruning David Rowley 04:08
Re: Logical replication timeout problem Amit Kapila 04:08
Re: standby recovery fails (tablespace related) (tentative patch and discussion) Kyotaro Horiguchi 04:21
Re: should vacuum's first heap pass be read-only? Peter Geoghegan 04:30
Re: head fails to build on SLES 12 (wal_compression=zstd) Michael Paquier 04:35
Re: proposal: enhancing plpgsql debug API - returns text value of variable content Pavel Stehule 04:51
Re: logical decoding and replication of sequences Masahiko Sawada 04:51
Re: Higher level questions around shared memory stats Andres Freund 05:12
Re: unnecessary (same) restart_lsn handing in LogicalIncreaseRestartDecodingForSlot Amit Kapila 05:24
Re: [HACKERS] WIP aPatch: Pgbench Serialization and deadlock errors Fabien COELHO 05:34
Re: Preventing indirection for IndexPageGetOpaque for known-size page special areas 📎 Michael Paquier 05:38
Re: logical decoding and replication of sequences Amit Kapila 05:41
Re: Error "initial slot snapshot too large" in create replication slot Kyotaro Horiguchi 05:44
Re: psql - add SHOW_ALL_RESULTS option 📎 Fabien COELHO 05:46
Re: BUG #17448: In Windows 10, version 1703 and later, huge_pages doesn't work. Michael Paquier 05:54
Re: Higher level questions around shared memory stats Kyotaro Horiguchi 05:59
Re: BUG #17448: In Windows 10, version 1703 and later, huge_pages doesn't work. Michael Paquier 05:59
Re: Rewriting the test of pg_upgrade as a TAP test - take three - remastered set Michael Paquier 06:01
Re: wrong fds used for refilenodes after pg_upgrade relfilenode changes Reply-To: 📎 Thomas Munro 06:03
Re: BUG #17448: In Windows 10, version 1703 and later, huge_pages doesn't work. Julien Rouhaud 06:19
Re: Error "initial slot snapshot too large" in create replication slot 📎 Kyotaro Horiguchi 06:53
Re: generic plans and "initial" pruning Amit Langote 06:58
Re: generic plans and "initial" pruning Amit Langote 07:01
Re: Handle infinite recursion in logical replication setup 📎 vignesh C 07:04
Re: Handle infinite recursion in logical replication setup vignesh C 07:15
Re: On login trigger: take three a.sokolov 07:16
Re: Skipping logical replication transactions on subscriber side Noah Misch 07:44
Re: Skipping logical replication transactions on subscriber side Masahiko Sawada 08:10
Re: [WIP] ALTER COLUMN IF EXISTS Daniel Gustafsson 08:10
Re: generic plans and "initial" pruning David Rowley 08:19
Re: [Proposal] Fully WAL logged CREATE DATABASE - No Checkpoints 📎 Dilip Kumar 08:21
Re: Tablesync early exit Peter Smith 08:22
Re: TRAP: FailedAssertion("HaveRegisteredOrActiveSnapshot()", File: "toast_internals.c", Line: 670, PID: 19403) Kyotaro Horiguchi 08:28
Re: generic plans and "initial" pruning Amit Langote 08:36
Re: Preventing indirection for IndexPageGetOpaque for known-size page special areas Matthias van de Meent 08:50
Re: Unit tests for SLRU Pavel Borisov 08:58
Re: pg_rewind copies 📎 Daniel Gustafsson 09:00
Re: Use generation context to speed up tuplesorts 📎 David Rowley 09:00
Re: pg_rewind copies Heikki Linnakangas 10:46
Re: pg_rewind copies Daniel Gustafsson 11:46
Re: Rewriting the test of pg_upgrade as a TAP test - take three - remastered set 📎 Michael Paquier 11:53
Is monotonous xid8 is a right way to do? Pavel Borisov 12:13
Re: Skipping logical replication transactions on subscriber side 📎 Masahiko Sawada 12:25
Re: Is monotonous xid8 is a right way to do? Dagfinn Ilmari Mannsåker 12:33
Re: Is monotonous xid8 is a right way to do? Maxim Orlov 12:36
Re: Is monotonous xid8 is a right way to do? Dagfinn Ilmari Mannsåker 12:39
Re: Is monotonous xid8 is a right way to do? Matthias van de Meent 12:43
Re: Is monotonous xid8 is a right way to do? Pavel Borisov 12:53
Re: Correct docs re: rewriting indexes when table rewrite is skipped Robert Haas 12:58
Re: Correct docs re: rewriting indexes when table rewrite is skipped James Coleman 13:01
Re: Use generation context to speed up tuplesorts 📎 Justin Pryzby 13:25
Re: Rewriting the test of pg_upgrade as a TAP test - take three - remastered set Justin Pryzby 13:34
Re: [PATCH] src/interfaces/libpq/Makefile: fix pkg-config without openssl Daniel Gustafsson 13:35
Re: Reword docs of feature "Remove temporary files after backend crash" Daniel Gustafsson 13:42
Re: wrong fds used for refilenodes after pg_upgrade relfilenode changes Reply-To: Robert Haas 13:51
Re: Reword docs of feature "Remove temporary files after backend crash" Robert Haas 13:57
Re: [PATCH] src/interfaces/libpq/Makefile: fix pkg-config without openssl Tom Lane 13:59
Re: [PATCH] Accept IP addresses in server certificate SANs Peter Eisentraut 14:07
Re: psql - add SHOW_ALL_RESULTS option Peter Eisentraut 14:09
Re: Restructure ALTER TABLE notes to clarify table rewrites and verification scans 📎 James Coleman 14:10
Re: Pluggable toaster 📎 Nikita Malakhov 14:11
Re: Use "WAL segment" instead of "log segment" consistently in user-facing messages Nathan Bossart 14:24
Re: Proposal: allow database-specific role memberships Greg Stark 14:32
Re: CREATEROLE and role ownership hierarchies Greg Stark 14:46
Re: Collecting statistics about contents of JSONB columns Greg Stark 14:51
Re: CREATEROLE and role ownership hierarchies Robert Haas 14:56
Re: [Proposal] vacuumdb --schema only Justin Pryzby 15:01
Re: logical decoding and replication of sequences Tomas Vondra 15:02
Re: Add LZ4 compression in pg_dump 📎 gkokolatos 15:06
Re: head fails to build on SLES 12 (wal_compression=zstd) Tom Lane 15:06
Re: Implementing Incremental View Maintenance Greg Stark 15:09
Re: Preventing indirection for IndexPageGetOpaque for known-size page special areas 📎 Matthias van de Meent 15:12
Re: [PATCH] src/interfaces/libpq/Makefile: fix pkg-config without openssl Peter Eisentraut 15:17
Re: Per-table storage parameters for TableAM/IndexAM extensions Greg Stark 15:21
Re: [PATCH] Accept IP addresses in server certificate SANs Jacob Champion 15:24
Re: Removing unneeded self joins Greg Stark 15:27
Re: [PATCH] Tracking statements entry timestamp in pg_stat_statements Greg Stark 15:38
Patches with failing tests in Commitfest Greg Stark 15:42
Re: Temporary tables versus wraparound... again Greg Stark 15:53
Re: Restructure ALTER TABLE notes to clarify table rewrites and verification scans Matthias van de Meent 16:03
Re: Add non-blocking version of PQcancel 📎 Jelte Fennema 16:13
Re: [PATCH] Tracking statements entry timestamp in pg_stat_statements Julien Rouhaud 16:13
Re: unlogged sequences Peter Eisentraut 16:22
Re: unlogged sequences Peter Eisentraut 16:31
Re: unlogged sequences David G. Johnston 16:33
Re: unlogged sequences David G. Johnston 16:36
GSoC: pgmoneta: Write-Ahead Log (WAL) infrastructure (2022) Jinlang Wang 16:39
Re: GSoC: pgmoneta: Write-Ahead Log (WAL) infrastructure (2022) Jesper Pedersen 17:00
Can we automatically add elapsed times to tap test log? Andres Freund 17:21
PostgreSQL shutdown modes 📎 Robert Haas 17:22
Re: unlogged sequences Robert Haas 17:41
Re: Can we automatically add elapsed times to tap test log? Nathan Bossart 17:44
Re: Removing more vacuumlazy.c special cases, relfrozenxid optimizations 📎 Peter Geoghegan 17:54
Re: should vacuum's first heap pass be read-only? Robert Haas 18:04
Re: should vacuum's first heap pass be read-only? Peter Geoghegan 18:26
Re: PostgreSQL shutdown modes Justin Pryzby 18:35
Re: should vacuum's first heap pass be read-only? Robert Haas 18:39
Re: standby recovery fails (tablespace related) (tentative patch and discussion) Robert Haas 18:51
Re: should vacuum's first heap pass be read-only? Peter Geoghegan 19:06
Re: Can we automatically add elapsed times to tap test log? Andrew Dunstan 19:16
Re: Can we automatically add elapsed times to tap test log? Andres Freund 19:29
Re: [PATCH] Tracking statements entry timestamp in pg_stat_statements 📎 Andrei Zubkov 19:47
Re: [PATCH] Tracking statements entry timestamp in pg_stat_statements Andres Freund 20:01
Re: Can we automatically add elapsed times to tap test log? 📎 Andrew Dunstan 20:25
Re: [PATCH] Add extra statistics to explain for Nested Loop 📎 Ekaterina Sokolova 20:46
merge documentation fix Euler Taveira 20:59
Re: wrong fds used for refilenodes after pg_upgrade relfilenode changes Reply-To: Thomas Munro 21:03
use has_privs_of_role() for pg_hba.conf 📎 Nathan Bossart 22:06
Re: PROXY protocol support wilfried roset 22:16
Re: [Proposal] vacuumdb --schema only Nathan Bossart 22:24
Re: Higher level questions around shared memory stats Andres Freund 23:21
Re: pg_walinspect - a new extension to get raw WAL data and WAL stats Jeff Davis 23:35
Re: pg_walinspect - a new extension to get raw WAL data and WAL stats Andres Freund 23:44

April 2, 2022

Thread Author Time
Re: Fix overflow in DecodeInterval 📎 Tom Lane 00:06
Re: Skipping logical replication transactions on subscriber side 📎 Noah Misch 00:11
Re: logical decoding and replication of sequences 📎 Tomas Vondra 00:17
Re: Skipping logical replication transactions on subscriber side 📎 Amit Kapila 01:19
Re: Skipping logical replication transactions on subscriber side 📎 Noah Misch 01:59
Re: PostgreSQL shutdown modes Michael Paquier 02:58
Re: Rewriting the test of pg_upgrade as a TAP test - take three - remastered set Michael Paquier 03:10
Re: Skipping logical replication transactions on subscriber side Amit Kapila 04:08
Re: wrong fds used for refilenodes after pg_upgrade relfilenode changes Reply-To: 📎 Thomas Munro 05:04
Re: A test for replay of regression tests Tom Lane 05:10
JSON constructors and window functions 📎 Jaime Casanova 05:25
Re: PostgreSQL shutdown modes Rushabh Lathia 06:08
Re: Tablesync early exit Amit Kapila 06:17
Re: [PATCH] Tracking statements entry timestamp in pg_stat_statements Julien Rouhaud 07:10
Re: [PATCH] Tracking statements entry timestamp in pg_stat_statements Julien Rouhaud 07:21
Re: [PATCH] Tracking statements entry timestamp in pg_stat_statements Julien Rouhaud 07:24
Re: Skipping logical replication transactions on subscriber side 📎 Masahiko Sawada 07:33
Re: Skipping logical replication transactions on subscriber side 📎 Noah Misch 08:13
Re: shared-memory based stats collector - v66 Andres Freund 08:16
Re: shared-memory based stats collector - v66 Andres Freund 08:21
Re: A qsort template John Naylor 08:38
Re: A qsort template John Naylor 08:50
Re: Skipping logical replication transactions on subscriber side Amit Kapila 10:04
Re: [PATCH] Tracking statements entry timestamp in pg_stat_statements 📎 Andrei Zubkov 10:12
Re: A qsort template Thomas Munro 10:26
Re: logical decoding and replication of sequences Amit Kapila 10:35
Re: logical decoding and replication of sequences Amit Kapila 10:43
Re: A qsort template John Naylor 10:56
Re: [PATCH] Tracking statements entry timestamp in pg_stat_statements Julien Rouhaud 10:56
Re: Can we automatically add elapsed times to tap test log? 📎 Andrew Dunstan 10:57
Re: [PATCH] Tracking statements entry timestamp in pg_stat_statements Andrei Zubkov 11:11
Re: A qsort template John Naylor 11:41
Re: Skipping logical replication transactions on subscriber side Masahiko Sawada 11:44
Re: logical decoding and replication of sequences Tomas Vondra 11:51
Re: logical decoding and replication of sequences Tomas Vondra 11:58
Re: [PATCH] Tracking statements entry timestamp in pg_stat_statements 📎 Andrei Zubkov 12:02
Re: [PATCH] Add extra statistics to explain for Nested Loop 📎 Justin Pryzby 12:38
Re: psql - add SHOW_ALL_RESULTS option Fabien COELHO 13:26
Re: [PATCH] pgbench: add multiconnect option 📎 Fabien COELHO 13:34
Re: PostgreSQL shutdown modes chap 13:39
Re: [PATCH] Add extra statistics to explain for Nested Loop Julien Rouhaud 14:43
Re: support for MERGE Alvaro Herrera 15:02
Re: merge documentation fix Alvaro Herrera 15:19
Re: support for MERGE Andres Freund 16:28

Browse Archives

Prev | Next