pgsql-hackers since 2022-08-02 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

Aug. 2, 2022

Thread	Author	Time
Re: [PATCH] postgresql.conf.sample comment alignment.	Tom Lane	00:03
Re: Cleaning up historical portability baggage 📎	Thomas Munro	00:18
Re: [PATCH] postgresql.conf.sample comment alignment.	Peter Smith	00:28
Re: PG 15 (and to a smaller degree 14) regression due to ExprEvalStep size	Andres Freund	00:39
Re: pg_buffercache: add sql test	Dong Wook Lee	00:50
Re: Avoid unecessary MemSet call (src/backend/utils/cache/relcache.c)	Peter Smith	01:19
pgstattuple: add test for coverage 📎	Dong Wook Lee	01:36
Re: enable/disable broken for statement triggers on partitioned tables	Amit Langote	01:43
Re: Handle infinite recursion in logical replication setup	Peter Smith	02:01
Re: add test: pg_rowlocks extension	Dong Wook Lee	02:32
Missing CFI in iterate_word_similarity() 📎	Robins Tharakan	02:41
Re: PG 15 (and to a smaller degree 14) regression due to ExprEvalStep size	Amit Langote	03:05
Re: Typo in pg_db_role_setting.h	Richard Guo	03:06
RE: Support logical replication of DDLs 📎	[email protected]	03:20
Re: Typo in pg_db_role_setting.h	John Naylor	04:13
Re: allow building trusted languages without the untrusted versions	Nathan Bossart	04:29
COPY TO (FREEZE)? 📎	Kyotaro Horiguchi	04:30
Re: [Refactor]Avoid to handle FORCE_NOT_NULL/FORCE_NULL options when COPY TO	Kyotaro Horiguchi	04:30
Re: Typo in pg_db_role_setting.h	Japin Li	04:34
Re: Typo in pg_db_role_setting.h	John Naylor	04:43
Re: Question about user/database-level parameters	Kyotaro Horiguchi	05:01
Re: remove more archiving overhead 📎	Nathan Bossart	05:02
Re: fix typos	John Naylor	05:28
Re: Question about user/database-level parameters	Japin Li	05:33
Re: Question about user/database-level parameters	Tom Lane	05:44
Re: pgstattuple: add test for coverage	Tom Lane	05:47
Re: fix typos	John Naylor	05:52
Re: Question about user/database-level parameters	Japin Li	05:59
Re: Pluggable toaster 📎	Nikita Malakhov	06:15
Re: COPY TO (FREEZE)?	Julien Rouhaud	06:17
Re: Progress report removal of temp files and temp relation files using ereport_startup_progress 📎	Bharath Rupireddy	06:22
Re: [BUG] Logical replication failure "ERROR: could not map filenode "base/13237/442428" to relation OID" with catalog modifying txns	Kyotaro Horiguchi	06:30
Re: [Commitfest 2022-07] is Done!	Alvaro Herrera	06:44
Re: Using each rel as both outer and inner for JOIN_ANTI	Richard Guo	07:13
Re: Skip partition tuple routing with constant partition key	Amit Langote	07:19
Generalize ereport_startup_progress infrastructure 📎	Bharath Rupireddy	07:25
Re: Typo in pg_db_role_setting.h	Richard Guo	07:37
Re: Strange behavior with polygon and NaN	Kyotaro Horiguchi	07:44
Re: Typo in pg_db_role_setting.h	Daniel Gustafsson	07:45
Re: Typo in pg_db_role_setting.h	Japin Li	07:58
Re: [Refactor]Avoid to handle FORCE_NOT_NULL/FORCE_NULL options when COPY TO 📎	Zhang Mingli	08:13
Re: COPY TO (FREEZE)?	Kyotaro Horiguchi	08:17
Re: COPY TO (FREEZE)?	Zhang Mingli	08:20
Re: [BUG] Logical replication failure "ERROR: could not map filenode "base/13237/442428" to relation OID" with catalog modifying txns	Amit Kapila	08:24
RE: [BUG] Logical replication failure "ERROR: could not map filenode "base/13237/442428" to relation OID" with catalog modifying txns	[email protected]	08:31
Re: fix typos	Erik Rijkers	08:32
Re: Column Filtering in Logical Replication	Amit Kapila	08:57
Fix obsoleted comments for function prototypes 📎	Richard Guo	09:06
RE: Handle infinite recursion in logical replication setup	[email protected]	09:31
Re: POC: GROUP BY optimization	Michael Paquier	10:21
support for SSE2 intrinsics	John Naylor	10:22
Re: Fix obsoleted comments for function prototypes	Michael Paquier	10:25
Re: [PATCH] Fix pg_upgrade test from v10	Michael Paquier	10:28
Re: Allow file inclusion in pg_hba and pg_ident files	Michael Paquier	10:32
Re: Slow standby snapshot	Simon Riggs	10:47
Re: PostgreSQL 15 minor fixes in protocol.sgml	Michael Paquier	10:58
Re: POC: GROUP BY optimization	David Rowley	11:14
Re: Add proper planner support for ORDER BY / DISTINCT aggregates	David Rowley	11:21
Re: remove more archiving overhead	David Steele	11:23
[PATCH] Add a inline function to eliminate duplicate code 📎	Junwang Zhao	11:27
Re: Slow standby snapshot	Andrey Borodin	11:32
RE: Perform streaming logical transactions by background workers and parallel apply 📎	[email protected]	11:46
Re: Avoid unecessary MemSet call (src/backend/utils/cache/relcache.c)	Ranier Vilela	11:55
Re: Handle infinite recursion in logical replication setup	Amit Kapila	11:59
Re: add test: pg_rowlocks extension 📎	Dong Wook Lee	12:03
Re: Perform streaming logical transactions by background workers and parallel apply	Amit Kapila	12:05
Re: Typo in "43.9.1. Reporting Errors and Messages"?	Euler Taveira	12:49
Re: Avoid unecessary MemSet call (src/backend/utils/cache/relcache.c)	mahendrakar s	13:17
Re: Add proper planner support for ORDER BY / DISTINCT aggregates	Tom Lane	13:19
Re: Patch proposal: New hooks in the connection path	Drouvot, Bertrand	13:23
Re: [PATCH] Add a inline function to eliminate duplicate code	mahendrakar s	13:23
Re: Race between KeepFileRestoredFromArchive() and restartpoint	David Steele	14:14
Re: Avoid unecessary MemSet call (src/backend/utils/cache/relcache.c)	Ranier Vilela	14:18
Re: Race between KeepFileRestoredFromArchive() and restartpoint	Noah Misch	14:37
Why is DEFAULT_FDW_TUPLE_COST so insanely low? 📎	David Rowley	14:56
Re: Add proper planner support for ORDER BY / DISTINCT aggregates	David Rowley	14:59
Re: PG 15 (and to a smaller degree 14) regression due to ExprEvalStep size	Andres Freund	15:00
Re: Race between KeepFileRestoredFromArchive() and restartpoint	David Steele	15:01
Re: Slow standby snapshot 📎	Simon Riggs	15:18
Re: Pluggable toaster	Andres Freund	15:37
Cutting test runtime for src/test/modules/snapshot_too_old 📎	Tom Lane	15:38
Re: support for SSE2 intrinsics	Nathan Bossart	16:53
Re: pg15b2: large objects lost on upgrade	Tom Lane	17:12
Re: Cutting test runtime for src/test/modules/snapshot_too_old	Robert Haas	17:28
Re: pg_auth_members.grantor is bunk	Jacob Champion	17:48
Re: [Proposal] Fully WAL logged CREATE DATABASE - No Checkpoints	Justin Pryzby	17:50
Re: Cutting test runtime for src/test/modules/snapshot_too_old	Tom Lane	17:50
Re: [PATCH] Add sortsupport for range types and btree_gist	Jacob Champion	18:01
Re: Add proper planner support for ORDER BY / DISTINCT aggregates 📎	Zhihong Yu	18:02
Re: Add index scan progress to pg_stat_progress_vacuum	Jacob Champion	18:06
Re: [PROPOSAL] Detecting plan changes with plan_id in pg_stat_activity	Jacob Champion	18:11
Re: Parse CE and BCE in dates and times	Jacob Champion	18:13
Re: Restructure ALTER TABLE notes to clarify table rewrites and verification scans	Jacob Champion	18:17
Re: Finer grain log timestamps	Jacob Champion	18:27
Re: Generalize ereport_startup_progress infrastructure	Robert Haas	18:40
Re: Add LZ4 compression in pg_dump	Jacob Champion	18:42
Re: TAP output format in pg_regress	Jacob Champion	18:44
Re: Add last commit LSN to pg_last_committed_xact()	Jacob Champion	18:50
Re: WaitLatchOrSocket seems to not count to 4 right...	Jacob Champion	18:52
Re: Avoiding smgrimmedsync() during nbtree index builds	Jacob Champion	18:54
Re: speed up a logical replica setup	Jacob Champion	18:56
Re: [WIP] Allow pg_upgrade to copy segments of the same relfilenode in parallel	Jacob Champion	18:58
Re: Speed up transaction completion faster after many relations are accessed in a transaction	Jacob Champion	19:04
Re: pg15b2: large objects lost on upgrade	Jonathan S. Katz	19:19
Re: pg15b2: large objects lost on upgrade	Robert Haas	19:23
Re: pg15b2: large objects lost on upgrade	Jonathan S. Katz	19:27
Re: pg15b2: large objects lost on upgrade	Tom Lane	19:32
Re: Add proper planner support for ORDER BY / DISTINCT aggregates 📎	Zhihong Yu	19:38
Re: pg15b2: large objects lost on upgrade	Tom Lane	19:39
Re: pg15b2: large objects lost on upgrade	Jonathan S. Katz	19:44
Re: pg15b2: large objects lost on upgrade	Tom Lane	19:51
Re: standby recovery fails (tablespace related) (tentative patch and discussion)	Thomas Munro	19:58
Re: pg15b2: large objects lost on upgrade	Jonathan S. Katz	20:20
Re: oat_post_create expected behavior	Mary Xu	20:30
Re: pg15b2: large objects lost on upgrade 📎	Jonathan S. Katz	20:44
Re: libpq compression (part 2)	Jacob Champion	20:53
Re: Per-table storage parameters for TableAM/IndexAM extensions	Jacob Champion	20:56
Re: Parallelize correlated subqueries that execute within each worker	Jacob Champion	20:57
Re: Push down time-related SQLValue functions to foreign server	Jacob Champion	20:59
Re: [PATCH] Allow multiple recursive self-references	Jacob Champion	21:01
Re: Patch to avoid orphaned dependencies	Jacob Champion	21:03
Re: Race between KeepFileRestoredFromArchive() and restartpoint	Don Seiler	21:03
Re: Consider parallel for lateral subqueries with limit	Jacob Champion	21:05
Re: jsonpath syntax extensions	Jacob Champion	21:14
Re: [Proposal] Fully WAL logged CREATE DATABASE - No Checkpoints	Robert Haas	21:18
Re: [PATCH] minor reloption regression tests improvement	Jacob Champion	21:26
Re: [Proposal] Fully WAL logged CREATE DATABASE - No Checkpoints	Tom Lane	21:46
Re: Proposal: Support custom authentication methods using hooks	Jacob Champion	21:48
Re: Add proper planner support for ORDER BY / DISTINCT aggregates	David Rowley	21:48
Re: [PATCH] Expose port->authn_id to extensions and triggers	Jacob Champion	21:57
Re: [Proposal] Fully WAL logged CREATE DATABASE - No Checkpoints	Justin Pryzby	22:04
Re: Proposal: Support custom authentication methods using hooks	samay sharma	22:05
Re: [PROPOSAL] new diagnostic items for the dynamic sql	Jacob Champion	22:09
Re: optimize lookups in snapshot [sub]xip arrays 📎	Nathan Bossart	22:13
Re: [PROPOSAL] new diagnostic items for the dynamic sql	Jacob Champion	22:13
Re: [Proposal] Fully WAL logged CREATE DATABASE - No Checkpoints	Andres Freund	22:23
Re: [Commitfest 2022-07] is Done!	Jacob Champion	22:31
Re: Column Filtering in Logical Replication	Peter Smith	22:42
Re: [Commitfest 2022-07] is Done!	Justin Pryzby	22:53
[PATCH] CF app: add "Returned: Needs more interest" 📎	Jacob Champion	22:55
Re: optimize lookups in snapshot [sub]xip arrays	Andres Freund	22:55
Re: [PROPOSAL] new diagnostic items for the dynamic sql	Tom Lane	22:55
Re: missing indexes in indexlist with partitioned tables 📎	Arne Roland	23:07
effective_multixact_freeze_max_age issue 📎	Peter Geoghegan	23:12
Re: optimize lookups in snapshot [sub]xip arrays	Nathan Bossart	23:43
Re: Parallel Aggregates for string_agg and array_agg 📎	David Rowley	23:45
Re: Adding Support for Copy callback functionality on COPY TO api 📎	Nathan Bossart	23:49
collate not support Unicode Variation Selector	荒井元成	23:54

