pgsql-hackers - August 2022

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. 1, 2022

Thread	Author	Time
Re: pg_upgrade errno	Michael Paquier	00:19
Re: Backup command and functions can cause assertion failure and segmentation fault	Michael Paquier	00:33
Re: Allow file inclusion in pg_hba and pg_ident files	Julien Rouhaud	01:12
Re: pg_buffercache: add sql test	Julien Rouhaud	01:47
Re: [Refactor]Avoid to handle FORCE_NOT_NULL/FORCE_NULL options when COPY TO 📎	Zhang Mingli	01:59
Re: standby recovery fails (tablespace related) (tentative patch and discussion)	Andres Freund	02:01
Re: ci: update to freebsd 13.1 / remove minor versions from image names	Andres Freund	02:02
Re: [BUG] Logical replication failure "ERROR: could not map filenode "base/13237/442428" to relation OID" with catalog modifying txns 📎	Masahiko Sawada	02:16
RE: Collect ObjectAddress for ATTACH DETACH PARTITION to use in event trigger	houzj.fnst@fujitsu.com	03:33
Re: enable/disable broken for statement triggers on partitioned tables	Amit Langote	03:51
Re: Fast COPY FROM based on batch insert	Etsuro Fujita	04:00
Re: Support logical replication of DDLs	Peter Smith	04:18
Re: Schema variables - new implementation for Postgres 15	Julien Rouhaud	04:53
Re: Checking pgwin32_is_junction() errors 📎	Thomas Munro	05:09
Re: making relfilenodes 56 bits	Dilip Kumar	05:20
RE: Handle infinite recursion in logical replication setup	shiy.fnst@fujitsu.com	05:27
Re: making relfilenodes 56 bits	Dilip Kumar	05:34
RE: Partial aggregates pushdown	Fujii.Yuki@df.MitsubishiElectric.co.jp	05:55
Re: Schema variables - new implementation for Postgres 15 📎	Pavel Stehule	06:24
Re: Add test of pg_prewarm extenion 📎	Dong Wook Lee	06:27
Re: Oversight in slab.c SlabContextCreate(), initial memory allocation size is not populated to context->mem_allocated	Kyotaro Horiguchi	07:57
Re: Handle infinite recursion in logical replication setup	Peter Smith	08:02
Re: Inconvenience of pg_read_binary_file()	Kyotaro Horiguchi	08:41
Re: Handle infinite recursion in logical replication setup	Amit Kapila	08:51
Typo in pg_db_role_setting.h	Japin Li	09:18
Re: Typo in pg_db_role_setting.h	Richard Guo	09:28
Re: Add test of pg_prewarm extenion	Julien Rouhaud	09:55
Question about user/database-level parameters	Japin Li	10:24
Re: Trying to add more tests to gistbuild.c	Pavel Borisov	10:30
Re: [PATCH] Compression dictionaries for JSONB 📎	Aleksander Alekseev	11:25
Re: making relfilenodes 56 bits 📎	Dilip Kumar	11:57
Re: Should fix a comment referring to stats collector?	torikoshia	12:05
Re: logical replication restrictions 📎	Euler Taveira	12:07
Re: NAMEDATALEN increase because of non-latin languages 📎	John Naylor	12:38
Re: Typo in pg_db_role_setting.h	John Naylor	12:46
Re: logical replication restrictions	Euler Taveira	13:15
Re: Reducing planning time on tables with many indexes	David Geier	13:33
[feature]COPY FROM enable FORCE_NULL/FORCE_NOT_NULL on all columns 📎	Zhang Mingli	13:56
Re: Typo in pg_db_role_setting.h	Tom Lane	14:16
Re: Triggers should work in isolation, with a final conflict detection step	David G. Johnston	14:20
Re: Typo in pg_db_role_setting.h	Japin Li	14:24
Re: Add test of pg_prewarm extenion	Tom Lane	14:27
Re: [BUG] Logical replication failure "ERROR: could not map filenode "base/13237/442428" to relation OID" with catalog modifying txns 📎	Amit Kapila	14:31
Re: Add test of pg_prewarm extenion 📎	Dong Wook Lee	14:33
Re: Typo in pg_db_role_setting.h 📎	Japin Li	14:42
Re: support for MERGE	Justin Pryzby	14:52
Re: Add test of pg_prewarm extenion 📎	Dong Wook Lee	14:53
Re: support for MERGE	Álvaro Herrera	15:30
Re: Hash index build performance tweak from sorting 📎	Simon Riggs	15:37
[Commitfest 2022-07] is Done!	Jacob Champion	15:40
Re: [Commitfest 2022-07] Patch Triage: Waiting on Author	Justin Pryzby	15:51
Re: Dump/Restore of non-default PKs	Simon Riggs	16:00
Re: [PATCH] Use indexes on the subscriber when REPLICA IDENTITY is full on the publisher 📎	Önder Kalacı	16:21
Re: [Commitfest 2022-07] Patch Triage: Waiting on Author	Jacob Champion	16:30
Re: [Commitfest 2022-07] Patch Triage: Waiting on Author	Robert Haas	16:33
Smoothing the subtrans performance catastrophe 📎	Simon Riggs	16:42
Re: [Commitfest 2022-07] Patch Triage: Waiting on Author	Jacob Champion	16:43
Re: [Commitfest 2022-07] is Done!	Tom Lane	16:44
Re: [Commitfest 2022-07] Patch Triage: Waiting on Author	Tom Lane	16:56
Re: pg_auth_members.grantor is bunk	Robert Haas	17:00
Re: Avoid unecessary MemSet call (src/backend/utils/cache/relcache.c) 📎	Ranier Vilela	17:08
Re: [Commitfest 2022-07] Patch Triage: Waiting on Author	Robert Haas	17:20
Re: pg_auth_members.grantor is bunk	Robert Haas	17:33
Re: [Commitfest 2022-07] Patch Triage: Waiting on Author	Tom Lane	17:33
Re: [Commitfest 2022-07] is Done!	Alvaro Herrera	17:33
Re: pg_auth_members.grantor is bunk	Tom Lane	17:38
fix typos 📎	Erik Rijkers	18:04
Re: fix typos 📎	Justin Pryzby	18:11
Re: using file cloning in create database / initdb 📎	Justin Pryzby	18:15
Re: Allow pageinspect's bt_page_stats function to return a set of rows instead of a single row	Naeem Akhter	18:28
Re: enable/disable broken for statement triggers on partitioned tables	Alvaro Herrera	18:58
Re: enable/disable broken for statement triggers on partitioned tables	Tom Lane	19:13
Re: [feature]COPY FROM enable FORCE_NULL/FORCE_NOT_NULL on all columns	Andrew Dunstan	19:50
Re: pg_auth_members.grantor is bunk 📎	Robert Haas	19:51
Re: Making Vars outer-join aware 📎	Tom Lane	19:51
Re: [feature]COPY FROM enable FORCE_NULL/FORCE_NOT_NULL on all columns	Andrew Dunstan	19:53
PostgreSQL 15 minor fixes in protocol.sgml 📎	Ekaterina Kiryanova	20:00
Re: [Commitfest 2022-07] Patch Triage: Waiting on Author	Robert Haas	20:01
Re: Checking pgwin32_is_junction() errors	Andrew Dunstan	20:06
Re: The "char" type versus non-ASCII characters	Andrew Dunstan	20:11
Re: The "char" type versus non-ASCII characters	Tom Lane	20:16
Re: [PATCH] Implement INSERT SET syntax	Jacob Champion	20:18
Re: A problem about partitionwise join	Jacob Champion	20:24
Re: Making Vars outer-join aware	Tom Lane	20:26
Re: Making Vars outer-join aware	Zhihong Yu	20:28
Re: Strange behavior with polygon and NaN	Jacob Champion	20:29
Re: [PATCH] New default role allowing to change per-role/database settings	Jacob Champion	20:31
Re: Showing applied extended statistics in explain	Jacob Champion	20:38
Re: Map WAL segment files on PMEM as WAL buffers	Jacob Champion	20:40
Re: Improve logging when using Huge Pages	Jacob Champion	20:45
Re: [PATCH] psql: \dn+ to show size of each schema (and \dA+ for AMs)	Jacob Champion	20:47
Re: pgcrypto support for bcrypt $2b$ hashes	Jacob Champion	20:51
Re: pg15b2: large objects lost on upgrade	Jonathan S. Katz	21:17
Re: allow building trusted languages without the untrusted versions	Jacob Champion	21:41
Re: Improving connection scalability (src/backend/storage/ipc/procarray.c)	Jacob Champion	21:51
Re: Skip partition tuple routing with constant partition key	David Rowley	21:58
Re: Can postgres ever delete the recycled future WAL files to free-up disk space if max_wal_size is reduced or wal_recycle is set to off?	Jacob Champion	22:03
Re: Add test of pg_prewarm extenion	Tom Lane	22:09
Re: using file cloning in create database / initdb	Thomas Munro	22:13
Re: [Commitfest 2022-07] is Done!	Jacob Champion	23:03
Re: Is select_outer_pathkeys_for_merge() too strict now we have Incremental Sorts?	David Rowley	23:04
Re: [Commitfest 2022-07] is Done!	Jacob Champion	23:08
[PATCH] postgresql.conf.sample comment alignment. 📎	Peter Smith	23:24
Re: Improving connection scalability (src/backend/storage/ipc/procarray.c)	Ranier Vilela	23:27
Re: PG 15 (and to a smaller degree 14) regression due to ExprEvalStep size	Andres Freund	23:27
[DOCS] Stats views and functions not in order?	Peter Smith	23:40
Re: Table AM and DROP TABLE [ Was: Table AM and DDLs]	Andres Freund	23:44

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 📎	houzj.fnst@fujitsu.com	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	shiy.fnst@fujitsu.com	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	shiy.fnst@fujitsu.com	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 📎	houzj.fnst@fujitsu.com	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

Browse Archives

Prev | Next