pgsql-hackers since 2021-10-08 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

Oct. 8, 2021

Thread	Author	Time
Re: Time to upgrade buildfarm coverage for some EOL'd OSes?	Thomas Munro	00:17
Re: Question about client_connection_check_interval	Kyotaro Horiguchi	00:56
Re: Question about client_connection_check_interval	Kyotaro Horiguchi	00:59
Re: Role Self-Administration	Stephen Frost	02:44
Re: pgsql: Adjust configure to insist on Perl version >= 5.8.3.	Noah Misch	02:56
Re: Lost logs with csvlog redirected to stderr under WIN32 service	Michael Paquier	02:57
Re: storing an explicit nonce	Stephen Frost	03:05
RE: [BUG] Logical replication failure "ERROR: could not map filenode "base/13237/442428" to relation OID" with catalog modifying txns	[email protected]	03:07
Re: Add jsonlog log_destination for JSON server logs 📎	Michael Paquier	03:28
Re: pg_dump does not dump tables created in information_schema schema	vignesh C	03:29
Re: storing an explicit nonce	Stephen Frost	03:32
Re: pgsql: Adjust configure to insist on Perl version >= 5.8.3.	Tom Lane	03:39
Re: Add client connection check during the execution of the query	Thomas Munro	03:43
Re: [BUG] Unexpected action when publishing partition tables	Amit Kapila	03:47
Re: Add client connection check during the execution of the query	Zhihong Yu	03:57
Re: pgsql: Adjust configure to insist on Perl version >= 5.8.3.	Noah Misch	04:24
GIN pending list cleanup during autoanalyze blocks cleanup by VACUUM	Peter Geoghegan	05:34
Re: libpq compression 📎	Daniil Zakhlystov	05:46
Re: storing an explicit nonce	Antonin Houska	06:35
Re: should we allow users with a predefined role to access pg_backend_memory_contexts view and pg_log_backend_memory_contexts function?	Bharath Rupireddy	07:00
Re: PATCH: psql tab completion for SELECT 📎	David Fetter	07:01
RE: Skipping logical replication transactions on subscriber side	[email protected]	07:09
Improve the HINT message of the ALTER command for postgres_fdw 📎	bt21masumurak	07:18
Re: More business with $Test::Builder::Level in the TAP tests	Daniel Gustafsson	07:28
Re: Logical replication timeout problem	Fabrice Chapuis	07:33
Re: Improve the HINT message of the ALTER command for postgres_fdw	Bharath Rupireddy	07:38
Re: [BUG] Logical replication failure "ERROR: could not map filenode "base/13237/442428" to relation OID" with catalog modifying txns	Kyotaro Horiguchi	07:50
Re: More business with $Test::Builder::Level in the TAP tests	Michael Paquier	07:51
Re: pgsql: Adjust configure to insist on Perl version >= 5.8.3.	Daniel Gustafsson	08:03
Re: More business with $Test::Builder::Level in the TAP tests	Daniel Gustafsson	08:06
Re: Map WAL segment files on PMEM as WAL buffers	Takashi Menjo	08:07
Re: Improve the HINT message of the ALTER command for postgres_fdw	Daniel Gustafsson	08:13
RFC: compression dictionaries for JSONB	Aleksander Alekseev	09:47
Re: Add ZSON extension to /contrib/	Aleksander Alekseev	09:51
Re: Capitalization of localized month and day names (to_char() with 'TMmonth', 'TMday', etc.)	Magnus Holmgren	10:05
Reword docs of feature "Remove temporary files after backend crash"	Bharath Rupireddy	10:57
Re: Added schema level support for publication.	Amit Kapila	11:04
logical decoding/replication: new functions pg_ls_logicaldir and pg_ls_replslotdir	Bharath Rupireddy	11:09
Re: Skipping logical replication transactions on subscriber side	Greg Nancarrow	11:17
Re: psql - add SHOW_ALL_RESULTS option 📎	Peter Eisentraut	12:15
RE: Skipping logical replication transactions on subscriber side	[email protected]	12:22
Re: document the need to analyze partitioned tables 📎	Justin Pryzby	12:58
Re: Time to upgrade buildfarm coverage for some EOL'd OSes?	Mikael Kjellström	13:08
Re: Compressing temporary files	Bharath Rupireddy	13:47
Re: RFC: compression dictionaries for JSONB	Matthias van de Meent	14:12
Re: dfmgr additional ABI version fields	Peter Eisentraut	14:54
Re: Parallel vacuum workers prevent the oldest xmin from advancing	Alvaro Herrera	15:13
Re: RFC: compression dictionaries for JSONB	Alvaro Herrera	15:19
Re: Fix pg_log_backend_memory_contexts() 's delay	Fujii Masao	15:28
Re: pgbench bug candidate: negative "initial connection time" 📎	Fujii Masao	15:41
Re: pgsql: Adjust configure to insist on Perl version >= 5.8.3.	Tom Lane	16:03
Re: Time to upgrade buildfarm coverage for some EOL'd OSes?	Tom Lane	16:12
Re: More business with $Test::Builder::Level in the TAP tests	Andrew Dunstan	16:14
Re: Time to upgrade buildfarm coverage for some EOL'd OSes?	Mikael Kjellström	16:55
Re: should we allow users with a predefined role to access pg_backend_memory_contexts view and pg_log_backend_memory_contexts function? 📎	Bossart, Nathan	17:11
Re: RFC: compression dictionaries for JSONB	Matthias van de Meent	17:17
Re: Parallel vacuum workers prevent the oldest xmin from advancing	Peter Geoghegan	17:21
Query rewrite(optimization) using constraints	Lily Liu	17:24
Re: pg_stat_bgwriter.buffers_backend is pretty meaningless (and more?)	Andres Freund	17:56
ERROR: unexpected duplicate for tablespace 16389, relfilenode 484036	Max Shore	18:00
Re: Query rewrite(optimization) using constraints	Justin Pryzby	18:01
Re: Query rewrite(optimization) using constraints	Tom Lane	18:17
Re: storing an explicit nonce	Stephen Frost	18:34
Re: should we allow users with a predefined role to access pg_backend_memory_contexts view and pg_log_backend_memory_contexts function?	Stephen Frost	19:15
Re: RFC: compression dictionaries for JSONB	Alvaro Herrera	19:21
Re: Time to upgrade buildfarm coverage for some EOL'd OSes?	Thomas Munro	19:40
Re: Running tests under valgrind is getting slower at an alarming pace	Andrew Dunstan	19:41
Re: Pre-allocating WAL files 📎	Bossart, Nathan	20:48
Re: Running tests under valgrind is getting slower at an alarming pace	Andres Freund	21:16
Re: should we allow users with a predefined role to access pg_backend_memory_contexts view and pg_log_backend_memory_contexts function?	Bharath Rupireddy	22:26
Re: Role Self-Administration	Mark Dilger	22:30

