pgsql-hackers since 2021-04-06 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

April 6, 2021

Thread	Author	Time
Re: New IndexAM API controlling index vacuum strategies	Andres Freund	00:00
Re: New IndexAM API controlling index vacuum strategies	Peter Geoghegan	00:09
RE: Stronger safeguard for archive recovery not to miss data	[email protected]	00:13
Re: New IndexAM API controlling index vacuum strategies	Peter Geoghegan	00:18
Re: New IndexAM API controlling index vacuum strategies	Andres Freund	00:27
Re: Stronger safeguard for archive recovery not to miss data 📎	Fujii Masao	00:41
Table refer leak in logical replication	[email protected]	01:04
RE: Table refer leak in logical replication 📎	[email protected]	01:15
RE: Table refer leak in logical replication 📎	[email protected]	01:49
Re: Get memory contexts of an arbitrary backend process	torikoshia	01:57
Re: policies with security definer option for allowing inline optimization	Dan Lynch	02:51
Re: Asynchronous Append on postgres_fdw nodes.	Kyotaro Horiguchi	03:01
Re: New IndexAM API controlling index vacuum strategies	Peter Geoghegan	03:13
Re: Table refer leak in logical replication 📎	Masahiko Sawada	03:23
Re: ALTER TABLE ADD COLUMN fast default	Andrew Gierth	03:52
Re: Binary search in ScalarArrayOpExpr for OR'd constant arrays 📎	David Rowley	03:58
RE: Table refer leak in logical replication 📎	[email protected]	04:01
document that brin's autosummarize parameter is off by default 📎	Jaime Casanova	04:02
RE: Stronger safeguard for archive recovery not to miss data	[email protected]	04:11
Re: Table refer leak in logical replication 📎	Amit Langote	04:15
Re: TRUNCATE on foreign table	Bharath Rupireddy	04:33
subtransaction performance regression [kind of] due to snapshot caching 📎	Andres Freund	04:35
pgsql: Add function to log the memory contexts of specified backend pro	Fujii Masao	04:45
Re: Get memory contexts of an arbitrary backend process	Fujii Masao	04:46
Re: subtransaction performance regression [kind of] due to snapshot caching	Tom Lane	04:47
Re: Table refer leak in logical replication	Masahiko Sawada	04:56
typo fix in pgstat.c: "exits should be exists" 📎	vignesh C	04:57
Re: typo fix in pgstat.c: "exits should be exists"	Fujii Masao	05:11
Re: Proposal: Save user's original authenticated identity for logging	Michael Paquier	05:15
Re: subtransaction performance regression [kind of] due to snapshot caching	Andres Freund	05:23
Re: Support ALTER SUBSCRIPTION ... ADD/DROP PUBLICATION ... syntax	Japin Li	05:24
Re: typo fix in pgstat.c: "exits should be exists"	vignesh C	05:24
Re: Table refer leak in logical replication 📎	Amit Langote	05:25
Re: subtransaction performance regression [kind of] due to snapshot caching	Tom Lane	05:34
Reference Leak with type	Rohit Bhogate	05:39
Re: Since '2001-09-09 01:46:40'::timestamp microseconds are lost when extracting epoch	Peter Eisentraut	05:48
Re: Replication slot stats misgivings	Amit Kapila	05:52
Re: subtransaction performance regression [kind of] due to snapshot caching	Andres Freund	05:59
RE: Table refer leak in logical replication	[email protected]	06:03
Re: policies with security definer option for allowing inline optimization	Noah Misch	06:20
Re: Stronger safeguard for archive recovery not to miss data	Kyotaro Horiguchi	06:24
Re: Replication slot stats misgivings	Amit Kapila	06:49
RE: Stronger safeguard for archive recovery not to miss data	[email protected]	06:59
Re: postgres_fdw: IMPORT FOREIGN SCHEMA ... LIMIT TO (partition)	Amit Langote	07:00
Re: postgres_fdw: IMPORT FOREIGN SCHEMA ... LIMIT TO (partition)	Amit Langote	07:05
Re: A reloption for partitioned tables - parallel_workers	Amit Langote	07:46
Re: Idea: Avoid JOINs by using path expressions to follow FKs	Joel Jacobson	08:11
Re: Asynchronous Append on postgres_fdw nodes.	Etsuro Fujita	08:45
Re: Key management with tests	Neil Chen	08:56
Re: Confusing behavior of psql's \e	Laurenz Albe	09:17
Re: Allow batched insert during cross-partition updates 📎	Amit Langote	09:37
Re: Allow batched insert during cross-partition updates	Bharath Rupireddy	09:48
Re: Support ALTER SUBSCRIPTION ... ADD/DROP PUBLICATION ... syntax	Peter Eisentraut	09:56
Re: Asynchronous Append on postgres_fdw nodes.	Etsuro Fujita	10:25
Re: UniqueKey on Partitioned table.	Andy Fan	10:31
Re: UniqueKey on Partitioned table.	David Rowley	10:55
Re: [PATCH] Covering SPGiST index 📎	Pavel Borisov	11:09
Re: Stronger safeguard for archive recovery not to miss data	Fujii Masao	11:13
Re: pgbench - add pseudo-random permutation function	Dean Rasheed	11:19
Re: Stronger safeguard for archive recovery not to miss data	David Steele	11:44
RE: Stronger safeguard for archive recovery not to miss data	[email protected]	11:48
Re: Replication slot stats misgivings	vignesh C	11:58
Re: TRUNCATE on foreign table 📎	Kazutaka Onishi	12:06
Re: Reference Leak with type	Michael Paquier	12:19
Re: postgres_fdw: IMPORT FOREIGN SCHEMA ... LIMIT TO (partition) 📎	Fujii Masao	12:29
Re: Minimal logical decoding on standbys 📎	Drouvot, Bertrand	12:30
Re: Can we remove extra memset in BloomInitPage, GinInitPage and SpGistInitPage when we have it in PageInit?	Michael Paquier	12:39
Re: postgres_fdw: IMPORT FOREIGN SCHEMA ... LIMIT TO (partition)	Matthias van de Meent	12:39
Re: postgres_fdw: IMPORT FOREIGN SCHEMA ... LIMIT TO (partition)	Michael Paquier	13:02
Re: Allow batched insert during cross-partition updates 📎	Amit Langote	13:07
Re: [GSoC 2021 Proposal] Develop Performance Farm Benchmarks and Website 📎	YoungHwan Joo	13:22
Re: [PATCH] New default role allowing to change per-role/database settings	Michael Banck	13:37
Re: Can we remove extra memset in BloomInitPage, GinInitPage and SpGistInitPage when we have it in PageInit? 📎	Bharath Rupireddy	13:43
Re: Allow batched insert during cross-partition updates	Bharath Rupireddy	13:52
Re: Stronger safeguard for archive recovery not to miss data	Fujii Masao	14:01
Re: New IndexAM API controlling index vacuum strategies	Matthias van de Meent	14:05
Re: TRUNCATE on foreign table	Bharath Rupireddy	14:17
Re: TRUNCATE on foreign table	Bharath Rupireddy	14:25
Re: Feature improvement: can we add queryId for pg_catalog.pg_stat_activity view?	Nitin Jadhav	14:35
[PATCH] PREPARE TRANSACTION unexpected behavior with TEMP TABLE 📎	Himanshu Upadhyaya	14:47
Re: ALTER TABLE ADD COLUMN fast default	Tom Lane	15:01
Re: Feature improvement: can we add queryId for pg_catalog.pg_stat_activity view?	Julien Rouhaud	15:11
Re: psql - add SHOW_ALL_RESULTS option	Peter Eisentraut	15:35
Re: Feature improvement: can we add queryId for pg_catalog.pg_stat_activity view?	Alvaro Herrera	15:41
Re: Feature improvement: can we add queryId for pg_catalog.pg_stat_activity view?	Julien Rouhaud	15:49
Re: pg_ls_tmpdir to show directories and shared filesets (and pg_ls_*) 📎	Justin Pryzby	16:01
Re: [EXTERNAL] Any objection to documenting pg_sequence_last_value()?	James Coleman	16:13
Re: subtransaction performance regression [kind of] due to snapshot caching	Andres Freund	16:28
Re: shared-memory based stats collector	Andres Freund	16:32
Re: TRUNCATE on foreign table 📎	Kazutaka Onishi	16:44
Re: Remove page-read callback from XLogReaderState. 📎	Thomas Munro	17:09
Re: postgres_fdw: IMPORT FOREIGN SCHEMA ... LIMIT TO (partition)	Fujii Masao	17:35
Re: GSoc Applicant	Mark Wong	17:39
Re: Force lookahead in COPY FROM parsing 📎	Heikki Linnakangas	17:50
Re: Minimal logical decoding on standbys	Andres Freund	18:02
Re: GSoc Applicant	Mohamed Mansour	18:02
Re: [GSoC 2021 Proposal] Develop Performance Farm Benchmarks and Website	Ilaria	18:03
Re: Stronger safeguard for archive recovery not to miss data 📎	Fujii Masao	18:03
Re: GSoC 2021 - Student looking for a mentor - Magzum Assanbayev	Ilaria	18:07
Re: Proposal: Save user's original authenticated identity for logging 📎	Jacob Champion	18:31
Re: Can we remove extra memset in BloomInitPage, GinInitPage and SpGistInitPage when we have it in PageInit?	Mahendra Singh Thalor	18:37
Re: Key management with tests 📎	Bruce Momjian	18:42
Re: Parallel Full Hash Join	Melanie Plageman	18:59
PostgreSQL log query's result size	Hellmuth Vargas	19:03
Re: PostgreSQL log query's result size	Justin Pryzby	19:15
Re: Stronger safeguard for archive recovery not to miss data	Tom Lane	20:01
Re: policies with security definer option for allowing inline optimization	Dan Lynch	20:16
Re: Parallel Full Hash Join	Zhihong Yu	20:56
Re: Autovacuum on partitioned table (autoanalyze)	Alvaro Herrera	20:56
Re: psql - add SHOW_ALL_RESULTS option	Fabien COELHO	21:29
Re: pgbench - add pseudo-random permutation function	Fabien COELHO	21:31
Re: Stronger safeguard for archive recovery not to miss data	Fujii Masao	22:46
Re: Stronger safeguard for archive recovery not to miss data	Fujii Masao	22:50
Re: Remove page-read callback from XLogReaderState.	Thomas Munro	22:57
Re: Remove page-read callback from XLogReaderState.	Andres Freund	23:09
Re: Remove page-read callback from XLogReaderState.	Alvaro Herrera	23:18
Re: ModifyTable overheads in generic plans	Tom Lane	23:24
Re: Remove page-read callback from XLogReaderState.	Thomas Munro	23:37
Re: Remove page-read callback from XLogReaderState.	Alvaro Herrera	23:49
Re: Autovacuum on partitioned table (autoanalyze)	Andres Freund	23:58

