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

July 8, 2021

Thread	Author	Time
Re: row filtering for logical replication	Euler Taveira	00:33
parse_subscription_options - suggested improvements 📎	Peter Smith	00:47
Re: Refactor "mutually exclusive options" error reporting code in parse_subscription_options	Peter Smith	00:53
bugfix: when the blocksize is 32k, the function page_header of pageinspect returns negative numbers. 📎	Quan Zongliang	00:56
Re: row filtering for logical replication 📎	Greg Nancarrow	01:03
Re: [PATCH] expand the units that pg_size_pretty supports on output	David Rowley	01:31
Re: Why ALTER SUBSCRIPTION ... SET (slot_name='none') requires subscription disabled?	Japin Li	02:30
Re: Refactor "mutually exclusive options" error reporting code in parse_subscription_options	Bharath Rupireddy	03:03
Re: Column Filtering in Logical Replication	Peter Smith	03:27
RE: Transactions involving multiple postgres foreign servers, take 2	k.jamison@fujitsu.com	03:27
Re: bugfix: when the blocksize is 32k, the function page_header of pageinspect returns negative numbers.	Bharath Rupireddy	03:42
RE: Added schema level support for publication.	houzj.fnst@fujitsu.com	03:46
Re: More time spending with "delete pending"	Alexander Lakhin	04:00
Re: bugfix: when the blocksize is 32k, the function page_header of pageinspect returns negative numbers.	Michael Paquier	04:15
Re: bugfix: when the blocksize is 32k, the function page_header of pageinspect returns negative numbers.	Justin Pryzby	04:28
Re: [PATCH] expand the units that pg_size_pretty supports on output 📎	David Rowley	04:29
Re: list of extended statistics on psql (\dX)	Tatsuro Yamada	04:46
Re: bugfix: when the blocksize is 32k, the function page_header of pageinspect returns negative numbers.	Tom Lane	04:49
Re: bugfix: when the blocksize is 32k, the function page_header of pageinspect returns negative numbers.	Michael Paquier	05:01
Re: [PoC] Improve dead tuple storage for lazy vacuum	Masahiko Sawada	05:30
Re: visibility map corruption	Drouvot, Bertrand	05:35
Re: [HACKERS] logical decoding of two-phase transactions 📎	Amit Kapila	06:07
Re: Pipeline mode and PQpipelineSync()	Boris Kolpackov	06:12
Re: bugfix: when the blocksize is 32k, the function page_header of pageinspect returns negative numbers.	Daniel Gustafsson	06:23
Failed transaction statistics to measure the logical replication progress 📎	osumi.takamichi@fujitsu.com	06:54
Re: [PATCH] Pull general SASL framework out of SCRAM 📎	Michael Paquier	07:27
Re: A few assorted typos in comments	Michael Paquier	07:37
Re: More time spending with "delete pending"	Michael Paquier	07:47
Re: bugfix: when the blocksize is 32k, the function page_header of pageinspect returns negative numbers.	Michael Paquier	07:54
Re: wrong relkind error messages	Peter Eisentraut	07:54
Re: ERROR: "ft1" is of the wrong type.	Peter Eisentraut	08:02
Re: [PATCH] expand the units that pg_size_pretty supports on output 📎	Dean Rasheed	08:23
Re: rand48 replacement 📎	Fabien COELHO	08:26
Re: Incorrect usage of strtol, atoi for non-numeric junk inputs 📎	Kyotaro Horiguchi	08:30
Re: [PoC] Improve dead tuple storage for lazy vacuum	Masahiko Sawada	08:47
Re: rand48 replacement	Dean Rasheed	09:08
Re: Skipping logical replication transactions on subscriber side	Amit Kapila	09:28
Re: Why ALTER SUBSCRIPTION ... SET (slot_name='none') requires subscription disabled?	Amit Kapila	09:51
Re: bugfix: when the blocksize is 32k, the function page_header of pageinspect returns negative numbers.	Quan Zongliang	10:02
Re: Why ALTER SUBSCRIPTION ... SET (slot_name='none') requires subscription disabled?	Japin Li	10:13
Re: Why ALTER SUBSCRIPTION ... SET (slot_name='none') requires subscription disabled?	Amit Kapila	10:17
Re: Diagnostic comment in LogicalIncreaseXminForSlot	Amit Kapila	10:56
Re: Diagnostic comment in LogicalIncreaseXminForSlot	Daniel Gustafsson	11:14
Re: A few assorted typos in comments	Daniel Gustafsson	11:17
Re: Diagnostic comment in LogicalIncreaseXminForSlot	Masahiko Sawada	11:35
RE: ECPG bug fix: DECALRE STATEMENT and DEALLOCATE, DESCRIBE	kuroda.hayato@fujitsu.com	11:42
Re: [HACKERS] logical decoding of two-phase transactions	vignesh C	12:08
Re: pgbench logging broken by time logic changes 📎	Thomas Munro	12:17
Re: rand48 replacement 📎	Fabien COELHO	12:19
Re: rand48 replacement	Fabien COELHO	12:31
SHA-1 FIPS - compliance	Filip Janus	12:33
Re: [PATCH] expand the units that pg_size_pretty supports on output	David Rowley	12:49
Small documentation improvement for ALTER SUBSCRIPTION 📎	Masahiko Sawada	13:00
Re: visibility map corruption 📎	Bruce Momjian	13:08
Re: visibility map corruption	Justin Pryzby	13:11
Re: Small documentation improvement for ALTER SUBSCRIPTION	Daniel Gustafsson	13:14
Re: [PATCH] expand the units that pg_size_pretty supports on output	David Rowley	13:38
Re: Enhanced error message to include hint messages for redundant options error 📎	vignesh C	13:40
Re: [PoC] Improve dead tuple storage for lazy vacuum	Hannu Krosing	13:40
Re: visibility map corruption 📎	Bruce Momjian	13:51
Re: Pipeline mode and PQpipelineSync()	Alvaro Herrera	13:57
Re: SHA-1 FIPS - compliance	Bruce Momjian	13:58
Re: Teach pg_receivewal to use lz4 compression 📎	gkokolatos	14:18
Re: pgbench logging broken by time logic changes	Hannu Krosing	14:46
Re: pgsql: Don't try to print data type names in slot_store_error_callback(	Robert Haas	14:57
Re: Pipeline mode and PQpipelineSync()	Boris Kolpackov	15:07
Re: visibility map corruption	Drouvot, Bertrand	15:13
Re: pgsql: Don't try to print data type names in slot_store_error_callback(	Tom Lane	15:21
Re: refactoring basebackup.c 📎	Robert Haas	15:56
Re: Replace remaining castNode(…, lfirst(…)) and friends calls with l*_node()	Dagfinn Ilmari Mannsåker	16:23
Add statistics refresh materialized view 📎	Seino Yuki	16:39
enable_resultcache confusion	Bruce Momjian	16:51
Re: pgbench logging broken by time logic changes 📎	Fabien COELHO	17:15
Re: Have I found an interval arithmetic bug?	Zhihong Yu	17:22
Re: pgbench logging broken by time logic changes	Fabien COELHO	17:25
Re: enable_resultcache confusion	Robert Haas	17:29
Re: Pipeline mode and PQpipelineSync()	Alvaro Herrera	17:29
Re: "debug_invalidate_system_caches_always" is too long	Robert Haas	17:33
Re: [PATCH] expand the units that pg_size_pretty supports on output	Dean Rasheed	17:38
Re: enable_resultcache confusion	David G. Johnston	17:52
Re: enable_resultcache confusion	Tom Lane	18:00
Re: enable_resultcache confusion	Daniel Gustafsson	18:01
Re: enable_resultcache confusion	Justin Pryzby	18:03
Re: enable_resultcache confusion	David G. Johnston	18:03
Re: Pipeline mode and PQpipelineSync()	Alvaro Herrera	18:15
Re: Replace remaining castNode(…, lfirst(…)) and friends calls with l*_node()	Alvaro Herrera	18:17
Re: Replace remaining castNode(…, lfirst(…)) and friends calls with l*_node()	Tom Lane	18:26
Re: Pipeline mode and PQpipelineSync()	Boris Kolpackov	18:31
Re: More time spending with "delete pending" 📎	Alexander Lakhin	20:00
Re: "debug_invalidate_system_caches_always" is too long	Tom Lane	20:34
Re: [PoC] Improve dead tuple storage for lazy vacuum	Hannu Krosing	20:53
Re: "debug_invalidate_system_caches_always" is too long	Alvaro Herrera	20:59
Re: [PoC] Improve dead tuple storage for lazy vacuum	Peter Geoghegan	21:20
Re: [PoC] Improve dead tuple storage for lazy vacuum	Peter Geoghegan	22:34
Re: [HACKERS] logical decoding of two-phase transactions	Peter Smith	23:12
Re: [PoC] Improve dead tuple storage for lazy vacuum	Hannu Krosing	23:21
Re: PROXY protocol support	Jacob Champion	23:42

