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

Thread	Author	Time
Re: Support TRUNCATE triggers on foreign tables	Fujii Masao	00:24
Re: [BUG] Logical replication failure "ERROR: could not map filenode "base/13237/442428" to relation OID" with catalog modifying txns 📎	Masahiko Sawada	00:48
Re: Cleaning up historical portability baggage	Thomas Munro	01:10
Re: [PoC] Improve dead tuple storage for lazy vacuum	Masahiko Sawada	01:16
Re: [BUG] Logical replication failure "ERROR: could not map filenode "base/13237/442428" to relation OID" with catalog modifying txns	Masahiko Sawada	01:28
Re: pg_stat_bgwriter.buffers_backend is pretty meaningless (and more?) 📎	Melanie Plageman	02:22
Re: DropRelFileLocatorBuffers 📎	Kyotaro Horiguchi	02:25
Re: Handle infinite recursion in logical replication setup 📎	vignesh C	03:12
Re: Handle infinite recursion in logical replication setup	vignesh C	03:17
RE: [BUG] Logical replication failure "ERROR: could not map filenode "base/13237/442428" to relation OID" with catalog modifying txns	[email protected]	03:40
Re: Issue with pg_stat_subscription_stats	Amit Kapila	04:01
Re: DropRelFileLocatorBuffers	Dilip Kumar	04:07
Re: Handle infinite recursion in logical replication setup	Amit Kapila	04:21
Re: [PATCH] New [relation] option engine	Nikolay Shaplov	04:30
Re: [PATCH] New [relation] option engine 📎	Nikolay Shaplov	04:47
Reducing the chunk header sizes on all memory context types 📎	David Rowley	05:01
Re: PG15 beta1 sort performance regression due to Generation context change	David Rowley	05:15
Re: Remove trailing newlines from pg_upgrade's messages	Peter Eisentraut	05:21
Re: Reducing Memory Consumption (aset and generation)	David Rowley	05:34
Re: [BUG] Logical replication failure "ERROR: could not map filenode "base/13237/442428" to relation OID" with catalog modifying txns 📎	Masahiko Sawada	06:07
Re: [BUG] Logical replication failure "ERROR: could not map filenode "base/13237/442428" to relation OID" with catalog modifying txns	Amit Kapila	06:25
Re: First draft of the PG 15 release notes	Noah Misch	06:31
RE: WIP: Aggregation push-down - take2 📎	[email protected]	06:49
Re: [PATCH] Optimize json_lex_string by batching character copying	John Naylor	06:57
Re: Making Vars outer-join aware	Richard Guo	07:20
Re: Support TRUNCATE triggers on foreign tables	Yugo NAGATA	07:29
Re: [BUG] Logical replication failure "ERROR: could not map filenode "base/13237/442428" to relation OID" with catalog modifying txns	Masahiko Sawada	07:42
Re: pg_stat_bgwriter.buffers_backend is pretty meaningless (and more?)	Kyotaro Horiguchi	08:06
Re: replacing role-level NOINHERIT with a grant-level option	tushar	08:08
Re: Custom tuplesorts for extensions 📎	Alexander Korotkov	08:22
Re: Weird behaviour with binary copy, arrays and column count	James Vanns	08:23
Re: [BUG] Logical replication failure "ERROR: could not map filenode "base/13237/442428" to relation OID" with catalog modifying txns	Amit Kapila	08:52
RE: [BUG] Logical replication failure "ERROR: could not map filenode "base/13237/442428" to relation OID" with catalog modifying txns 📎	[email protected]	08:58
RE: Support logical replication of DDLs 📎	[email protected]	09:03
Re: [BUG] Logical replication failure "ERROR: could not map filenode "base/13237/442428" to relation OID" with catalog modifying txns	Masahiko Sawada	09:22
Re: Cleaning up historical portability baggage	Peter Eisentraut	09:26
Re: Handle infinite recursion in logical replication setup 📎	vignesh C	09:28
Re: CREATE TABLE ( .. STORAGE ..) 📎	Aleksander Alekseev	10:10
Re: [PATCH] Compression dictionaries for JSONB	Nikita Malakhov	10:25
Re: POC: Lock updated tuples in tuple_update() and tuple_delete()	Alexander Korotkov	10:29
RE: proposal: Allocate work_mem From Pool	Joseph D Wagner	10:55
Re: [BUG] Logical replication failure "ERROR: could not map filenode "base/13237/442428" to relation OID" with catalog modifying txns	Amit Kapila	10:58
Re: Cleaning up historical portability baggage	Robert Haas	12:01
Re: [PATCH] Compression dictionaries for JSONB	Aleksander Alekseev	12:15
Re: [PATCH] Reuse Workers and Replication Slots during Logical Replication	Amit Kapila	12:24
Re: proposal: Allocate work_mem From Pool	John Naylor	12:31
Re: Patch proposal: New hooks in the connection path	Drouvot, Bertrand	12:58
[PATCH] Use indexes on the subscriber when REPLICA IDENTITY is full on the publisher 📎	Önder Kalacı	13:36
Re: Making Vars outer-join aware	Tom Lane	13:37
Re: making relfilenodes 56 bits 📎	Robert Haas	13:51
Introduce "log_connection_stages" setting. 📎	Sergey Dudoladov	13:52
Re: Cleaning up historical portability baggage	Tom Lane	14:09
pgsql: Add copy/equal support for XID lists	Alvaro Herrera	14:12
Re: DropRelFileLocatorBuffers	Robert Haas	14:30
Re: pgsql: Add copy/equal support for XID lists	Tom Lane	14:36
Re: proposal: Allocate work_mem From Pool	Justin Pryzby	14:39
test_oat_hooks bug (was: Re: pgsql: Add copy/equal support for XID lists) 📎	Alvaro Herrera	15:20
Re: Introduce "log_connection_stages" setting.	Euler Taveira	15:22
Re: making relfilenodes 56 bits 📎	Dilip Kumar	15:26
Re: pg_stat_bgwriter.buffers_backend is pretty meaningless (and more?) 📎	Melanie Plageman	16:19
Re: pg_stat_bgwriter.buffers_backend is pretty meaningless (and more?)	Andres Freund	17:01
Re: making relfilenodes 56 bits	Andres Freund	17:09
Re: pg_stat_bgwriter.buffers_backend is pretty meaningless (and more?)	Andres Freund	17:18
Re: Reducing the chunk header sizes on all memory context types	Yura Sokolov	17:22
remove_useless_groupby_columns is too enthusiastic 📎	Tom Lane	17:31
Re: Cleaning up historical portability baggage	Andres Freund	17:33
Re: Reducing the chunk header sizes on all memory context types	Andres Freund	17:42
Re: Reducing the chunk header sizes on all memory context types	Andres Freund	17:44
Re: Cleaning up historical portability baggage	Tom Lane	17:54
Re: Transparent column encryption 📎	Peter Eisentraut	18:29
Re: pgsql: Add copy/equal support for XID lists 📎	Alvaro Herrera	18:35
Re: First draft of the PG 15 release notes	Bruce Momjian	18:47
Re: System catalog documentation chapter	Peter Eisentraut	18:56
Re: System catalog documentation chapter	Peter Eisentraut	18:56
Re: Making CallContext and InlineCodeBlock less special-case-y	Peter Eisentraut	18:58
Re: automatically generating node support functions	Peter Eisentraut	19:03
Re: WIN32 pg_import_system_collations 📎	Juan José Santamaría Flecha	19:32
Re: Remove trailing newlines from pg_upgrade's messages	Tom Lane	19:41
Re: Remove trailing newlines from pg_upgrade's messages	Tom Lane	19:45
Re: automatically generating node support functions	Tom Lane	19:49
Re: should check interrupts in BuildRelationExtStatistics ?	Tom Lane	20:31
Re: making relfilenodes 56 bits	Robert Haas	20:35
Re: pg15b2: large objects lost on upgrade	Robert Haas	20:51
Re: making relfilenodes 56 bits	Hannu Krosing	21:00
Re: should check interrupts in BuildRelationExtStatistics ? 📎	Zhihong Yu	21:03
Re: should check interrupts in BuildRelationExtStatistics ?	Tom Lane	21:09
Re: System catalog documentation chapter	Bruce Momjian	21:16
Re: System catalog documentation chapter	Bruce Momjian	21:17
Re: System catalog documentation chapter	Tom Lane	21:24
Re: Extending outfuncs support to utility statements 📎	Tom Lane	22:01
Re: making relfilenodes 56 bits	Andres Freund	22:02
Re: making relfilenodes 56 bits	Robert Haas	22:30
Re: Extending outfuncs support to utility statements	Tom Lane	22:38
Some clean-up work in get_cheapest_group_keys_order() 📎	David Rowley	22:55
Re: Some clean-up work in get_cheapest_group_keys_order()	Tom Lane	23:02
Re: [PATCH] Log details for client certificate failures	Jacob Champion	23:05
Re: [PATCH] Log details for client certificate failures	Jacob Champion	23:06

