pgsql-hackers since 2022-07-27 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

July 27, 2022

Thread	Author	Time
Re: pg15b2: large objects lost on upgrade	Bruce Momjian	01:09
Re: Refactoring postgres_fdw/connection.c	Kyotaro Horiguchi	01:36
Re: Handle infinite recursion in logical replication setup	Amit Kapila	02:53
Re: generic plans and "initial" pruning 📎	Amit Langote	03:00
Re: ExecRTCheckPerms() and many prunable partitions 📎	Amit Langote	03:14
Re: Add proper planner support for ORDER BY / DISTINCT aggregates	Richard Guo	03:16
Re: Refactor to make use of a common function for GetSubscriptionRelations and GetSubscriptionNotReadyRelations. 📎	vignesh C	03:17
Re: Refactor to make use of a common function for GetSubscriptionRelations and GetSubscriptionNotReadyRelations.	vignesh C	03:19
Re: [PoC] Reducing planning time when tables have many partitions	David Rowley	03:31
Re: Perform streaming logical transactions by background workers and parallel apply 📎	Peter Smith	03:37
Re: pgsql: Remove the restriction that the relmap must be 512 bytes.	Michael Paquier	04:34
Re: Perform streaming logical transactions by background workers and parallel apply	Amit Kapila	04:36
Re: [Refactor]Avoid to handle FORCE_NOT_NULL/FORCE_NULL options when COPY TO	Kyotaro Horiguchi	04:55
Re: pgsql: Remove the restriction that the relmap must be 512 bytes.	Thomas Munro	05:01
Re: predefined role(s) for VACUUM and ANALYZE	Kyotaro Horiguchi	05:24
Re: Perform streaming logical transactions by background workers and parallel apply	Dilip Kumar	05:28
Re: Refactoring postgres_fdw/connection.c	Etsuro Fujita	05:30
Re: Custom tuplesorts for extensions	Alexander Korotkov	05:36
Re: Fast COPY FROM based on batch insert	Andrey Lepikhov	05:42
Re: pgsql: Remove the restriction that the relmap must be 512 bytes. 📎	Thomas Munro	06:06
Re: [PoC] Reducing planning time when tables have many partitions	Yuya Watari	06:07
Re: standby recovery fails (tablespace related) (tentative patch and discussion)	Alvaro Herrera	06:07
Re: pgsql: Remove the restriction that the relmap must be 512 bytes. 📎	Thomas Munro	06:21
Re: [Refactor]Avoid to handle FORCE_NOT_NULL/FORCE_NULL options when COPY TO	Richard Guo	06:37
Re: Cygwin cleanup 📎	Justin Pryzby	06:44
Re: Slow standby snapshot	Kyotaro Horiguchi	07:08
Re: Improving btree performance through specializing by key shape, take 2 📎	Matthias van de Meent	07:35
Re: [PATCH] Compression dictionaries for JSONB	Simon Riggs	07:36
Re: making relfilenodes 56 bits	Ashutosh Sharma	07:54
RE: Perform streaming logical transactions by background workers and parallel apply	[email protected]	07:57
Re: PG 15 (and to a smaller degree 14) regression due to ExprEvalStep size 📎	Amit Langote	08:01
Re: Perform streaming logical transactions by background workers and parallel apply	Peter Smith	08:03
Re: making relfilenodes 56 bits	Dilip Kumar	08:11
RE: Perform streaming logical transactions by background workers and parallel apply	[email protected]	08:21
Re: [PATCH] Compression dictionaries for JSONB	Matthias van de Meent	08:30
Re: Non-replayable WAL records through overflows and >MaxAllocSize lengths	Michael Paquier	09:09
[PATCH] Simple code cleanup in tuplesort.c. 📎	Xing Guo	09:09
Re: [PATCH] Simple code cleanup in tuplesort.c.	Richard Guo	09:49
Re: making relfilenodes 56 bits	vignesh C	09:57
RE: Introduce wait_for_subscription_sync for TAP tests	[email protected]	10:08
Re: pgsql: Remove the restriction that the relmap must be 512 bytes.	Michael Paquier	10:25
Re: [PATCH] Reuse Workers and Replication Slots during Logical Replication 📎	Melih Mutlu	10:26
Re: Refactor to make use of a common function for GetSubscriptionRelations and GetSubscriptionNotReadyRelations.	Michael Paquier	10:51
Re: [BUG] Logical replication failure "ERROR: could not map filenode "base/13237/442428" to relation OID" with catalog modifying txns 📎	Amit Kapila	11:33
Re: Improving btree performance through specializing by key shape, take 2 📎	Matthias van de Meent	11:34
Re: Introduce wait_for_subscription_sync for TAP tests	Amit Kapila	11:54
Re: Non-replayable WAL records through overflows and >MaxAllocSize lengths	Matthias van de Meent	12:07
Re: Refactor to make use of a common function for GetSubscriptionRelations and GetSubscriptionNotReadyRelations.	vignesh C	12:15
Re: making relfilenodes 56 bits 📎	Dilip Kumar	12:32
Reducing planning time on tables with many indexes 📎	David Geier	12:37
RE: Perform streaming logical transactions by background workers and parallel apply	[email protected]	12:41
[PoC] Reducing planning time on tables with many indexes 📎	David Geier	12:42
Re: [PoC] Reducing planning time on tables with many indexes	David Geier	12:46
Re: Skip partition tuple routing with constant partition key	Amit Langote	12:50
Re: Trying to add more tests to gistbuild.c 📎	Aleksander Alekseev	13:07
Re: fairywren hung in pg_basebackup tests	Andrew Dunstan	13:47
Re: fairywren hung in pg_basebackup tests	Andrew Dunstan	14:15
Re: fairywren hung in pg_basebackup tests	Alvaro Herrera	14:24
Re: fairywren hung in pg_basebackup tests	Andrew Dunstan	14:32
autoprewarm worker failing to load	Robins Tharakan	14:48
Re: fairywren hung in pg_basebackup tests	Tom Lane	14:58
Re: autoprewarm worker failing to load	Tom Lane	15:16
Re: pgsql: Remove the restriction that the relmap must be 512 bytes.	Robert Haas	15:20
Re: fairywren hung in pg_basebackup tests	Andrew Dunstan	15:21
Re: [Commitfest 2022-07] Patch Triage: Waiting on Author	Robert Haas	15:43
Re: Request for assistance to backport CVE-2022-1552 fixes to 9.6 and 9.4	Roberto C. Sánchez	15:52
Re: making relfilenodes 56 bits 📎	Dilip Kumar	16:19
Re: generic plans and "initial" pruning	Robert Haas	16:27
Re: making relfilenodes 56 bits	Dilip Kumar	16:37
Re: Reducing planning time on tables with many indexes	Tom Lane	16:39
Re: Reducing planning time on tables with many indexes	Tom Lane	17:15
Re: pgsql: Remove the restriction that the relmap must be 512 bytes.	Alvaro Herrera	17:19
Re: pgsql: Remove the restriction that the relmap must be 512 bytes.	Robert Haas	17:38
Re: pgsql: Remove the restriction that the relmap must be 512 bytes.	Tom Lane	17:42
Re: Use -fvisibility=hidden for shared libraries	Tom Lane	18:02
Re: making relfilenodes 56 bits	Robert Haas	18:09
Re: pgsql: Remove the restriction that the relmap must be 512 bytes.	Robert Haas	18:13
Re: Hash index build performance tweak from sorting	Tom Lane	18:22
Re: pgsql: Remove the restriction that the relmap must be 512 bytes.	Robert Haas	18:24
small windows psqlrc re-wording 📎	Robert Treat	18:42
Re: pgsql: Remove the restriction that the relmap must be 512 bytes.	Alvaro Herrera	18:45
Re: standby recovery fails (tablespace related) (tentative patch and discussion) 📎	Alvaro Herrera	18:54
Re: Allow foreign keys to reference a superset of unique columns	Tom Lane	19:11
Re: pgsql: Remove the restriction that the relmap must be 512 bytes.	Tom Lane	19:17
Official Windows Installer and Documentation	David G. Johnston	19:21
Re: Allow pageinspect's bt_page_stats function to return a set of rows instead of a single row	Tom Lane	19:36
Re: pgsql: Remove the restriction that the relmap must be 512 bytes.	Robert Haas	19:39
Re: Schema variables - new implementation for Postgres 15 📎	Pavel Stehule	19:59
Re: pgsql: Remove the restriction that the relmap must be 512 bytes.	Tom Lane	20:05
Re: out of date comment in commit_ts.c 📎	Nathan Bossart	20:29
Re: ExecRTCheckPerms() and many prunable partitions	Tom Lane	21:04
Re: ExecRTCheckPerms() and many prunable partitions	Tom Lane	21:18
Re: [PoC] Reducing planning time when tables have many partitions 📎	David Rowley	21:35
Re: Official Windows Installer and Documentation	Thomas Kellerer	21:36
Re: collect_corrupt_items_vacuum.patch	Robert Haas	21:50
Re: collect_corrupt_items_vacuum.patch	Tom Lane	21:55
Re: [Patch] ALTER SYSTEM READ ONLY	Jacob Champion	22:35
Re: Unprivileged user can induce crash by using an SUSET param in PGOPTIONS	Tom Lane	23:01
Re: Proposal: add a debug message about using geqo	David G. Johnston	23:43