Oct. 9, 2021

Thread	Author	Time
Re: [Proposal] Global temporary tables 📎	wenjing	07:41
starts_with, ^@ and index usage	Shay Rojansky	08:01
Re: should we allow users with a predefined role to access pg_backend_memory_contexts view and pg_log_backend_memory_contexts function? 📎	Bharath Rupireddy	09:11
Re: RFC: compression dictionaries for JSONB	Matthias van de Meent	12:49
Inconsistency in startup process's MyBackendId and procsignal array registration with ProcSignalInit()	Bharath Rupireddy	13:22
enhance pg_log_backend_memory_contexts() to log memory contexts of auxiliary processes	Bharath Rupireddy	13:23
Re: Fix pg_log_backend_memory_contexts() 's delay	Bharath Rupireddy	13:26
Re: starts_with, ^@ and index usage	Tom Lane	14:44
Re: Reword docs of feature "Remove temporary files after backend crash" 📎	Bharath Rupireddy	15:48
Re: Reword docs of feature "Remove temporary files after backend crash"	Justin Pryzby	16:12
Re: Reword docs of feature "Remove temporary files after backend crash"	Bharath Rupireddy	16:25
Add planner support function for starts_with() 📎	Tom Lane	17:23
Re: starts_with, ^@ and index usage	Tom Lane	17:59
Re: pgsql: Adjust configure to insist on Perl version >= 5.8.3.	Noah Misch	19:23
Re: pgsql: Adjust configure to insist on Perl version >= 5.8.3. 📎	Tom Lane	19:44
Re: pgsql: Adjust configure to insist on Perl version >= 5.8.3.	Noah Misch	19:59
Re: pgsql: Adjust configure to insist on Perl version >= 5.8.3.	Tom Lane	20:34
Proposal: allow database-specific role memberships 📎	Kenaniah Cerny	23:13
ldap/t/001_auth.pl fails with openldap 2.5	Andres Freund	23:38