Aug. 3, 2022

Thread	Author	Time
RE: collate not support Unicode Variation Selector	荒井元成	00:09
Re: Parallel Aggregates for string_agg and array_agg	Tom Lane	00:18
Re: collate not support Unicode Variation Selector	Thomas Munro	00:41
Re: collate not support Unicode Variation Selector	Tom Lane	00:56
Re: Slow standby snapshot	Kyotaro Horiguchi	01:04
Re: [BUG] Logical replication failure "ERROR: could not map filenode "base/13237/442428" to relation OID" with catalog modifying txns	Kyotaro Horiguchi	01:20
Re: [Commitfest 2022-07] is Done!	Julien Rouhaud	01:30
Re: [BUG] Logical replication failure "ERROR: could not map filenode "base/13237/442428" to relation OID" with catalog modifying txns	Masahiko Sawada	01:35
Re: Parallel Aggregates for string_agg and array_agg	David Rowley	01:42
Does having pg_last_wal_replay_lsn[replica] >= pg_current_wal_insert_lsn[master] guarantee that the replica is caught up?	Dmitry Koterov	01:57
Re: collate not support Unicode Variation Selector	Thomas Munro	02:02
Re: pgstattuple: add test for coverage 📎	Dong Wook Lee	02:19
Re: Race between KeepFileRestoredFromArchive() and restartpoint	Kyotaro Horiguchi	02:24
Re: Cleaning up historical portability baggage 📎	Thomas Munro	02:25
Re: Parallel Aggregates for string_agg and array_agg	Zhihong Yu	02:46
Re: [PATCH] CF app: add "Returned: Needs more interest"	Julien Rouhaud	03:00
Re: Parallel Aggregates for string_agg and array_agg	David Rowley	03:05
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: Speed up transaction completion faster after many relations are accessed in a transaction 📎	David Rowley	03:33
Re: PostgreSQL 15 minor fixes in protocol.sgml	Amit Kapila	03:57
Re: [BUG] Logical replication failure "ERROR: could not map filenode "base/13237/442428" to relation OID" with catalog modifying txns 📎	Masahiko Sawada	04:05
Re: [BUG] Logical replication failure "ERROR: could not map filenode "base/13237/442428" to relation OID" with catalog modifying txns	Masahiko Sawada	04:06
Re: Introduce wait_for_subscription_sync for TAP tests	Amit Kapila	04:51
Re: Functions 'is_publishable_class' and 'is_publishable_relation' should stay together.	Amit Kapila	04:52
Re: support for SSE2 intrinsics 📎	John Naylor	05:00
Re: postgres_fdw: batch inserts vs. before row triggers 📎	Etsuro Fujita	05:24
Re: PostgreSQL 15 minor fixes in protocol.sgml 📎	Peter Smith	05:26
Re: optimize lookups in snapshot [sub]xip arrays	John Naylor	05:36
Re: Slow standby snapshot	Andrey Borodin	05:53
Re: [Proposal] Fully WAL logged CREATE DATABASE - No Checkpoints	Dilip Kumar	05:58
Re: automatically generating node support functions	Amit Kapila	06:21
Re: collate not support Unicode Variation Selector	Kyotaro Horiguchi	06:25
Re: [BUG] Logical replication failure "ERROR: could not map filenode "base/13237/442428" to relation OID" with catalog modifying txns	Kyotaro Horiguchi	06:27
Re: [Proposal] Fully WAL logged CREATE DATABASE - No Checkpoints	Dilip Kumar	06:30
Re: Introduce wait_for_subscription_sync for TAP tests	Masahiko Sawada	06:46
RE: [BUG] Logical replication failure "ERROR: could not map filenode "base/13237/442428" to relation OID" with catalog modifying txns	[email protected]	06:52
Re: remove more archiving overhead	Noah Misch	07:16
Fix gin index cost estimation 📎	Ronan Dunklau	07:26
Re: Race between KeepFileRestoredFromArchive() and restartpoint	Noah Misch	07:28
Re: Does having pg_last_wal_replay_lsn[replica] >= pg_current_wal_insert_lsn[master] guarantee that the replica is caught up?	Kyotaro Horiguchi	07:32
Re: [BUG] Logical replication failure "ERROR: could not map filenode "base/13237/442428" to relation OID" with catalog modifying txns 📎	Masahiko Sawada	07:49
[doc] fix a potential grammer mistake 📎	Junwang Zhao	08:10
Re: [Proposal] Fully WAL logged CREATE DATABASE - No Checkpoints 📎	Dilip Kumar	08:11
Re: Race between KeepFileRestoredFromArchive() and restartpoint	Kyotaro Horiguchi	08:15
Re: [doc] fix a potential grammer mistake	Daniel Gustafsson	08:23
Re: [doc] fix a potential grammer mistake	Erikjan Rijkers	08:27
Re: [doc] fix a potential grammer mistake	Junwang Zhao	08:35
Re: [doc] fix a potential grammer mistake	Junwang Zhao	08:38
RE: Improve logging when using Huge Pages	Shinoda, Noriyoshi (PN Japan FSIP)	08:42
Re: Does having pg_last_wal_replay_lsn[replica] >= pg_current_wal_insert_lsn[master] guarantee that the replica is caught up?	Dmitry Koterov	09:10
Re: PostgreSQL 15 minor fixes in protocol.sgml	Alvaro Herrera	10:53
Re: [PATCH] postgresql.conf.sample comment alignment.	Alvaro Herrera	10:58

Browse Archives

Prev | Next