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

Sept. 9, 2021

Thread	Author	Time
Regression in PG14 LookupFuncName	Sven Klemm	00:01
Re: Regression in PG14 LookupFuncName	Tom Lane	00:13
Re: Estimating HugePages Requirements?	Michael Paquier	01:09
Re: pg_stat_bgwriter.buffers_backend is pretty meaningless (and more?) 📎	Melanie Plageman	01:28
Re: [PATCH] test/ssl: rework the sslfiles Makefile target	Michael Paquier	01:32
RE: Parallel Inserts (WAS: [bug?] Missed parallel safety checks..) 📎	[email protected]	02:12
Re: Add jsonlog log_destination for JSON server logs 📎	Michael Paquier	02:17
Re: drop tablespace failed when location contains .. on win32	Michael Paquier	02:19
RE: drop tablespace failed when location contains .. on win32	[email protected]	02:35
Re: Add jsonlog log_destination for JSON server logs	Greg Stark	02:58
Re: drop tablespace failed when location contains .. on win32	Michael Paquier	03:44
Re: Add jsonlog log_destination for JSON server logs	Michael Paquier	03:58
Re: Estimating HugePages Requirements?	Michael Paquier	04:19
Re: PG Docs - CREATE SUBSCRIPTION option list order 📎	Amit Kapila	04:20
Re: Estimating HugePages Requirements? 📎	Michael Paquier	04:23
Re: strange case of "if ((a & b))"	Michael Paquier	04:28
Re: drop tablespace failed when location contains .. on win32	Kyotaro Horiguchi	04:34
Re: Schema variables - new implementation for Postgres 15 📎	Pavel Stehule	04:59
Re: strange case of "if ((a & b))"	Kyotaro Horiguchi	05:14
Re: Improve logging when using Huge Pages	Kyotaro Horiguchi	05:34
Re: [PROPOSAL] new diagnostic items for the dynamic sql	Pavel Stehule	05:37
Show redo LSN in checkpoint logs 📎	Kyotaro Horiguchi	05:58
Re: row filtering for logical replication 📎	Peter Smith	06:13
Re: [PROPOSAL] new diagnostic items for the dynamic sql	Dinesh Chemuduru	06:23
missing warning in pg_import_system_collations 📎	Anton Voloshin	06:45
Re: Added schema level support for publication.	Amit Kapila	06:53
Re: Allow escape in application_name	Fujii Masao	07:11
Re: Minimal logical decoding on standbys	Drouvot, Bertrand	07:17
Re: Remove Value node struct	Peter Eisentraut	07:23
Re: [PROPOSAL] new diagnostic items for the dynamic sql	Pavel Stehule	07:39
RE: Failed transaction statistics to measure the logical replication progress 📎	[email protected]	08:03
Re: row filtering for logical replication	Amit Kapila	09:10
Re: Proposal: More structured logging	Ronan Dunklau	09:15
回复：Queries that should be canceled will get stuck on secure_write function 📎	蔡梦娟 (玊于)	09:38
Re: [PATCH] Proof of concept for GUC improvements	Aleksander Alekseev	09:48
Re: Asymmetric partition-wise JOIN	Aleksander Alekseev	09:50
Re: Regression in PG14 LookupFuncName	Sven Klemm	10:02
Re: EXPLAIN(VERBOSE) to CTE with SEARCH BREADTH FIRST fails	Peter Eisentraut	10:03
Re: Schema variables - new implementation for Postgres 15	Erik Rijkers	10:21
Re: Schema variables - new implementation for Postgres 15	Pavel Stehule	10:40
Re: [UNVERIFIED SENDER] Re: [BUG] Failed Assertion in ReorderBufferChangeMemoryUpdate() 📎	Amit Kapila	11:16
Re: Schema variables - new implementation for Postgres 15	Gilles Darold	11:17
TAP test for recovery_end_command 📎	Amul Sul	11:18
Re: missing warning in pg_import_system_collations	Ranier Vilela	11:46
trap instead of error on 32 TiB table	Christoph Berg	11:52
Re: Why does bootstrap and later initdb stages happen via client?	Peter Eisentraut	12:11
Re: drop tablespace failed when location contains .. on win32	Andrew Dunstan	12:30
Re: create table like: ACCESS METHOD	Peter Eisentraut	12:30
RE: Allow escape in application_name 📎	[email protected]	12:36
Re: [BUG] Failed Assertion in ReorderBufferChangeMemoryUpdate() 📎	Drouvot, Bertrand	13:16
Re: trap instead of error on 32 TiB table	Robert Haas	13:30
Re: Use generation context to speed up tuplesorts 📎	Tomas Vondra	13:37
Re: trap instead of error on 32 TiB table	Tom Lane	13:44
Re: trap instead of error on 32 TiB table	Christoph Berg	14:04
Re: Non-decimal integer literals	Vik Fearing	14:08
Re: trap instead of error on 32 TiB table	Tom Lane	14:25
Re: Skipping logical replication transactions on subscriber side 📎	Masahiko Sawada	14:32
Re: Queries that should be canceled will get stuck on secure_write function	Robert Haas	14:39
Re: missing warning in pg_import_system_collations	Tom Lane	14:51
Re: Migração Postgresql 8.3 para versão Postgresql 9.3	Robert Haas	14:51
Re: POC: Cleaning up orphaned files using undo logs 📎	Antonin Houska	15:04
Re: Possible missing segments in archiving on standby 📎	Fujii Masao	15:09
Re: missing warning in pg_import_system_collations	Anton Voloshin	15:17
Re: Asymmetric partition-wise JOIN 📎	Jaime Casanova	15:38
Re: BUG #16583: merge join on tables with different DB collation behind postgres_fdw fails 📎	Etsuro Fujita	15:45
Re: Why does bootstrap and later initdb stages happen via client?	Andrew Dunstan	15:52
Re: BUG #16583: merge join on tables with different DB collation behind postgres_fdw fails	Tom Lane	16:00
Re: Schema variables - new implementation for Postgres 15	Pavel Stehule	16:11
Re: Avoid stuck of pbgench due to skipped transactions	Fujii Masao	16:30
We don't enforce NO SCROLL cursor restrictions	Tom Lane	17:10
Re: [Patch] ALTER SYSTEM READ ONLY	Mark Dilger	17:42
Re: We don't enforce NO SCROLL cursor restrictions	Vik Fearing	17:47
Re: We don't enforce NO SCROLL cursor restrictions	Tom Lane	18:09
Re: [Patch] ALTER SYSTEM READ ONLY	Robert Haas	18:21
Re: Feedback on table expansion hook (including patch)	Jaime Casanova	18:26
Re: missing warning in pg_import_system_collations	Tom Lane	18:37
Re: [Patch] ALTER SYSTEM READ ONLY	Mark Dilger	18:49
Re: We don't enforce NO SCROLL cursor restrictions	Tom Lane	19:21
Re: trap instead of error on 32 TiB table	Heikki Linnakangas	19:54
Re: Estimating HugePages Requirements? 📎	Bossart, Nathan	21:53
Re: .ready and .done files considered harmful	Bossart, Nathan	22:24
Re: parallelizing the archiver	Bossart, Nathan	22:30
Re: pg_walinspect - a new extension to get raw WAL data and WAL stats	Bossart, Nathan	22:49
Re: We don't enforce NO SCROLL cursor restrictions 📎	Tom Lane	22:54
Re: PROXY protocol support	Jacob Champion	23:44
Re: refactoring basebackup.c 📎	Robert Haas	23:55