July 9, 2021

Thread	Author	Time
Re: Skipping logical replication transactions on subscriber side	Masahiko Sawada	00:27
Re: Skipping logical replication transactions on subscriber side	Masahiko Sawada	00:42
Re: Inaccurate error message when set fdw batch_size to 0	Fujii Masao	00:55
Re: Outdated replication protocol error?	Andres Freund	01:12
Re: bugfix: when the blocksize is 32k, the function page_header of pageinspect returns negative numbers. 📎	Quan Zongliang	01:26
Re: Incorrect usage of strtol, atoi for non-numeric junk inputs	Michael Paquier	01:29
Re: ERROR: "ft1" is of the wrong type. 📎	Kyotaro Horiguchi	01:44
Re: bugfix: when the blocksize is 32k, the function page_header of pageinspect returns negative numbers.	Michael Paquier	01:50
Re: ERROR: "ft1" is of the wrong type.	Michael Paquier	02:03
Re: Overflow hazard in pgbench	Andres Freund	02:10
Re: Grammar railroad diagram	Andres Freund	02:36
Re: Inaccurate error message when set fdw batch_size to 0 📎	Bharath Rupireddy	02:41
Re: Teach pg_receivewal to use lz4 compression	Michael Paquier	02:49
Re: Why ALTER SUBSCRIPTION ... SET (slot_name='none') requires subscription disabled? 📎	Japin Li	02:49
Re: ECPG bug fix: DECALRE STATEMENT and DEALLOCATE, DESCRIBE	Michael Paquier	02:59
Re: bugfix: when the blocksize is 32k, the function page_header of pageinspect returns negative numbers. 📎	Quan Zongliang	03:11
RE: Added schema level support for publication. 📎	houzj.fnst@fujitsu.com	03:28
Re: Skipping logical replication transactions on subscriber side	Alexey Lesovsky	03:32
Re: [PoC] Improve dead tuple storage for lazy vacuum	Andres Freund	03:53
Re: pgbench logging broken by time logic changes 📎	Thomas Munro	03:53
Re: enable_resultcache confusion	Thomas Munro	04:26
Re: RFC: Logging plan of the running query 📎	torikoshia	05:05
Re: pgbench logging broken by time logic changes	Fabien COELHO	05:14
Re: bugfix: when the blocksize is 32k, the function page_header of pageinspect returns negative numbers.	Michael Paquier	05:16
Re: [PoC] Improve dead tuple storage for lazy vacuum	Andres Freund	05:37
Re: More time spending with "delete pending" 📎	Michael Paquier	05:52
Re: when the startup process doesn't (logging startup delays)	Amul Sul	06:11
Re: Outdated comments about proc->sem in lwlock.c	Thomas Munro	06:15
Re: Transactions involving multiple postgres foreign servers, take 2	Fujii Masao	06:26
Re: [PoC] Improve dead tuple storage for lazy vacuum	Masahiko Sawada	06:35
Re: Added schema level support for publication.	Greg Nancarrow	06:42
[bug] Logical Decoding of relation rewrite with toast does not reset toast_hash 📎	Drouvot, Bertrand	06:51
Re: [HACKERS] logical decoding of two-phase transactions	Ajin Cherian	06:56
Re: [PATCH] expand the units that pg_size_pretty supports on output	David Rowley	07:15
Re: [PoC] Improve dead tuple storage for lazy vacuum	Masahiko Sawada	07:16
psql tab auto-complete for CREATE PUBLICATION 📎	Peter Smith	07:36
Re: Teach pg_receivewal to use lz4 compression	gkokolatos	07:47
Re: Incorrect usage of strtol, atoi for non-numeric junk inputs 📎	Kyotaro Horiguchi	07:50
Re: Grammar railroad diagram	Domingo Alvarez Duarte	07:56
Re: [PoC] Improve dead tuple storage for lazy vacuum	Masahiko Sawada	08:30
Re: [PoC] Improve dead tuple storage for lazy vacuum	Masahiko Sawada	08:36
RE: [HACKERS] logical decoding of two-phase transactions	tanghy.fnst@fujitsu.com	09:33
Support kerberos authentication for postgres_fdw 📎	Peifeng Qiu	09:46
Re: Preventing abort() and exit() calls in libpq	Noah Misch	09:59
Support kerberos authentication for postgres_fdw 📎	Peifeng Qiu	10:13
Re: [PATCH] Automatic HASH and LIST partition creation 📎	Pavel Borisov	10:29
Re: [PATCH] Automatic HASH and LIST partition creation	John Naylor	11:05
Re: "debug_invalidate_system_caches_always" is too long	Noah Misch	11:12
Re: [PATCH] Automatic HASH and LIST partition creation	Pavel Borisov	11:19
Introduce pg_receivewal gzip compression tests 📎	Georgios	11:26
Re: Transactions involving multiple postgres foreign servers, take 2	Masahiko Sawada	11:36
Re: Transactions involving multiple postgres foreign servers, take 2	Masahiko Sawada	11:38
Re: bugfix: when the blocksize is 32k, the function page_header of pageinspect returns negative numbers.	Bharath Rupireddy	11:56
Re: ERROR: "ft1" is of the wrong type. 📎	Kyotaro Horiguchi	12:00
Re: Why ALTER SUBSCRIPTION ... SET (slot_name='none') requires subscription disabled?	Ranier Vilela	12:03
Re: [PATCH] Automatic HASH and LIST partition creation	Robert Haas	13:31
Re: Transactions involving multiple postgres foreign servers, take 2	Masahiko Sawada	13:44
Re: Support kerberos authentication for postgres_fdw	Tom Lane	13:49
Re: [CLOBBER_CACHE]Server crashed with segfault 11 while executing clusterdb 📎	Amul Sul	13:52
Re: [CLOBBER_CACHE]Server crashed with segfault 11 while executing clusterdb	Alvaro Herrera	14:00
Re: Preventing abort() and exit() calls in libpq	Tom Lane	14:06
Re: Fwd: Grammar railroad diagram 📎	grd	14:13
Re: Query about time zone patterns in to_char	Tomas Vondra	14:43
Re: Grammar railroad diagram	Domingo Alvarez Duarte	15:00
short circuit suggestion in find_hash_columns() 📎	Zhihong Yu	15:20
Re: Record a Bitmapset of non-pruned partitions 📎	David Rowley	15:24
Re: short circuit suggestion in find_hash_columns()	David Rowley	15:28
Re: enable_resultcache confusion	David Rowley	15:35
What are exactly bootstrap processes, auxiliary processes, standalone backends, normal backends(user sessions)?	Bharath Rupireddy	15:54
Tab completion for CREATE SCHEMAAUTHORIZATION 📎	Dagfinn Ilmari Mannsåker	16:20
Re: short circuit suggestion in find_hash_columns()	Zhihong Yu	16:49
Re: [PoC] Improve dead tuple storage for lazy vacuum	Andres Freund	17:17
Re: Parallel scan with SubTransGetTopmostTransaction assert coredump	Tomas Vondra	17:36
Re: More time spending with "delete pending"	Alexander Lakhin	18:00
Re: Synchronous commit behavior during network outage	Andrey Borodin	18:10
Re: Query about time zone patterns in to_char	David Zhang	19:17
Re: enable_resultcache confusion	Robert Haas	19:29
Re: standby recovery fails (tablespace related) (tentative patch and discussion)	Ibrar Ahmed	19:37
BUG #17098: Assert failed on composing an error message when adding a type to an extension being dropped	PG Bug reporting form	20:00
Re: Online verification of checksums	Ibrar Ahmed	20:00
Re: when the startup process doesn't (logging startup delays)	Robert Haas	20:00
Re: Preventing abort() and exit() calls in libpq	Noah Misch	20:29
Re: Pre-allocating WAL files 📎	Bossart, Nathan	21:08
Re: pg_dump new feature: exporting functions only. Bad or good idea ? 📎	Tomas Vondra	22:43
Re: [PATCH] Pull general SASL framework out of SCRAM	Jacob Champion	23:31
Re: pg_dump new feature: exporting functions only. Bad or good idea ?	Tom Lane	23:43
Re: pg_dump new feature: exporting functions only. Bad or good idea ?	Justin Pryzby	23:50

