pgsql-hackers since 2024-05-23 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

May 23, 2024

Thread	Author	Time
Inval reliability, especially for inplace updates	Noah Misch	00:05
Re: Avoid possible dereference null pointer (src/backend/catalog/pg_depend.c)	Michael Paquier	00:21
Re: Shared detoast Datum proposal 📎	Andy Fan	00:27
Speed up JSON escape processing with SIMD plus other optimisations 📎	David Rowley	01:23
Re: First draft of PG 17 release notes	David Rowley	01:34
Re: Shared detoast Datum proposal	Andy Fan	01:46
Re: First draft of PG 17 release notes	Bruce Momjian	02:01
Re: using extended statistics to improve join estimates	Andy Fan	02:04
Re: Speed up JSON escape processing with SIMD plus other optimisations 📎	David Rowley	02:15
Re: First draft of PG 17 release notes	David Rowley	02:27
Re: using extended statistics to improve join estimates	Andrei Lepikhov	03:22
Re: Minor fixes for couple some comments around MERGE RETURNING	David Rowley	03:25
Re: Pgoutput not capturing the generated columns 📎	Shubham Khanna	03:49
Re: Avoid orphaned objects dependencies, take 3	Bertrand Drouvot	04:19
Re: PostgreSQL 17 Beta 1 release announcement draft	Bertrand Drouvot	04:21
Re: [PATCH] LockAcquireExtended improvement	Michael Paquier	04:58
Re: [PATCH] LockAcquireExtended improvement	Will Mortensen	05:21
Re: Fix src/test/subscription/t/029_on_error.pl test when wal_debug is enabled	Michael Paquier	05:26
RE: Pgoutput not capturing the generated columns	Hayato Kuroda (Fujitsu)	05:26
Re: Synchronizing slots from primary to standby	Peter Smith	05:33
Re: AIX support	Peter Eisentraut	05:59
Re: Schema variables - new implementation for Postgres 15	Pavel Stehule	06:30
Conflict Detection and Resolution	shveta malik	06:36
Re: State of pg_createsubscriber	Amit Kapila	06:48
RE: State of pg_createsubscriber	Hayato Kuroda (Fujitsu)	06:55
Re: Wrong results with grouping sets 📎	Richard Guo	07:30
Re: HEAD build error on Fedora 39	Sandeep Thakkar	08:08
RE: Fix src/test/subscription/t/029_on_error.pl test when wal_debug is enabled 📎	Ilyasov Ian	08:12
Re: State of pg_createsubscriber	Amit Kapila	08:40
Re: speed up a logical replica setup	Amit Kapila	08:54
about cross-compiling issue	陈亚杰	09:08
Re: Avoid possible dereference null pointer (src/backend/catalog/pg_depend.c)	Ashutosh Bapat	09:27
Improving tracking/processing of buildfarm test failures	Alexander Lakhin	11:00
Re: First draft of PG 17 release notes	Alvaro Herrera	11:22
Re: Avoid possible dereference null pointer (src/backend/catalog/pg_depend.c)	Ranier Vilela	11:23
Re: Avoid possible dereference null pointer (src/backend/catalog/pg_depend.c) 📎	Ranier Vilela	11:54
Re: PostgreSQL 17 Beta 1 release announcement draft	Alvaro Herrera	12:00
Re: PostgreSQL 17 Beta 1 release announcement draft	Jonathan S. Katz	12:22
Re: Pgoutput not capturing the generated columns	vignesh C	12:26
回复: An implementation of multi-key sort 📎	Wang Yao	12:39
Re: 回复: An implementation of multi-key sort	Heikki Linnakangas	12:47
Re: Shared detoast Datum proposal	Robert Haas	13:29
Re: State of pg_createsubscriber	Robert Haas	13:49
Re: Sort operation displays more tuples than it contains its subnode	Alena Rybakina	14:16
Re: about cross-compiling issue	Tom Lane	15:10
Re: speed up a logical replica setup	Euler Taveira	15:13
Re: First draft of PG 17 release notes	Jeff Davis	15:30
RE: AIX support	Srirama Kucherlapati	15:36
Re: AIX support	Heikki Linnakangas	16:03
ltree docs imprecise about sorting order	PG Doc comments form	16:17
Re: Avoid orphaned objects dependencies, take 3	Robert Haas	18:10
Re: Add new protocol message to change GUCs for usage with future protocol-only GUCs	Tom Lane	18:12
Re: Add new protocol message to change GUCs for usage with future protocol-only GUCs	Jacob Champion	18:25
Re: Add new protocol message to change GUCs for usage with future protocol-only GUCs	Tom Lane	18:40
Re: Add new protocol message to change GUCs for usage with future protocol-only GUCs	Robert Haas	19:45
Re: Schema variables - new implementation for Postgres 15	Pavel Stehule	19:46
Re: First draft of PG 17 release notes	Marcos Pegoraro	19:54
Re: Add new protocol message to change GUCs for usage with future protocol-only GUCs	Tom Lane	20:00
Re: Speed up JSON escape processing with SIMD plus other optimisations	Andrew Dunstan	20:34
Re: HEAD build error on Fedora 39	Andrew Dunstan	20:57
Re: Avoid orphaned objects dependencies, take 3 📎	Bertrand Drouvot	21:12
Re: CREATE INDEX CONCURRENTLY on partitioned index 📎	Ilya Gladyshev	21:14
PG catalog 📎	Karki, Sanjay	22:01
Re: DROP OWNED BY fails to clean out pg_init_privs grants	Hannu Krosing	22:08
Re: DROP OWNED BY fails to clean out pg_init_privs grants	Tom Lane	23:01