July 13, 2022

Thread	Author	Time
Re: pg15b2: large objects lost on upgrade	Michael Paquier	00:03
Re: Reducing Memory Consumption (aset and generation)	Ranier Vilela	00:23
Re: [BUG] Logical replication failure "ERROR: could not map filenode "base/13237/442428" to relation OID" with catalog modifying txns	Masahiko Sawada	00:36
Re: Some clean-up work in get_cheapest_group_keys_order()	David Rowley	00:50
Re: test_oat_hooks bug (was: Re: pgsql: Add copy/equal support for XID lists)	Michael Paquier	01:02
Re: Some clean-up work in get_cheapest_group_keys_order()	Tom Lane	01:12
Re: DropRelFileLocatorBuffers	Kyotaro Horiguchi	01:35
Re: pg_stat_bgwriter.buffers_backend is pretty meaningless (and more?)	Kyotaro Horiguchi	02:00
Re: pg_stat_bgwriter.buffers_backend is pretty meaningless (and more?)	Andres Freund	02:18
Re: pg_stat_bgwriter.buffers_backend is pretty meaningless (and more?)	Kyotaro Horiguchi	02:41
Re: Some clean-up work in get_cheapest_group_keys_order()	David Rowley	03:06
Re: enable/disable broken for statement triggers on partitioned tables 📎	Amit Langote	03:08
Re: Add --{no-,}bypassrls flags to createuser	Michael Paquier	03:25
Re: "ERROR: latch already owned" on gharial	Sandeep Thakkar	03:30
Re: POC: GROUP BY optimization	David Rowley	03:37
Re: proposal: Allocate work_mem From Pool	Joseph D Wagner	03:49
Re: making relfilenodes 56 bits	Dilip Kumar	04:05
Re: remove_useless_groupby_columns is too enthusiastic	David Rowley	04:06
Re: PG15 beta1 sort performance regression due to Generation context change	David Rowley	04:13
Re: Documentation about PL transforms	Pavel Stehule	04:26
Re: Perform streaming logical transactions by background workers and parallel apply	Peter Smith	04:33
Re: PATCH: Add Table Access Method option to pgbench 📎	Michel Pelletier	04:33
Re: minor change for create_list_bounds()	David Rowley	05:07
Re: Reducing the chunk header sizes on all memory context types	David Rowley	05:20
Re: Reducing the chunk header sizes on all memory context types	David Rowley	05:24
Re: Reducing the chunk header sizes on all memory context types	Andres Freund	05:41
RE: Perform streaming logical transactions by background workers and parallel apply 📎	[email protected]	05:48
Re: Non-replayable WAL records through overflows and >MaxAllocSize lengths 📎	Michael Paquier	05:54
Re: Make name optional in CREATE STATISTICS 📎	Simon Riggs	06:07
Re: [RFC] building postgres with meson -v9	Peter Eisentraut	06:39
Re: generic plans and "initial" pruning 📎	Amit Langote	06:40
Refactor to make use of a common function for GetSubscriptionRelations and GetSubscriptionNotReadyRelations. 📎	vignesh C	06:52
Re: generic plans and "initial" pruning 📎	Amit Langote	07:03
make update-po@master stops at pg_upgrade 📎	Kyotaro Horiguchi	07:08
Re: Refactor to make use of a common function for GetSubscriptionRelations and GetSubscriptionNotReadyRelations.	Michael Paquier	07:43
Re: Refactor to make use of a common function for GetSubscriptionRelations and GetSubscriptionNotReadyRelations.	Peter Smith	07:47
Re: Making Vars outer-join aware	Richard Guo	07:48
Re: ExecRTCheckPerms() and many prunable partitions 📎	Amit Langote	08:00
RE: Add --{no-,}bypassrls flags to createuser 📎	Shinoda, Noriyoshi (PN Japan FSIP)	08:14
Re: "ERROR: latch already owned" on gharial	Alvaro Herrera	08:28
Re: Add connection active, idle time to pg_stat_activity	Aleksander Alekseev	08:56
Re: Add connection active, idle time to pg_stat_activity	Aleksander Alekseev	09:09
i.e. and e.g. 📎	Kyotaro Horiguchi	09:09
Re: i.e. and e.g. 📎	Kyotaro Horiguchi	09:13
Re: i.e. and e.g.	Junwang Zhao	09:21
Re: i.e. and e.g.	Aleksander Alekseev	09:25
Re: Refactor to make use of a common function for GetSubscriptionRelations and GetSubscriptionNotReadyRelations. 📎	vignesh C	09:54
Collect ObjectAddress for ATTACH DETACH PARTITION to use in event trigger 📎	[email protected]	09:57
Re: [PATCH] Completed unaccent dictionary with many missing characters	Przemysław Sztoch	10:12
Re: CREATE TABLE ( .. STORAGE ..)	Peter Eisentraut	10:28
Re: CREATE TABLE ( .. STORAGE ..)	Aleksander Alekseev	10:38
Building PostgreSQL in external directory is broken? 📎	Alexander Korotkov	11:10
Re: Handle infinite recursion in logical replication setup	Dilip Kumar	11:19
Re: Building PostgreSQL in external directory is broken?	Aleksander Alekseev	11:48
Re: [RFC] building postgres with meson -v9	Peter Eisentraut	11:52
Re: Eliminating SPI from RI triggers - take 2	Amit Langote	11:59
Re: Building PostgreSQL in external directory is broken?	Dagfinn Ilmari Mannsåker	11:59
Bug: Reading from single byte character column type may cause out of bounds memory reads.	Spyridon Dimitrios Agathos	12:09
Re: Building PostgreSQL in external directory is broken?	Aleksander Alekseev	12:12
Re: Building PostgreSQL in external directory is broken?	Alvaro Herrera	12:19
Re: Building PostgreSQL in external directory is broken?	Alexander Korotkov	12:35
Re: Building PostgreSQL in external directory is broken?	Alexander Korotkov	12:37
Re: Bug: Reading from single byte character column type may cause out of bounds memory reads. 📎	Aleksander Alekseev	13:14
Re: PG15 beta1 sort performance regression due to Generation context change	Jonathan S. Katz	13:23
Re: Building PostgreSQL in external directory is broken?	Aleksander Alekseev	13:36
Re: Support for grabbing multiple consecutive values with nextval()	Ronan Dunklau	13:47
Re: Building PostgreSQL in external directory is broken?	Tom Lane	13:57
Re: Making Vars outer-join aware	Tom Lane	14:09
strings: ".. (compression)? is not supported by this build"	Justin Pryzby	14:33
Re: XID formatting and SLRU refactorings (was: Add 64-bit XIDs into PostgreSQL 15) 📎	Aleksander Alekseev	14:38
Re: Add 64-bit XIDs into PostgreSQL 15 📎	Maxim Orlov	14:46
Re: XID formatting and SLRU refactorings (was: Add 64-bit XIDs into PostgreSQL 15)	Justin Pryzby	14:54
Re: make install-world fails sometimes in Mac M1	Alvaro Herrera	14:56
Re: [PATCH] Optimize json_lex_string by batching character copying	Andrew Dunstan	15:03
Re: Bug: Reading from single byte character column type may cause out of bounds memory reads.	Tom Lane	15:11
Re: PG15 beta1 sort performance regression due to Generation context change	Andres Freund	15:32
Re: XID formatting and SLRU refactorings (was: Add 64-bit XIDs into PostgreSQL 15)	Pavel Borisov	15:48
Re: make update-po@master stops at pg_upgrade	Tom Lane	16:07
Re: Bug: Reading from single byte character column type may cause out of bounds memory reads.	Isaac Morland	16:33
Re: standby recovery fails (tablespace related) (tentative patch and discussion) 📎	Alvaro Herrera	16:43
Re: make update-po@master stops at pg_upgrade	Tom Lane	17:00
optimize lookups in snapshot [sub]xip arrays 📎	Nathan Bossart	17:09
Re: pg_stat_bgwriter.buffers_backend is pretty meaningless (and more?) 📎	Melanie Plageman	17:14
Re: make update-po@master stops at pg_upgrade	Alvaro Herrera	17:25
Re: fix stats_fetch_consistency value in postgresql.conf.sample	Justin Pryzby	17:30
Re: logical replication restrictions	Melih Mutlu	17:34
Re: make update-po@master stops at pg_upgrade	Tom Lane	17:41
Re: strings: ".. (compression)? is not supported by this build"	Robert Haas	17:50
Re: make update-po@master stops at pg_upgrade	Peter Eisentraut	18:09
Re: make update-po@master stops at pg_upgrade	Peter Eisentraut	18:19
Re: make update-po@master stops at pg_upgrade	Tom Lane	18:19
Re: make update-po@master stops at pg_upgrade	Peter Eisentraut	18:24
Re: Add SPLIT PARTITION/MERGE PARTITIONS commands 📎	Dmitry Koval	18:27
Re: make update-po@master stops at pg_upgrade	Peter Eisentraut	18:28
Re: make update-po@master stops at pg_upgrade	Tom Lane	18:28
Re: minor change for create_list_bounds()	Nathan Bossart	18:30
Re: Add --{no-,}bypassrls flags to createuser	Nathan Bossart	18:38
Issue with recovery_target = 'immediate'	David Steele	18:41
Re: allow building trusted languages without the untrusted versions	Nathan Bossart	18:53
Re: Add SPLIT PARTITION/MERGE PARTITIONS commands	Zhihong Yu	19:03
Re: make update-po@master stops at pg_upgrade 📎	Tom Lane	19:35
Re: Pluggable toaster 📎	Nikita Malakhov	19:45
Re: Bug: Reading from single byte character column type may cause out of bounds memory reads.	Andrew Dunstan	19:46

Browse Archives

Prev | Next