July 28, 2022

Thread	Author	Time
Re: fairywren hung in pg_basebackup tests 📎	Thomas Munro	00:41
Re: Introduce wait_for_subscription_sync for TAP tests 📎	Masahiko Sawada	01:06
Re: Introduce wait_for_subscription_sync for TAP tests	Masahiko Sawada	01:07
Re: Official Windows Installer and Documentation	Julien Rouhaud	01:42
Re: collect_corrupt_items_vacuum.patch	Robert Haas	01:47
Re: [BUG] Logical replication failure "ERROR: could not map filenode "base/13237/442428" to relation OID" with catalog modifying txns	Masahiko Sawada	01:48
Re: BUG #17434: CREATE/DROP DATABASE can be executed in the same transaction with other commands 📎	Yugo NAGATA	01:51
Re: Official Windows Installer and Documentation	David G. Johnston	02:02
Re: Documentation about PL transforms	chap	02:05
RE: [Commitfest 2022-07] Patch Triage: Waiting on Author	[email protected]	02:09
Re: Improve description of XLOG_RUNNING_XACTS 📎	Masahiko Sawada	02:11
Re: fairywren hung in pg_basebackup tests	Thomas Munro	02:12
Re: Official Windows Installer and Documentation	Julien Rouhaud	02:17
Re: Official Windows Installer and Documentation	David G. Johnston	02:31
RE: Support load balancing in libpq	[email protected]	02:50
Re: BUG #17434: CREATE/DROP DATABASE can be executed in the same transaction with other commands	Tom Lane	02:50
Re: Official Windows Installer and Documentation	Tom Lane	02:57
Re: Official Windows Installer and Documentation	Julien Rouhaud	02:58
Re: Skip partition tuple routing with constant partition key 📎	David Rowley	02:59
Re: [BUG] Logical replication failure "ERROR: could not map filenode "base/13237/442428" to relation OID" with catalog modifying txns	Amit Kapila	03:21
Re: Official Windows Installer and Documentation	Tom Lane	03:22
Re: [Patch] ALTER SYSTEM READ ONLY	Amul Sul	03:45
RE: Support logical replication of DDLs 📎	[email protected]	03:48
Re: Improve description of XLOG_RUNNING_XACTS	Ashutosh Bapat	04:26
Re: Official Windows Installer and Documentation	David G. Johnston	04:28
RE: Perform streaming logical transactions by background workers and parallel apply	[email protected]	05:20
Re: Documentation about PL transforms	Pavel Stehule	05:51
Re: Handle infinite recursion in logical replication setup	Peter Smith	05:58
Re: Fix annotations nextFullXid	Fujii Masao	06:00
How to get accurate backup end time when it is taken from synchronous standby ?	Harinath Kanchu	06:20
Re: Improve description of XLOG_RUNNING_XACTS	Kyotaro Horiguchi	06:24
Re: [BUG] Logical replication failure "ERROR: could not map filenode "base/13237/442428" to relation OID" with catalog modifying txns	Masahiko Sawada	06:25
Re: Refactoring postgres_fdw/connection.c	Fujii Masao	06:26
Re: Improve description of XLOG_RUNNING_XACTS	Masahiko Sawada	06:53
Re: LogwrtResult contended spinlock 📎	Alvaro Herrera	06:59
Re: [BUG] Logical replication failure "ERROR: could not map filenode "base/13237/442428" to relation OID" with catalog modifying txns	Amit Kapila	07:13
Re: [BUG] Logical replication failure "ERROR: could not map filenode "base/13237/442428" to relation OID" with catalog modifying txns	Masahiko Sawada	07:26
Re: Refactoring postgres_fdw/connection.c	Kyotaro Horiguchi	07:27
Re: Improve description of XLOG_RUNNING_XACTS	Kyotaro Horiguchi	07:29
Re: Skip partition tuple routing with constant partition key	Amit Langote	07:37
Any way to get timestamp from LSN value ?	Harinath Kanchu	07:47
Re: [BUG] Panic due to incorrect missingContrecPtr after promotion	[email protected]	08:02
[PATCH] BUG FIX: redo will abort, due to inconsistent page found in BRIN_REGULAR_PAGE 📎	王海洋	08:10
RE: Skip partition tuple routing with constant partition key	[email protected]	08:40
Re: [BUG] Logical replication failure "ERROR: could not map filenode "base/13237/442428" to relation OID" with catalog modifying txns	Amit Kapila	08:57
Re: Data is copied twice when specifying both child and parent table in publication	Peter Smith	09:17
Re: Checking pgwin32_is_junction() errors 📎	Thomas Munro	09:31
Re: Report checkpoint progress with pg_stat_progress_checkpoint (was: Report checkpoint progress in server logs)	Nitin Jadhav	09:38
Re: [BUG] Logical replication failure "ERROR: could not map filenode "base/13237/442428" to relation OID" with catalog modifying txns 📎	Amit Kapila	09:53
ci: update to freebsd 13.1 / remove minor versions from image names	Andres Freund	09:57
Re: Handle infinite recursion in logical replication setup	vignesh C	10:45
Re: making relfilenodes 56 bits 📎	Dilip Kumar	11:31
Re: [Commitfest 2022-07] Patch Triage: Waiting on Author	Andrey Borodin	11:46
Re: [BUG] Logical replication failure "ERROR: could not map filenode "base/13237/442428" to relation OID" with catalog modifying txns	Amit Kapila	11:57
Re: Hash index build performance tweak from sorting 📎	Simon Riggs	12:47
Re: [Refactor]Avoid to handle FORCE_NOT_NULL/FORCE_NULL options when COPY TO 📎	Zhang Mingli	13:04
Re: Perform streaming logical transactions by background workers and parallel apply	Amit Kapila	13:32
Maximize page freezing 📎	Simon Riggs	13:35
Re: small windows psqlrc re-wording	Julien Rouhaud	13:45
Re: Maximize page freezing	Matthias van de Meent	13:55
Re: [PATCH] Reuse Workers and Replication Slots during Logical Replication	Amit Kapila	14:01
Re: Patch to address creation of PgStat* contexts with null parent context	Zhang Mingli	14:03
Re: Handle infinite recursion in logical replication setup 📎	vignesh C	14:03
Re: small windows psqlrc re-wording	Tom Lane	14:04
Re: COPY FROM FORMAT CSV FORCE_NULL(*) ?	Zhang Mingli	14:09
Re: Mingw task for Cirrus CI 📎	Melih Mutlu	14:11
Re: replacing role-level NOINHERIT with a grant-level option	tushar	14:15
Re: small windows psqlrc re-wording	Julien Rouhaud	14:19
Re: Any way to get timestamp from LSN value ?	Bharath Rupireddy	14:23
How come drongo didn't fail authentication here?	Tom Lane	14:24
Re: small windows psqlrc re-wording	Tom Lane	14:28
Re: making relfilenodes 56 bits	Robert Haas	14:29
Re: replacing role-level NOINHERIT with a grant-level option	Robert Haas	14:33
Re: How come drongo didn't fail authentication here?	Andrew Dunstan	14:36
Re: How come drongo didn't fail authentication here?	Tom Lane	14:55
Re: How to get accurate backup end time when it is taken from synchronous standby ?	Bharath Rupireddy	14:55
Re: make update-po@master stops at pg_upgrade	Alvaro Herrera	15:23
Re: How come drongo didn't fail authentication here?	Andrew Dunstan	15:29
Re: make update-po@master stops at pg_upgrade	Tom Lane	15:39
Re: Parallel Inserts (WAS: [bug?] Missed parallel safety checks..)	Jacob Champion	15:51
Re: [Commitfest 2022-07] Patch Triage: Waiting on Author	Jacob Champion	15:52
Re: [Commitfest 2022-07] Patch Triage: Waiting on Author	Jacob Champion	15:58
Re: making relfilenodes 56 bits	Alvaro Herrera	15:59
Re: [PATCH] Reuse Workers and Replication Slots during Logical Replication	Melih Mutlu	16:02
Re: BUG #17434: CREATE/DROP DATABASE can be executed in the same transaction with other commands	David G. Johnston	16:13
Re: [PATCH] Log details for client certificate failures	Jacob Champion	16:19
Re: Support for grabbing multiple consecutive values with nextval()	Tom Lane	16:20
Re: doc phrase: "inheritance child"	Alvaro Herrera	16:30
Re: replacing role-level NOINHERIT with a grant-level option	tushar	16:32
Re: Support for grabbing multiple consecutive values with nextval()	Tom Lane	16:47
Re: making relfilenodes 56 bits	Robert Haas	16:52
Re: making relfilenodes 56 bits	Joshua Drake	17:24
Re: ci: update to freebsd 13.1 / remove minor versions from image names	Matthias van de Meent	17:29
Re: ci: update to freebsd 13.1 / remove minor versions from image names	Andres Freund	17:31
Re: ci: update to freebsd 13.1 / remove minor versions from image names	Matthias van de Meent	17:45
Re: standby recovery fails (tablespace related) (tentative patch and discussion)	Matthias van de Meent	18:04
Re: Add proper planner support for ORDER BY / DISTINCT aggregates	David Rowley	18:49
Re: Hash index build performance tweak from sorting	Tom Lane	18:50
Re: pg_auth_members.grantor is bunk 📎	Robert Haas	19:09
Re: Maximize page freezing	Peter Geoghegan	19:57
Re: PROXY protocol support	Jacob Champion	20:05

Browse Archives

Prev | Next