Sept. 10, 2021

Thread	Author	Time
Re: Allow escape in application_name	Fujii Masao	00:23
Re: Add jsonlog log_destination for JSON server logs 📎	Michael Paquier	01:07
Re: corruption of WAL page header is never reported 📎	Fujii Masao	01:38
Re: pg_walinspect - a new extension to get raw WAL data and WAL stats	Michael Paquier	01:51
Re: Estimating HugePages Requirements?	Michael Paquier	02:03
Re: Estimating HugePages Requirements?	Bossart, Nathan	02:26
RE: Added schema level support for publication. 📎	[email protected]	02:33
Re: ExecRTCheckPerms() and many prunable partitions 📎	Amit Langote	03:22
RE: Added schema level support for publication. 📎	[email protected]	03:23
RE: Allow escape in application_name 📎	[email protected]	03:24
RE: Allow escape in application_name	[email protected]	03:35
Re: Add jsonlog log_destination for JSON server logs	Michael Paquier	04:07
RE: Allow escape in application_name 📎	[email protected]	04:33
Re: stat() vs ERROR_DELETE_PENDING, round N + 1 📎	Thomas Munro	05:04
Re: parallelizing the archiver	Julien Rouhaud	05:08
Re: Added schema level support for publication.	Amit Kapila	05:10
Re: Toast compression method options	Jaime Casanova	05:10
Re: Toast compression method options	Dilip Kumar	05:24
Re: parallelizing the archiver	Andrey Borodin	05:28
RE: Added schema level support for publication. 📎	[email protected]	05:51
Re: parallelizing the archiver	Julien Rouhaud	05:52
Re: parallelizing the archiver	Andrey Borodin	06:03
Re: parallelizing the archiver	Julien Rouhaud	06:11
Re: parallelizing the archiver	Andrey Borodin	06:29
pgsql: Revoke PUBLIC CREATE from public schema, now owned by pg_databas	Noah Misch	06:39
Re: missing warning in pg_import_system_collations	Anton Voloshin	06:47
Re: Add jsonlog log_destination for JSON server logs 📎	Michael Paquier	06:56
Re: pg_walinspect - a new extension to get raw WAL data and WAL stats	Drouvot, Bertrand	07:04
Re: Schema variables - new implementation for Postgres 15 📎	Pavel Stehule	08:06
Re: Teach pg_receivewal to use lz4 compression 📎	gkokolatos	08:21
Re: Schema variables - new implementation for Postgres 15	Erik Rijkers	08:32
Re: Schema variables - new implementation for Postgres 15	Pavel Stehule	08:51
The End of the WAL	Christoph Berg	10:06
Re: BUG #16583: merge join on tables with different DB collation behind postgres_fdw fails	Etsuro Fujita	11:42
Re: Skipping logical replication transactions on subscriber side	Greg Nancarrow	11:46
Re: parallelizing the archiver	Robert Haas	13:13
RE: Support tab completion for upper character inputs in psql 📎	[email protected]	13:50
Re: a misbehavior of partition row movement (?) 📎	Amit Langote	14:03
Re: EXPLAIN(VERBOSE) to CTE with SEARCH BREADTH FIRST fails 📎	torikoshia	14:10
Re: parallelizing the archiver	Julien Rouhaud	14:19
Re: pg_walinspect - a new extension to get raw WAL data and WAL stats	Bharath Rupireddy	14:29
Re: [Patch] ALTER SYSTEM READ ONLY	Amul Sul	14:36
Re: Increase value of OUTER_VAR	Aleksander Alekseev	14:44
Re: parallelizing the archiver	Robert Haas	15:22
Re: [Patch] ALTER SYSTEM READ ONLY	Mark Dilger	15:42
Re: a misbehavior of partition row movement (?)	Zhihong Yu	15:48
Re: parallelizing the archiver	Julien Rouhaud	15:48
Re: parallelizing the archiver	Andrey Borodin	15:55
Re: [Patch] ALTER SYSTEM READ ONLY	Mark Dilger	16:20
Re: Toast compression method options	Jaime Casanova	16:24
Re: [Patch] ALTER SYSTEM READ ONLY	Robert Haas	16:56
Re: parallelizing the archiver	Bossart, Nathan	17:06
Re: parallelizing the archiver	Jacob Champion	17:07
Re: parallelizing the archiver	Robert Haas	17:09
incorrect file name in backend_progress.c header 📎	Zhihong Yu	17:11
Re: [Patch] ALTER SYSTEM READ ONLY	Mark Dilger	17:16
Re: parallelizing the archiver	Bossart, Nathan	17:18
Re: Numeric x^y for negative x	Jaime Casanova	17:31
Re: parallelizing the archiver	Robert Haas	17:42
Re: [Patch] ALTER SYSTEM READ ONLY	Robert Haas	17:48
Re: incorrect file name in backend_progress.c header	Justin Pryzby	17:56
Re: incorrect file name in backend_progress.c header	Zhihong Yu	18:07
Re: incorrect file name in backend_progress.c header 📎	Zhihong Yu	18:15
Re: incorrect file name in backend_progress.c header	Justin Pryzby	18:20
Re: incorrect file name in backend_progress.c header 📎	Zhihong Yu	18:28
Re: WIP: System Versioned Temporal Table	Jaime Casanova	18:30
Re: parallelizing the archiver	Andrey Borodin	18:34
Re: extensible options syntax for replication parser? 📎	Robert Haas	19:44
Re: Estimating HugePages Requirements?	Robert Haas	20:01
Remove_temp_files_after_crash and significant recovery/startup time	McCoy, Shawn	20:58
Re: slab allocator performance issues 📎	Tomas Vondra	21:06
Re: ORDER BY pushdowns seem broken in postgres_fdw	David Zhang	21:23
Re: Remove_temp_files_after_crash and significant recovery/startup time	Tom Lane	21:32
Re: Remove_temp_files_after_crash and significant recovery/startup time	Tomas Vondra	21:57
Re: Remove_temp_files_after_crash and significant recovery/startup time	Euler Taveira	22:10
Re: pg_stat_bgwriter.buffers_backend is pretty meaningless (and more?)	Melanie Plageman	22:16
Re: Estimating HugePages Requirements?	Bossart, Nathan	23:43