July 10, 2021

Thread	Author	Time
Re: [PoC] Improve dead tuple storage for lazy vacuum	Andres Freund	02:55
Re: pgbench logging broken by time logic changes	Thomas Munro	05:54
Re: Grammar railroad diagram	Corey Huinker	06:40
Re: when the startup process doesn't (logging startup delays)	Bharath Rupireddy	08:21
Re: pgbench logging broken by time logic changes	Fabien COELHO	08:25
Re: SQL/JSON: JSON_TABLE 📎	Erik Rijkers	09:07
Re: pgbench logging broken by time logic changes 📎	Fabien COELHO	09:36
Re: Enhanced error message to include hint messages for redundant options error	Dean Rasheed	10:44
Re: Enhanced error message to include hint messages for redundant options error	Dean Rasheed	11:00
Re: pg_dump new feature: exporting functions only. Bad or good idea ?	Tomas Vondra	11:06
Re: bugfix: when the blocksize is 32k, the function page_header of pageinspect returns negative numbers. 📎	Michael Paquier	11:29
Re: Support kerberos authentication for postgres_fdw	Michael Paquier	11:32
Re: EXPLAIN/EXPLAIN ANALYZE REFRESH MATERIALIZED VIEW	John Naylor	11:49
pgsql: Fix numeric_mul() overflow due to too many digits after decimal	Dean Rasheed	11:54
Re: [PoC] Improve dead tuple storage for lazy vacuum	Masahiko Sawada	12:11
Re: [HACKERS] WIP aPatch: Pgbench Serialization and deadlock errors	Tatsuo Ishii	12:54

Browse Archives

Prev | Next