May 24, 2024

Thread	Author	Time
Re: POC: GROUP BY optimization	jian he	00:00
Re: First draft of PG 17 release notes	Peter Geoghegan	00:19
Re: Fix src/test/subscription/t/029_on_error.pl test when wal_debug is enabled	Michael Paquier	02:24
Re: Row pattern recognition 📎	Tatsuo Ishii	02:39
Re: Shared detoast Datum proposal	Andy Fan	02:46
Re: Pgoutput not capturing the generated columns	Peter Smith	02:55
struct RelOptInfo member relid comments	jian he	02:57
Re: First draft of PG 17 release notes	Bruce Momjian	03:04
Re: First draft of PG 17 release notes	Tom Lane	03:11
Re: struct RelOptInfo member relid comments	Tender Wang	03:13
Re: struct RelOptInfo member relid comments	Tom Lane	03:14
Re: speed up a logical replica setup	Amit Kapila	03:24
Re: First draft of PG 17 release notes	Bruce Momjian	03:27
Re: struct RelOptInfo member relid comments	jian he	03:39
Re: Cleaning up perl code 📎	Michael Paquier	05:09
Re: struct RelOptInfo member relid comments	Ashutosh Bapat	05:23
Re: struct RelOptInfo member relid comments	Tom Lane	05:28
Re: Avoid possible dereference null pointer (src/backend/catalog/pg_depend.c)	Michael Paquier	05:33
Re:about cross-compiling issue	Long Song	06:02
Re: Avoid possible dereference null pointer (src/backend/catalog/pg_depend.c)	Ashutosh Bapat	06:28
Re: Table AM Interface Enhancements	Mats Kindahl	06:36
Re: Avoid possible dereference null pointer (src/backend/catalog/pg_depend.c)	Michael Paquier	06:45
Re: In-placre persistance change of a relation 📎	Kyotaro Horiguchi	07:09
Addressing SECURITY DEFINER Function Vulnerabilities in PostgreSQL Extensions	Ashutosh Sharma	07:21
Re: Addressing SECURITY DEFINER Function Vulnerabilities in PostgreSQL Extensions	Ashutosh Bapat	08:54
Re: CREATE INDEX CONCURRENTLY on partitioned index	Alexander Pyhalov	09:04
Possible incorrect row estimation for Gather paths 📎	Anthonin Bonnefoy	09:35
Re: speed up a logical replica setup 📎	Shlok Kyal	09:37
Re: Convert node test compile-time settings into run-time parameters 📎	Peter Eisentraut	09:58
Re: PG catalog	David G. Johnston	11:07
Re: Improving tracking/processing of buildfarm test failures	Amit Kapila	11:15
Re: DROP OWNED BY fails to clean out pg_init_privs grants	Daniel Gustafsson	11:27
Re: Schema variables - new implementation for Postgres 15	Dmitry Dolgov	11:31
Re: Avoid possible dereference null pointer (src/backend/catalog/pg_depend.c) 📎	Ashutosh Bapat	11:48
Re: Avoid possible dereference null pointer (src/backend/catalog/pg_depend.c)	Ranier Vilela	12:05
Question: Why Are File Descriptors Not Closed and Accounted for PostgreSQL Backends?	Srinath Reddy Sadipiralla	12:17
Re: 回复: An implementation of multi-key sort	Yao Wang	12:50
Re: Schema variables - new implementation for Postgres 15	Pavel Stehule	13:00
Re: Wrong results with grouping sets 📎	Richard Guo	13:08
Re: Schema variables - new implementation for Postgres 15	Pavel Stehule	13:20
Re: warn if GUC set to an invalid shared library	Robert Haas	13:26
Re: Add new protocol message to change GUCs for usage with future protocol-only GUCs	Robert Haas	13:28
Re: Question: Why Are File Descriptors Not Closed and Accounted for PostgreSQL Backends?	Heikki Linnakangas	13:45
Re: First draft of PG 17 release notes	Robert Haas	13:54
Re: PG catalog	Tom Lane	13:57
Re: Question: Why Are File Descriptors Not Closed and Accounted for PostgreSQL Backends?	Srinath Reddy Sadipiralla	14:05
Re: Upgrade Debian CI images to Bookworm	Peter Eisentraut	14:17
Re: DROP OWNED BY fails to clean out pg_init_privs grants	Tom Lane	14:20
Re: Convert node test compile-time settings into run-time parameters	Tom Lane	14:39
Re: DROP OWNED BY fails to clean out pg_init_privs grants	Daniel Gustafsson	14:46
Re: Logging which local address was connected to in log_line_prefix 📎	Greg Sabino Mullane	15:33
Re: commitfest.postgresql.org is no longer fit for purpose	Tomas Vondra	15:40
Re: pg_parse_json() should not leak token copies on failure 📎	Jacob Champion	15:43
Re: warn if GUC set to an invalid shared library 📎	Justin Pryzby	15:48
Re: DROP OWNED BY fails to clean out pg_init_privs grants	Tom Lane	15:59
PG17beta1: Unable to test Postgres on Fedora due to fatal Error in psql: undefined symbol: PQsocketPoll	Hans Buschmann	16:58
Re: commitfest.postgresql.org is no longer fit for purpose	Tom Lane	17:09
Re: warn if GUC set to an invalid shared library	Robert Haas	17:15
Re: Upgrade Debian CI images to Bookworm	Andres Freund	17:30
Re: PG17beta1: Unable to test Postgres on Fedora due to fatal Error in psql: undefined symbol: PQsocketPoll	Tom Lane	17:34
Re: First draft of PG 17 release notes	Andres Freund	17:50
Re: apply_scanjoin_target_to_paths and partitionwise join	arne.roland	18:02
Re: Add minimal C example and SQL registration example for custom table access methods. 📎	Phil Eaton	18:10
Re: DROP OWNED BY fails to clean out pg_init_privs grants	Robert Haas	18:16
Re: First draft of PG 17 release notes	Andres Freund	18:23
Re: First draft of PG 17 release notes	Peter Geoghegan	18:26
Re: apply_scanjoin_target_to_paths and partitionwise join	Robert Haas	18:47
Document use of ldapurl with LDAP simple bind 📎	Jacob Champion	18:54
Re: DROP OWNED BY fails to clean out pg_init_privs grants	Tom Lane	18:57
Re: Add minimal C example and SQL registration example for custom table access methods.	Fabrízio de Royes Mello	18:59
Re: commitfest.postgresql.org is no longer fit for purpose	Tomas Vondra	19:17
Re: Add SPLIT PARTITION/MERGE PARTITIONS commands	Tom Lane	19:29
Re: commitfest.postgresql.org is no longer fit for purpose	Tom Lane	19:45
Re: DROP OWNED BY fails to clean out pg_init_privs grants	Robert Haas	19:47
Re: Serverside SNI support in libpq	Cary Huang	19:54
Re: Add SPLIT PARTITION/MERGE PARTITIONS commands	Alexander Lakhin	20:00
Re: DROP OWNED BY fails to clean out pg_init_privs grants	Tom Lane	20:00
Re: Improving tracking/processing of buildfarm test failures	Noah Misch	20:00
Re: commitfest.postgresql.org is no longer fit for purpose	Joe Conway	20:23
Re: commitfest.postgresql.org is no longer fit for purpose	Tom Lane	20:44
Re: Conflict Detection and Resolution	Tomas Vondra	21:09
Re: commitfest.postgresql.org is no longer fit for purpose	Tomas Vondra	21:23
Re: commitfest.postgresql.org is no longer fit for purpose	Tom Lane	21:38
Re: Streaming I/O, vectored I/O (WIP)	Thomas Munro	22:00
Re: Add new protocol message to change GUCs for usage with future protocol-only GUCs	Jelte Fennema-Nio	22:08