April 7, 2021

Thread	Author	Time
Re: ModifyTable overheads in generic plans	Andres Freund	00:00
Re: [HACKERS] logical decoding of two-phase transactions 📎	Peter Smith	00:25
Re: Keep notnullattrs in RelOptInfo (Was part of UniqueKey patch series)	Andy Fan	00:28
Re: Binary search in ScalarArrayOpExpr for OR'd constant arrays	James Coleman	00:39
Re: Can we remove extra memset in BloomInitPage, GinInitPage and SpGistInitPage when we have it in PageInit?	Bharath Rupireddy	01:01
Re: TRUNCATE on foreign table	Bharath Rupireddy	01:15
Re: Proposal: Save user's original authenticated identity for logging	Michael Paquier	01:20
Re: Allow batched insert during cross-partition updates	Amit Langote	01:49
Re: policies with security definer option for allowing inline optimization	Noah Misch	02:23
Re: Support ALTER SUBSCRIPTION ... ADD/DROP PUBLICATION ... syntax	Japin Li	02:49
Re: shared-memory based stats collector	Kyotaro Horiguchi	03:05
Re: Autovacuum on partitioned table (autoanalyze)	yuzuko	03:13
Re: New IndexAM API controlling index vacuum strategies 📎	Peter Geoghegan	03:16
Re: TRUNCATE on foreign table 📎	Kazutaka Onishi	03:30
Re: Autovacuum on partitioned table (autoanalyze)	Alvaro Herrera	03:33
Re: multi-install PostgresNode fails with older postgres versions 📎	Mark Dilger	05:03
Re: Any objections to implementing LogicalDecodeMessageCB for pgoutput?	Amit Kapila	05:20
RE: Stronger safeguard for archive recovery not to miss data	[email protected]	05:22
buildfarm instance bichir stuck	Robins Tharakan	05:43
Re: MultiXact\SLRU buffers configuration 📎	Thomas Munro	05:59
Re: Yet another fast GiST build	Heikki Linnakangas	06:00
Re: Can we remove extra memset in BloomInitPage, GinInitPage and SpGistInitPage when we have it in PageInit?	Michael Paquier	06:13
Re: buildfarm instance bichir stuck	Thomas Munro	06:16
Re: Can we remove extra memset in BloomInitPage, GinInitPage and SpGistInitPage when we have it in PageInit?	Bharath Rupireddy	06:17
Re: [HACKERS] logical decoding of two-phase transactions 📎	Peter Smith	06:43
RE: Disable WAL logging to speed up data loading 📎	[email protected]	06:43
Truncate in synchronous logical replication failed	[email protected]	06:56
Re: [Patch] ALTER SYSTEM READ ONLY 📎	Amul Sul	07:08
Re: buildfarm instance bichir stuck	Robins Tharakan	07:30
missing documentation for streaming in-progress transactions 📎	Ajin Cherian	07:40
RE: psql - add SHOW_ALL_RESULTS option	[email protected]	07:40
Re: Wired if-statement in gen_partprune_steps_internal	David Rowley	07:43
Re: New IndexAM API controlling index vacuum strategies 📎	Masahiko Sawada	07:50
Re: ModifyTable overheads in generic plans 📎	Amit Langote	08:18
Re: [PATCH] Tracking statements entry timestamp in pg_stat_statements	Seino Yuki	08:26
Re: Truncate in synchronous logical replication failed	Amit Kapila	08:27
RE: Truncate in synchronous logical replication failed	[email protected]	08:34
Re: Remove page-read callback from XLogReaderState. 📎	Kyotaro Horiguchi	08:50
Re: Wired if-statement in gen_partprune_steps_internal	Amit Langote	09:04
Re: Minimal logical decoding on standbys 📎	Drouvot, Bertrand	09:06
Re: Replication slot stats misgivings 📎	vignesh C	09:20
Re: Implementing Incremental View Maintenance 📎	Yugo NAGATA	09:25
Re: Wired if-statement in gen_partprune_steps_internal	David Rowley	09:53
Set access strategy for parallel vacuum workers 📎	Amit Kapila	10:00
Re: New IndexAM API controlling index vacuum strategies	Amit Kapila	10:01
Re: Yet another fast GiST build	Heikki Linnakangas	10:23
CREATE SEQUENCE with RESTART option	Bharath Rupireddy	10:25
Why is specifying oids = false multiple times in create table is silently ignored?	Bharath Rupireddy	10:30
Re: New predefined roles- 'pg_read/write_all_data'	Michael Banck	10:36
Re: [PATCH] Tracking statements entry timestamp in pg_stat_statements	Andrei Zubkov	10:37
Re: [PATCH] PREPARE TRANSACTION unexpected behavior with TEMP TABLE	vignesh C	10:40
Re: Why is specifying oids = false multiple times in create table is silently ignored?	Michael Paquier	10:50
hba.c:3160:18: warning: comparison of unsigned enum expression	Erik Rijkers	11:00
Re: hba.c:3160:18: warning: comparison of unsigned enum expression	Magnus Hagander	11:24
Re: WIP: WAL prefetch (another approach) 📎	Thomas Munro	11:24
Re: hba.c:3160:18: warning: comparison of unsigned enum expression 📎	Magnus Hagander	11:32
Re: Set access strategy for parallel vacuum workers	Masahiko Sawada	11:41
Re: MultiXact\SLRU buffers configuration	Andrey Borodin	11:44
Re: Wired if-statement in gen_partprune_steps_internal 📎	David Rowley	11:44
Re: buildfarm instance bichir stuck	Andrew Dunstan	11:49
Re: [PATCH] New default role allowing to change per-role/database settings 📎	Michael Banck	11:53
Re: Yet another fast GiST build	Heikki Linnakangas	11:56
Re: hba.c:3160:18: warning: comparison of unsigned enum expression 📎	Michael Paquier	11:57
Re: hba.c:3160:18: warning: comparison of unsigned enum expression	Magnus Hagander	12:01
[PATCH] Improve treatment of page special and page header alignment during page init. 📎	Pavel Borisov	12:02
Re: Can we remove extra memset in BloomInitPage, GinInitPage and SpGistInitPage when we have it in PageInit?	Pavel Borisov	12:08
Re: Any objections to implementing LogicalDecodeMessageCB for pgoutput?	Euler Taveira	12:09
Need help!	FATIHI Ayoub	12:11
Re: Yet another fast GiST build	Andrey Borodin	12:12
Re: MultiXact\SLRU buffers configuration	Andrey Borodin	12:13
Re: missing documentation for streaming in-progress transactions 📎	Amit Kapila	12:15
Re: hba.c:3160:18: warning: comparison of unsigned enum expression	Michael Paquier	12:17
Re: hba.c:3160:18: warning: comparison of unsigned enum expression	Erik Rijkers	12:18
Re: hba.c:3160:18: warning: comparison of unsigned enum expression	Magnus Hagander	12:20
Re: hba.c:3160:18: warning: comparison of unsigned enum expression	Michael Paquier	12:24
Re: CREATE SEQUENCE with RESTART option	Ashutosh Bapat	12:34
Re: Feature improvement: can we add queryId for pg_catalog.pg_stat_activity view?	Nitin Jadhav	12:45
Re: Feature improvement: can we add queryId for pg_catalog.pg_stat_activity view?	Nitin Jadhav	12:47
Re: Wired if-statement in gen_partprune_steps_internal 📎	Amit Langote	12:49
Re: buildfarm instance bichir stuck	Robins Tharakan	12:55

Browse Archives

Prev | Next