Sept. 11, 2021

Thread	Author	Time
Re: SQL:2011 application time	Jaime Casanova	01:50
Re: Signed vs Unsigned (take 2) (src/backend/storage/ipc/procarray.c)	Fujii Masao	03:21
Re: [Proposal] Fully WAL logged CREATE DATABASE - No Checkpoints	Dilip Kumar	04:17
Re: Teach pg_receivewal to use lz4 compression	Jian Guo	05:02
Re: strange case of "if ((a & b))"	Michael Paquier	05:44
Re: 2021-09 Commitfest	Jaime Casanova	05:52
Re: Polyphase merge is obsolete	Jaime Casanova	06:35
Remove duplicate static function check_permissions in slotfuncs.c and logicalfuncs.c 📎	Bharath Rupireddy	08:28
Re: Polyphase merge is obsolete	Zhihong Yu	08:28
Compressing temporary files	Andrey Borodin	12:31
Re: missing warning in pg_import_system_collations 📎	Tom Lane	16:19
Re: Increase value of OUTER_VAR 📎	Tom Lane	17:37
Re: Increase value of OUTER_VAR	Tom Lane	17:42
new regexp_*(text, text, int) functions crash	Jaime Casanova	18:03
Re: pg_upgrade test for binary compatibility of core data types	Tom Lane	18:19
Re: Added missing invalidations for all tables publication	Tom Lane	18:28
Re: new regexp_*(text, text, int) functions crash	Tom Lane	18:42
Re: BUG #15293: Stored Procedure Triggered by Logical Replication is Unable to use Notification Events 📎	Artur Zakirov	19:55
Re: 2021-09 Commitfest	Aleksander Alekseev	20:58
Re: BUG #15293: Stored Procedure Triggered by Logical Replication is Unable to use Notification Events	Tom Lane	22:16