Oct. 10, 2021

Thread	Author	Time
Re: GIN pending list cleanup during autoanalyze blocks cleanup by VACUUM	Peter Geoghegan	00:51
Re: pgsql: Adjust configure to insist on Perl version >= 5.8.3.	Noah Misch	02:25
Re: Reword docs of feature "Remove temporary files after backend crash"	Fujii Masao	03:42
Re: ldap/t/001_auth.pl fails with openldap 2.5	Tom Lane	04:45
Re: Transactions involving multiple postgres foreign servers, take 2	Etsuro Fujita	08:12
Re: More business with $Test::Builder::Level in the TAP tests	Michael Paquier	11:18
Re: Time to upgrade buildfarm coverage for some EOL'd OSes?	Peter Eisentraut	12:51
Re: Reword docs of feature "Remove temporary files after backend crash"	Bharath Rupireddy	13:33
Re: Skipping logical replication transactions on subscriber side	Peter Eisentraut	14:04
Re: Rewriting the test of pg_upgrade as a TAP test - take three - remastered set	Peter Eisentraut	14:07
Re: Bug in DefineRange() with multiranges	Peter Eisentraut	17:12
Re: pgsql: Adjust configure to insist on Perl version >= 5.8.3. 📎	Tom Lane	17:17
Re: Time to upgrade buildfarm coverage for some EOL'd OSes?	Mikael Kjellström	17:25
Re: Time to upgrade buildfarm coverage for some EOL'd OSes?	Tom Lane	18:00
Re: Time to upgrade buildfarm coverage for some EOL'd OSes?	Mikael Kjellström	18:04
Re: pgsql: Adjust configure to insist on Perl version >= 5.8.3. 📎	Tom Lane	18:42
Re: Adding CI to our tree	Peter Eisentraut	19:48
Re: pgsql: Adjust configure to insist on Perl version >= 5.8.3.	Noah Misch	19:55
Re: pgsql: Adjust configure to insist on Perl version >= 5.8.3.	Tom Lane	20:10
Re: Adding CI to our tree	Andres Freund	20:22
Re: [PATCH] Don't block HOT update by BRIN index	Josef Šimánek	21:36
Re: pgsql: Adjust configure to insist on Perl version >= 5.8.3.	Noah Misch	23:43
Re: Proposal: allow database-specific role memberships	David G. Johnston	23:45
RE: Question about client_connection_check_interval	[email protected]	23:51

Oct. 11, 2021

