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

Thread	Author	Time
Re: Add proper planner support for ORDER BY / DISTINCT aggregates	Zhihong Yu	00:07
Re: Remove useless arguments in ReadCheckpointRecord().	Kyotaro Horiguchi	00:42
Re: log_line_prefix: make it possible to add the search_path	Lukas Fittl	01:08
Re: Make name optional in CREATE STATISTICS	Michael Paquier	01:19
Re: [BUG] Logical replication failure "ERROR: could not map filenode "base/13237/442428" to relation OID" with catalog modifying txns	Masahiko Sawada	01:29
Introduce wait_for_subscription_sync for TAP tests 📎	Masahiko Sawada	01:36
Re: Handle infinite recursion in logical replication setup	Jonathan S. Katz	01:43
Re: Handle infinite recursion in logical replication setup	Peter Smith	01:45
Re: predefined role(s) for VACUUM and ANALYZE	Kyotaro Horiguchi	01:47
Re: optimize lookups in snapshot [sub]xip arrays	Zhang Mingli	01:50
Re: predefined role(s) for VACUUM and ANALYZE	Kyotaro Horiguchi	01:58
Re: Remove useless arguments in ReadCheckpointRecord().	Fujii Masao	02:02
Re: Fix annotations nextFullXid	Fujii Masao	02:08
Re: Handle infinite recursion in logical replication setup	Peter Smith	02:18
Re: Is it correct to say, "invalid data in file \"%s\"", BACKUP_LABEL_FILE in do_pg_backup_stop?	Kyotaro Horiguchi	02:49
Re: Handle infinite recursion in logical replication setup	Amit Kapila	03:37
Re: Handle infinite recursion in logical replication setup	Amit Kapila	03:42
Re: Implementing Incremental View Maintenance	huyajun	04:00
Re: Handle infinite recursion in logical replication setup	Amit Kapila	04:09
Cygwin cleanup 📎	Thomas Munro	04:24
Re: Cygwin cleanup	Tom Lane	04:34
Re: making relfilenodes 56 bits	Amul Sul	04:35
Re: Handle infinite recursion in logical replication setup	Peter Smith	04:53
Re: fairywren hung in pg_basebackup tests	Noah Misch	04:53
Re: Introduce wait_for_subscription_sync for TAP tests	Amit Kapila	05:01
Re: Allow file inclusion in pg_hba and pg_ident files 📎	Julien Rouhaud	05:04
Re: Allow file inclusion in pg_hba and pg_ident files	Michael Paquier	05:14
Re: Cygwin cleanup	Thomas Munro	05:16
Re: [BUG] Logical replication failure "ERROR: could not map filenode "base/13237/442428" to relation OID" with catalog modifying txns	Amit Kapila	05:18
Re: making relfilenodes 56 bits	Dilip Kumar	05:57
Re: making relfilenodes 56 bits	Dilip Kumar	05:59
Re: making relfilenodes 56 bits	Dilip Kumar	06:07
Re: making relfilenodes 56 bits	Dilip Kumar	06:09
Re: explain analyze rows=%.0f	Hamid Akhtar	06:46
Re: Non-replayable WAL records through overflows and >MaxAllocSize lengths	Michael Paquier	07:20
Re: Refactoring postgres_fdw/connection.c	Kyotaro Horiguchi	07:25
Re: remove more archiving overhead	Fujii Masao	07:26
Re: Add proper planner support for ORDER BY / DISTINCT aggregates	Richard Guo	07:39
Re: Introduce wait_for_subscription_sync for TAP tests 📎	Masahiko Sawada	07:41
SI-read predicate locks on materialized views 📎	Yugo NAGATA	07:44
Re: [BUG] Logical replication failure "ERROR: could not map filenode "base/13237/442428" to relation OID" with catalog modifying txns 📎	Masahiko Sawada	07:51
Re: making relfilenodes 56 bits 📎	Dilip Kumar	08:01
RE: Handle infinite recursion in logical replication setup	[email protected]	08:05
Re: Make name optional in CREATE STATISTICS	Alvaro Herrera	08:17
Re: make -C libpq check fails obscurely if tap tests are disabled 📎	Alvaro Herrera	08:21
Re: Pluggable toaster	Aleksander Alekseev	08:22
RE: Handle infinite recursion in logical replication setup 📎	[email protected]	08:42
Re: Perform streaming logical transactions by background workers and parallel apply	Dilip Kumar	09:00
RE: [BUG] Logical replication failure "ERROR: could not map filenode "base/13237/442428" to relation OID" with catalog modifying txns	[email protected]	09:24
Re: Refactoring postgres_fdw/connection.c	Fujii Masao	09:33
Re: Perform streaming logical transactions by background workers and parallel apply	Dilip Kumar	09:33
Max compact as an FSM strategy 📎	Simon Riggs	09:34
回复：Re: PANIC: wrong buffer passed to visibilitymap_clear 📎	王伟 (学弈)	09:51
Re: Perform streaming logical transactions by background workers and parallel apply	Peter Smith	09:56
Re: SI-read predicate locks on materialized views	Richard Guo	10:00
Re: Max compact as an FSM strategy	Dilip Kumar	10:02
Re: Add WAL recovery messages with log_wal_traffic GUC (was: add recovery, backup, archive, streaming etc. activity messages to server logs along with ps display) 📎	Bharath Rupireddy	10:06
Re: Fast COPY FROM based on batch insert	Etsuro Fujita	10:19
Re: Refactoring postgres_fdw/connection.c	Etsuro Fujita	10:26
Re: Refactoring postgres_fdw/connection.c	Fujii Masao	10:46
Re: Max compact as an FSM strategy	Simon Riggs	10:50
Re: Race between KeepFileRestoredFromArchive() and restartpoint	David Steele	11:21
Re: make -C libpq check fails obscurely if tap tests are disabled	Andres Freund	11:28
Re: Cygwin cleanup	Tom Lane	11:40
Re: Is it correct to say, "invalid data in file \"%s\"", BACKUP_LABEL_FILE in do_pg_backup_stop?	David Steele	11:52
Re: Allow parallel plan for referential integrity checks?	Frédéric Yhuel	11:58
Re: Is it correct to say, "invalid data in file \"%s\"", BACKUP_LABEL_FILE in do_pg_backup_stop?	Bharath Rupireddy	11:59
Re: Proposal to provide the facility to set binary format output for specific OID's per session 📎	Dave Cramer	12:11
Re: Is it correct to say, "invalid data in file \"%s\"", BACKUP_LABEL_FILE in do_pg_backup_stop?	David Steele	12:20
Re: making relfilenodes 56 bits	Ashutosh Sharma	12:35
Re: log_line_prefix: make it possible to add the search_path 📎	Pierre	12:41
RE: Collect ObjectAddress for ATTACH DETACH PARTITION to use in event trigger 📎	[email protected]	13:00
Re: Restructure ALTER TABLE notes to clarify table rewrites and verification scans	Justin Pryzby	13:08
Re: making relfilenodes 56 bits	Dilip Kumar	14:02
Re: doc: Clarify Savepoint Behavior	David G. Johnston	15:07
Re: BUG #17434: CREATE/DROP DATABASE can be executed in the same transaction with other commands 📎	Tom Lane	15:08
Re: BUG #17434: CREATE/DROP DATABASE can be executed in the same transaction with other commands	David G. Johnston	15:22
Re: BUG #17434: CREATE/DROP DATABASE can be executed in the same transaction with other commands	Tom Lane	15:37
Re: make -C libpq check fails obscurely if tap tests are disabled	Alvaro Herrera	15:40
Re: BUG #17434: CREATE/DROP DATABASE can be executed in the same transaction with other commands	David G. Johnston	15:48
Re: Unprivileged user can induce crash by using an SUSET param in PGOPTIONS	Dagfinn Ilmari Mannsåker	16:02
Re: BUG #17434: CREATE/DROP DATABASE can be executed in the same transaction with other commands	Tom Lane	16:03
Re: Unprivileged user can induce crash by using an SUSET param in PGOPTIONS	Tom Lane	16:04
Re: BUG #17434: CREATE/DROP DATABASE can be executed in the same transaction with other commands	David G. Johnston	16:11
Re: BUG #17434: CREATE/DROP DATABASE can be executed in the same transaction with other commands	Tom Lane	16:14
[Refactor]Avoid to handle FORCE_NOT_NULL/FORCE_NULL options when COPY TO	Zhang Mingli	16:16
Re: remove more archiving overhead	Nathan Bossart	16:22
Re: Fix annotations nextFullXid	Zhang Mingli	16:29
Re: failures in t/031_recovery_conflict.pl on CI	Alvaro Herrera	16:33
Re: pg_auth_members.grantor is bunk 📎	Robert Haas	16:46
Re: failures in t/031_recovery_conflict.pl on CI	Tom Lane	16:47
Re: Non-replayable WAL records through overflows and >MaxAllocSize lengths 📎	Matthias van de Meent	16:58
Re: making relfilenodes 56 bits	Ashutosh Sharma	17:06
Re: Cygwin cleanup	Robert Haas	17:08
Re: Password reset link / 'less' does not exit in psql version 13.4	Justin Pryzby	17:20
out of date comment in commit_ts.c	Nathan Bossart	17:33
Re: predefined role(s) for VACUUM and ANALYZE	Robert Haas	17:37
Re: failures in t/031_recovery_conflict.pl on CI	Andres Freund	17:40
Re: [Proposal] Page Compression for OLTP 📎	chenhj	17:47
Re: predefined role(s) for VACUUM and ANALYZE	David G. Johnston	17:50
Re: Transparent column encryption	Robert Haas	17:51
Re: predefined role(s) for VACUUM and ANALYZE	Robert Haas	17:54
Re: Handle infinite recursion in logical replication setup 📎	vignesh C	17:57
Re: Unstable tests for recovery conflict handling	Tom Lane	17:57
Re: Handle infinite recursion in logical replication setup	vignesh C	18:04
Re: Handle infinite recursion in logical replication setup	vignesh C	18:07
Re: Handle infinite recursion in logical replication setup	vignesh C	18:08
Re: Slow standby snapshot	Andrey Borodin	18:09
Re: Handle infinite recursion in logical replication setup	vignesh C	18:13
Re: Unstable tests for recovery conflict handling	Andres Freund	18:16
Re: optimize lookups in snapshot [sub]xip arrays	Andres Freund	18:19
Re: Transparent column encryption	Jacob Champion	18:26
Re: Unstable tests for recovery conflict handling	Tom Lane	18:30
Re: XID formatting and SLRU refactorings (was: Add 64-bit XIDs into PostgreSQL 15)	Simon Riggs	18:35
Re: making relfilenodes 56 bits	Robert Haas	18:37
Re: let's disallow ALTER ROLE bootstrap_superuser NOSUPERUSER	Robert Haas	18:40
Re: let's disallow ALTER ROLE bootstrap_superuser NOSUPERUSER	Tom Lane	18:59
Re: let's disallow ALTER ROLE bootstrap_superuser NOSUPERUSER	Robert Haas	19:06
pgsql: Remove the restriction that the relmap must be 512 bytes.	Robert Haas	19:10
Re: making relfilenodes 56 bits	Robert Haas	19:19
[Commitfest 2022-07] Patch Triage: Waiting on Author	Jacob Champion	19:26
Re: pg15b2: large objects lost on upgrade	Robert Haas	19:45
Re: Postgres do not allow to create many tables with more than 63-symbols prefix	Tom Lane	19:47
Re: Unstable tests for recovery conflict handling	Andres Freund	20:03
Re: Transparent column encryption	Robert Haas	20:25
Question about ExplainOneQuery_hook	Zhihong Yu	21:00
Re: Expand palloc/pg_malloc API	Tom Lane	21:32
Re: Skip partition tuple routing with constant partition key 📎	David Rowley	22:27
Re: fairywren hung in pg_basebackup tests	Thomas Munro	22:31
Re: Add proper planner support for ORDER BY / DISTINCT aggregates	David Rowley	22:37
Re: explain_regress, explain(MACHINE), and default to explain(BUFFERS) (was: BUFFERS enabled by default in EXPLAIN (ANALYZE))	David G. Johnston	22:38
Re: Add proper planner support for ORDER BY / DISTINCT aggregates	David Rowley	22:45
Re: Question about ExplainOneQuery_hook	David G. Johnston	22:58
Re: Is RecoveryConflictInterrupt() entirely safe in a signal handler?	Thomas Munro	23:15
Re: Transparent column encryption	Jacob Champion	23:19
Re: [Commitfest 2022-07] Patch Triage: Waiting on Author	Justin Pryzby	23:20
Re: Skip partition tuple routing with constant partition key	Zhihong Yu	23:22
Re: Is RecoveryConflictInterrupt() entirely safe in a signal handler?	Tom Lane	23:22
Re: [Commitfest 2022-07] Patch Triage: Waiting on Author	Jacob Champion	23:30
Re: [Commitfest 2022-07] Patch Triage: Waiting on Author	James Coleman	23:47
Re: Expand palloc/pg_malloc API	David G. Johnston	23:58

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

Browse Archives

Prev | Next