Sept. 12, 2021

Thread	Author	Time
Re: pg_upgrade test for binary compatibility of core data types 📎	Justin Pryzby	00:51
Re: Schema variables - new implementation for Postgres 15	Jaime Casanova	02:13
Confusing messages about index row size	Jaime Casanova	05:50
Re: Confusing messages about index row size	David G. Johnston	06:03
RE: drop tablespace failed when location contains .. on win32 📎	[email protected]	07:33
Doc: Extra type info on postgres-fdw option import_generated in back branches 📎	Etsuro Fujita	08:44
Private Information Retrieval (PIR) as a C/C++ Aggregate Extension	Private Information Retrieval(PIR)	13:02
Re: [PATCH] regexp_positions ( string text, pattern text, flags text ) → setof int4range[] 📎	Joel Jacobson	13:54
Re: Added schema level support for publication. 📎	vignesh C	15:13
Re: Schema variables - new implementation for Postgres 15 📎	Pavel Stehule	15:38
Re: Schema variables - new implementation for Postgres 15	Pavel Stehule	15:45
Re: WIP: System Versioned Temporal Table	Simon Riggs	16:02
Re: Schema variables - new implementation for Postgres 15	Jaime Casanova	16:26
Re: Remove duplicate static function check_permissions in slotfuncs.c and logicalfuncs.c	Euler Taveira	16:46
Re: Private Information Retrieval (PIR) as a C/C++ Aggregate Extension	Andrey Borodin	17:00
Re: Schema variables - new implementation for Postgres 15	Pavel Stehule	17:15
Re: BUG #15293: Stored Procedure Triggered by Logical Replication is Unable to use Notification Events 📎	Tom Lane	17:29

Browse Archives

Prev | Next