May 25, 2024

Thread	Author	Time
Re: Schema variables - new implementation for Postgres 15	Pavel Stehule	01:16
Re: Schema variables - new implementation for Postgres 15	Tom Lane	01:29
Re: Volatile write caches on macOS and Windows, redux	Nathan Bossart	04:41
Re: Schema variables - new implementation for Postgres 15	Pavel Stehule	05:10
relfilenode statistics 📎	Bertrand Drouvot	07:52
Re: Schema variables - new implementation for Postgres 15	walther	08:24
Re: Add new protocol message to change GUCs for usage with future protocol-only GUCs	Jelte Fennema-Nio	10:23
[PATCH]A minor improvement to the error-report in SimpleLruWriteAll() 📎	Long Song	10:29
Re: Add new protocol message to change GUCs for usage with future protocol-only GUCs	Jelte Fennema-Nio	10:39
Re: Add new protocol message to change GUCs for usage with future protocol-only GUCs	Jelte Fennema-Nio	10:43
Re: Schema variables - new implementation for Postgres 15	Pavel Stehule	10:50
Re: Add new protocol message to change GUCs for usage with future protocol-only GUCs	Dave Cramer	10:53
Re: Volatile write caches on macOS and Windows, redux	Jelte Fennema-Nio	11:01
Re: Improving tracking/processing of buildfarm test failures	Alexander Lakhin	12:00
Re: Add SPLIT PARTITION/MERGE PARTITIONS commands	Alexander Korotkov	12:53
Reg - pg_background async triggers	_sanjiv_ SK	13:28
Re: DROP OWNED BY fails to clean out pg_init_privs grants	Hannu Krosing	14:09
Re: DROP OWNED BY fails to clean out pg_init_privs grants	Tom Lane	14:47
Fix an incorrect assertion condition in mdwritev(). 📎	Xing Guo	15:52
Re: Add SPLIT PARTITION/MERGE PARTITIONS commands	Justin Pryzby	17:53
Re: DROP OWNED BY fails to clean out pg_init_privs grants	Hannu Krosing	22:05