Thread	Author	Time
Re: Parallel vacuum workers prevent the oldest xmin from advancing	Masahiko Sawada	00:23
Re: Rewriting the test of pg_upgrade as a TAP test - take three - remastered set	Michael Paquier	00:40
Re: strange case of "if ((a & b))"	Michael Paquier	00:45
Re: Parallel vacuum workers prevent the oldest xmin from advancing	Michael Paquier	00:50
Re: strange case of "if ((a & b))"	Masahiko Sawada	01:21
RE: Added schema level support for publication.	[email protected]	02:16
Re: Skipping logical replication transactions on subscriber side	Masahiko Sawada	02:51
Re: enhance pg_log_backend_memory_contexts() to log memory contexts of auxiliary processes	torikoshia	02:51
Re: enhance pg_log_backend_memory_contexts() to log memory contexts of auxiliary processes	Bharath Rupireddy	04:25
is possible an remote access to some macos?	Pavel Stehule	04:31
Re: Fix pg_log_backend_memory_contexts() 's delay	torikoshia	05:28
Re: Multi-Column List Partitioning	Rajkumar Raghuwanshi	05:35
Re: pg_upgrade test for binary compatibility of core data types 📎	Michael Paquier	05:38
Re: Fix pg_log_backend_memory_contexts() 's delay 📎	Fujii Masao	05:40
Re: Parallel vacuum workers prevent the oldest xmin from advancing	Greg Nancarrow	06:01
Re: VS2022: Support Visual Studio 2022 on Windows	Michael Paquier	06:03
Re: Reword docs of feature "Remove temporary files after backend crash"	Fujii Masao	06:07
Re: Added schema level support for publication. 📎	vignesh C	06:16
Error "initial slot snapshot too large" in create replication slot 📎	Dilip Kumar	06:19
Re: Inconsistency in startup process's MyBackendId and procsignal array registration with ProcSignalInit()	Fujii Masao	06:24
Re: [BUG] Logical replication failure "ERROR: could not map filenode "base/13237/442428" to relation OID" with catalog modifying txns 📎	Masahiko Sawada	06:27
Re: Added schema level support for publication. 📎	vignesh C	06:39
Re: Added schema level support for publication.	vignesh C	07:03
Re: Added schema level support for publication.	vignesh C	07:05
Re: Inconsistency in startup process's MyBackendId and procsignal array registration with ProcSignalInit()	Kyotaro Horiguchi	07:11
RE: Added schema level support for publication.	[email protected]	07:20
Re: Reword docs of feature "Remove temporary files after backend crash"	Bharath Rupireddy	07:20
RE: Skipping logical replication transactions on subscriber side	[email protected]	07:27
Re: Skipping logical replication transactions on subscriber side	Masahiko Sawada	07:30
Re: Added schema level support for publication.	Greg Nancarrow	07:51
Drop replslot after pgstat_shutdown cause assert coredump	[email protected]	07:55
postgres_fdw: misplaced? comments in connection.c	Etsuro Fujita	08:05
Re: Time to upgrade buildfarm coverage for some EOL'd OSes?	Magnus Hagander	08:20
Re: storing an explicit nonce	Sasasu	08:34
Re: Reword docs of feature "Remove temporary files after backend crash"	Justin Pryzby	09:23
Re: [BUG] Logical replication failure "ERROR: could not map filenode "base/13237/442428" to relation OID" with catalog modifying txns	Drouvot, Bertrand	09:44
Re: Reword docs of feature "Remove temporary files after backend crash"	Bharath Rupireddy	09:59
Re: EXPLAIN(VERBOSE) to CTE with SEARCH BREADTH FIRST fails	Markus Winand	10:22
Re: Inconsistency in startup process's MyBackendId and procsignal array registration with ProcSignalInit()	Bharath Rupireddy	10:33
Re: Multi-Column List Partitioning	Rajkumar Raghuwanshi	10:42
Re: Inconsistency in startup process's MyBackendId and procsignal array registration with ProcSignalInit()	Bharath Rupireddy	10:46
Re: Error "initial slot snapshot too large" in create replication slot	Kyotaro Horiguchi	10:59
Re: Error "initial slot snapshot too large" in create replication slot	Dilip Kumar	11:18
Re: Rewriting the test of pg_upgrade as a TAP test - take three - remastered set	Andrew Dunstan	13:04
Re: Drop replslot after pgstat_shutdown cause assert coredump	Greg Nancarrow	13:15
Re: RFC: compression dictionaries for JSONB	Aleksander Alekseev	13:25
Re: Double partition lock in bufmgr	Yura Sokolov	13:31
Re: Add client connection check during the execution of the query	Maksim Milyutin	14:10
Re: Time to upgrade buildfarm coverage for some EOL'd OSes?	Mikael Kjellström	14:15
Re: automatically generating node support functions 📎	Peter Eisentraut	14:22
Re: EXPLAIN(VERBOSE) to CTE with SEARCH BREADTH FIRST fails	Peter Eisentraut	14:27
Re: EXPLAIN(VERBOSE) to CTE with SEARCH BREADTH FIRST fails	Markus Winand	14:32
Re: row filtering for logical replication	Dilip Kumar	14:37
Corruption with IMMUTABLE functions in index expression.	Prabhat Sahu	14:44
Re: More business with $Test::Builder::Level in the TAP tests	Andrew Dunstan	14:48
Re: EXPLAIN(VERBOSE) to CTE with SEARCH BREADTH FIRST fails	Tom Lane	14:57
Re: pgsql: Adjust configure to insist on Perl version >= 5.8.3.	Andrew Dunstan	14:57
Re: Added schema level support for publication.	vignesh C	14:59
Re: Proposal: allow database-specific role memberships	Stephen Frost	15:00
Re: Added schema level support for publication. 📎	vignesh C	15:01
Re: pgsql: Adjust configure to insist on Perl version >= 5.8.3.	Tom Lane	15:03
Re: Proposal: allow database-specific role memberships	Isaac Morland	15:15
Reset snapshot export state on the transaction abort 📎	Dilip Kumar	15:16
BUG #17220: ALTER INDEX ALTER COLUMN SET (..) with an optionless opclass makes index and table unusable	PG Bug reporting form	15:25
Re: Inconsistency in startup process's MyBackendId and procsignal array registration with ProcSignalInit() 📎	Fujii Masao	15:29
Re: Proposal: allow database-specific role memberships	David G. Johnston	15:44
Re: Corruption with IMMUTABLE functions in index expression.	David G. Johnston	15:47
Re: Proposal: allow database-specific role memberships	Stephen Frost	16:05
Re: Corruption with IMMUTABLE functions in index expression.	Andrey Borodin	16:08
Re: Corruption with IMMUTABLE functions in index expression.	Tomas Vondra	16:26
Re: Corruption with IMMUTABLE functions in index expression.	Tom Lane	16:27
Re: Returning to Postgres community work	Rushabh Lathia	16:34
Re: Corruption with IMMUTABLE functions in index expression.	Tom Lane	16:36
Re: Corruption with IMMUTABLE functions in index expression.	Peter Geoghegan	16:37
Re: BUG #17212: pg_amcheck fails on checking temporary relations 📎	Mark Dilger	16:53
Re: storing an explicit nonce	Bruce Momjian	16:56
Re: storing an explicit nonce	Stephen Frost	17:01
Re: storing an explicit nonce	Bruce Momjian	17:07
Re: storing an explicit nonce	Bruce Momjian	17:09
Re: BUG #17212: pg_amcheck fails on checking temporary relations	Peter Geoghegan	17:10
Re: storing an explicit nonce	Stephen Frost	17:30
Re: RFC: compression dictionaries for JSONB	Matthias van de Meent	17:39
Re: BUG #17212: pg_amcheck fails on checking temporary relations	Mark Dilger	17:46
Re: BUG #17220: ALTER INDEX ALTER COLUMN SET (..) with an optionless opclass makes index and table unusable	Vik Fearing	18:03
Re: BUG #17212: pg_amcheck fails on checking temporary relations	Peter Geoghegan	18:12
Re: Corruption with IMMUTABLE functions in index expression.	Andres Freund	18:25

Browse Archives

Prev | Next