May 26, 2024

Thread	Author	Time
Re: Fix an incorrect assertion condition in mdwritev().	Michael Paquier	00:22
Re: First draft of PG 17 release notes	Bruce Momjian	02:10
Re: First draft of PG 17 release notes 📎	Bruce Momjian	03:41
Re: First draft of PG 17 release notes	Bruce Momjian	03:49
Re: First draft of PG 17 release notes	Bruce Momjian	03:50
Re: Add SPLIT PARTITION/MERGE PARTITIONS commands	Alexander Korotkov	03:56
Re: First draft of PG 17 release notes	Bruce Momjian	03:57
Re: Add SPLIT PARTITION/MERGE PARTITIONS commands	Alexander Korotkov	03:58
Re: Fix an incorrect assertion condition in mdwritev().	Tom Lane	03:59
Re: AIX support	Bruce Momjian	04:00
Re: Fix an incorrect assertion condition in mdwritev().	Tom Lane	04:08
Improve conditional compilation for direct I/O alignment checks 📎	Junwang Zhao	07:16
Re: First draft of PG 17 release notes	Alvaro Herrera	08:10
Re: Improve conditional compilation for direct I/O alignment checks 📎	Junwang Zhao	10:35
Re: Fix an incorrect assertion condition in mdwritev().	Michael Paquier	11:07
Re: Improving tracking/processing of buildfarm test failures	Andrew Dunstan	11:44
Re: First draft of PG 17 release notes	Bruce Momjian	12:42
DISCARD ALL does not force re-planning of plpgsql functions/procedures	Jelte Fennema-Nio	17:15
Re: DISCARD ALL does not force re-planning of plpgsql functions/procedures	Tom Lane	17:39
Re: DISCARD ALL does not force re-planning of plpgsql functions/procedures	Jelte Fennema-Nio	19:26
Re: DISCARD ALL does not force re-planning of plpgsql functions/procedures	Pavel Stehule	19:30
Re: DISCARD ALL does not force re-planning of plpgsql functions/procedures	Jelte Fennema-Nio	19:34
Re: DROP OWNED BY fails to clean out pg_init_privs grants 📎	Hannu Krosing	21:19
Re: DROP OWNED BY fails to clean out pg_init_privs grants	Tom Lane	21:25
Re: DROP OWNED BY fails to clean out pg_init_privs grants	Daniel Gustafsson	21:27
Re: Improve conditional compilation for direct I/O alignment checks	Peter Eisentraut	21:52
Re: Speed up JSON escape processing with SIMD plus other optimisations 📎	David Rowley	23:39
Re: Avoid possible dereference null pointer (src/backend/catalog/pg_depend.c)	Michael Paquier	23:40

May 27, 2024

Thread	Author	Time
Re: Conflict Detection and Resolution	shveta malik	05:48

Browse Archives

Prev | Next