pgsql-hackers before 2023-09-16 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. 13, 2023

Thread	Author	Time
Re: Is the member name of hashctl inappropriate？	ywgrit	06:00
Have better wording for snapshot file reading failure 📎	Bharath Rupireddy	06:10
Re: Have better wording for snapshot file reading failure	Michael Paquier	06:18
Re: persist logical slots to disk during shutdown checkpoint	Amit Kapila	06:37
Re: pg_upgrade and logical replication	Michael Paquier	06:37
[dynahash] do not refill the hashkey after hash_search 📎	Junwang Zhao	06:46
Re: pg_ctl start may return 0 even if the postmaster has been already started on Windows 📎	Kyotaro Horiguchi	06:52
Re: persist logical slots to disk during shutdown checkpoint	Michael Paquier	07:14
Re: pg_upgrade and logical replication	Michael Paquier	07:18
Re: Tab completion for ATTACH PARTITION	Alvaro Herrera	07:19
Re: pg_rewind WAL segments deletion pitfall 📎	Alexander Kukushkin	07:21
Re: PSQL error: total cell count of XXX exceeded 📎	Hongxu Ma	07:31
Re: [dynahash] do not refill the hashkey after hash_search	John Naylor	08:22
Re: [dynahash] do not refill the hashkey after hash_search	Junwang Zhao	08:46
Re: Cleaning up array_in() 📎	jian he	08:55
Re: ALTER COLUMN ... SET EXPRESSION to alter stored generated column's expression	Maxim Orlov	08:57
Re: [dynahash] do not refill the hashkey after hash_search	John Naylor	09:28
Re: [PoC] pg_upgrade: allow to upgrade publisher node	Amit Kapila	09:49
Re: Have better wording for snapshot file reading failure	Yogesh Sharma	10:02
Re: Infinite Interval 📎	Ashutosh Bapat	10:13
Re: persist logical slots to disk during shutdown checkpoint 📎	Amit Kapila	10:50
Re: Have better wording for snapshot file reading failure	Bharath Rupireddy	10:52
Re: Detoasting optionally to make Explain-Analyze less misleading	Jehan-Guillaume de Rorthais	11:09
RE: Synchronizing slots from primary to standby	Hayato Kuroda (Fujitsu)	11:18
Re: Have better wording for snapshot file reading failure	Daniel Gustafsson	11:19
Re: Synchronizing slots from primary to standby 📎	shveta malik	11:23
Re: Synchronizing slots from primary to standby	shveta malik	11:26
Re: Row pattern recognition	Vik Fearing	11:28
Re: logical decoding and replication of sequences, take 2	Ashutosh Bapat	11:38
Quoting filename in using facing log messages 📎	Daniel Gustafsson	11:48
Re: Synchronizing slots from primary to standby	Amit Kapila	11:48
Re: Quoting filename in using facing log messages	Peter Eisentraut	11:55
Re: Quoting filename in using facing log messages	Daniel Gustafsson	12:02
Re: make add_paths_to_append_rel aware of startup cost	Andy Fan	12:20
Re: Row pattern recognition	Tatsuo Ishii	12:35
Re: Make --help output fit within 80 columns per line	torikoshia	12:40
Re: Document that PG_TRY block cannot have a return statement 📎	Serpent	12:49
Re: BufferUsage counters' values have changed	Nazir Bilal Yavuz	13:04
Re: logical decoding and replication of sequences, take 2	Ashutosh Bapat	13:18
Redundant Unique plan node for table with a unique index 📎	Damir Belyalov	13:22
Re: Redundant Unique plan node for table with a unique index	Daniel Gustafsson	13:28
Re: [ psql - review request ] review request for \d+ tablename, \d+ indexname indenting	Peter Eisentraut	13:48
RE: [PoC] pg_upgrade: allow to upgrade publisher node	Hayato Kuroda (Fujitsu)	13:52
Re: Add 'worker_type' to pg_stat_subscription	Maxim Orlov	14:06
Re: Reducing connection overhead in pg_upgrade compat check phase	Peter Eisentraut	14:12
Re: pg_resetwal tests, logging, and docs update	Aleksander Alekseev	14:36
Re: Avoid a possible null pointer (src/backend/utils/adt/pg_locale.c)	Jeff Davis	15:14
Re: Add 'worker_type' to pg_stat_subscription	Nathan Bossart	16:59
Re: Possibility to disable `ALTER SYSTEM`	Greg Sabino Mullane	17:10
Re: Eliminate redundant tuple visibility check in vacuum	Andres Freund	17:29
Re: Make --help output fit within 80 columns per line	Greg Sabino Mullane	17:46
Re: Add 'worker_type' to pg_stat_subscription	Nathan Bossart	17:54
Re: pg_resetwal tests, logging, and docs update	Peter Eisentraut	18:34
Re: Inefficiency in parallel pg_restore with many tables 📎	Nathan Bossart	18:34
Re: BufferUsage counters' values have changed 📎	Andres Freund	18:59
Re: [PATCH] Add native windows on arm64 support	Peter Eisentraut	19:09
Re: BufferUsage counters' values have changed	Andres Freund	19:10
Re: [PATCH] Add native windows on arm64 support	Peter Eisentraut	19:12
Re: RFC: pg_stat_logmsg 📎	Joe Conway	19:30
Re: [PATCH] Add native windows on arm64 support	Andres Freund	19:32
Re: JSON Path and GIN Questions	David E. Wheeler	20:01
Re: Extract numeric filed in JSONB more effectively	Chapman Flack	21:18
Re: Support prepared statement invalidation when result types change	Euler Taveira	21:38
Re: Inefficiency in parallel pg_restore with many tables 📎	Nathan Bossart	22:47
Re: Jumble the CALL command in pg_stat_statements 📎	Imseih (AWS), Sami	23:09
Re: Redundant Unique plan node for table with a unique index	David Rowley	23:39
Re: Surely this code in setrefs.c is wrong?	David Rowley	23:57

Sept. 14, 2023

Thread	Author	Time
Re: Inefficiency in parallel pg_restore with many tables	Tom Lane	00:01
Re: Redundant Unique plan node for table with a unique index	Andy Fan	01:17
Re: Avoid a possible null pointer (src/backend/utils/adt/pg_locale.c)	Michael Paquier	01:32
Re: Have better wording for snapshot file reading failure	Michael Paquier	01:33
Re: persist logical slots to disk during shutdown checkpoint	Michael Paquier	01:50
Re: Have better wording for snapshot file reading failure	Andres Freund	02:07
Re: Have better wording for snapshot file reading failure	Andres Freund	02:09
Re: BufferUsage counters' values have changed	Andres Freund	02:22
RE: [PoC] pg_upgrade: allow to upgrade publisher node	Zhijie Hou (Fujitsu)	03:10
Re: [PoC] pg_upgrade: allow to upgrade publisher node	Dilip Kumar	03:44
Re: Inefficiency in parallel pg_restore with many tables 📎	Nathan Bossart	03:45
Re: [PoC] pg_upgrade: allow to upgrade publisher node	Dilip Kumar	03:51
Re: JSON Path and GIN Questions	Erik Rijkers	04:04
Re: CHECK Constraint Deferrable	vignesh C	04:27
Re: [PoC] pg_upgrade: allow to upgrade publisher node	Amit Kapila	04:30
Re: Have better wording for snapshot file reading failure	Michael Paquier	04:33
Re: JSON Path and GIN Questions	Tom Lane	04:41
Re: [PoC] pg_upgrade: allow to upgrade publisher node	Dilip Kumar	05:07
Re: [PoC] pg_upgrade: allow to upgrade publisher node	Amit Kapila	05:47
Re: Cleaning up array_in()	Alexander Lakhin	06:00
Re: CHECK Constraint Deferrable	Himanshu Upadhyaya	06:14
Re: Infinite Interval	jian he	06:28
Small patch modifying variable name to reflect the logic involved 📎	Krishnakumar R	06:28
Re: Extract numeric filed in JSONB more effectively	Andy Fan	06:41
Fixup the variable name to indicate the WAL record reservation status. 📎	Krishnakumar R	06:48
Re: Have better wording for snapshot file reading failure 📎	Michael Paquier	07:29
Re: Quoting filename in using facing log messages	Michael Paquier	07:56
Re: Cleaning up array_in() 📎	jian he	08:14
Re: remaining sql/json patches 📎	Amit Langote	08:14
Re: information_schema and not-null constraints	Peter Eisentraut	08:20
Re: [dynahash] do not refill the hashkey after hash_search 📎	Junwang Zhao	08:28
Re: Redundant Unique plan node for table with a unique index	Damir Belyalov	08:44
Re: Reducing connection overhead in pg_upgrade compat check phase 📎	Daniel Gustafsson	08:48
Re: ALTER COLUMN ... SET EXPRESSION to alter stored generated column's expression	Amul Sul	09:04
Re: subscription TAP test has unused $result	Amit Kapila	09:10
Re: persist logical slots to disk during shutdown checkpoint	Amit Kapila	09:11
Re: Quoting filename in using facing log messages	Daniel Gustafsson	09:23
Re: Small patch modifying variable name to reflect the logic involved	Daniel Gustafsson	09:30
Re: [PATCH] Add native windows on arm64 support	Daniel Gustafsson	09:39
Re: CHECK Constraint Deferrable	Himanshu Upadhyaya	10:03
Is it possible to change wal_level online	Andy Fan	10:05
Re: Index range search optimization 📎	Alexander Korotkov	10:22
Re: Avoid a possible null pointer (src/backend/utils/adt/pg_locale.c)	Ranier Vilela	11:08
Re: Reducing memory consumed by RestrictInfo list translations in partitionwise join planning 📎	Ashutosh Bapat	11:09
bug fix and documentation improvement about vacuumdb 📎	Kuwamura Masaki	11:21
Re: [PATCH] Add inline comments to the pg_hba_file_rules view	Jim Jones	11:33
What's the eviction algorithm of newest pg version?	jacktby jacktby	11:47
Re: [PATCH] Add CANONICAL option to xmlserialize	Jim Jones	11:54
Re: bug fix and documentation improvement about vacuumdb	Daniel Gustafsson	12:06
Re: What's the eviction algorithm of newest pg version?	David Rowley	12:55
Re: Is it possible to change wal_level online	Euler Taveira	13:21
Re: ALTER COLUMN ... SET EXPRESSION to alter stored generated column's expression	Ashutosh Bapat	13:53
Re: bug fix and documentation improvement about vacuumdb 📎	Nathan Bossart	14:57
Buffer ReadMe Confuse	jacktby jacktby	16:05
Re: SQL:2011 application time	Paul Jungwirth	16:09
Re: SQL:2011 application time 📎	Paul Jungwirth	16:11
Re: Detoasting optionally to make Explain-Analyze less misleading 📎	stepan rutz	19:27
Re: psql: Add command to use extended query protocol 📎	Tobias Bussmann	20:26
Re: [PATCH] Add CANONICAL option to xmlserialize	Thomas Munro	21:43
Re: Add 'worker_type' to pg_stat_subscription 📎	Nathan Bossart	22:04
Re: subscription TAP test has unused $result	Peter Smith	22:53
Re: Cygwin cleanup	Thomas Munro	23:04
Re: Buffer ReadMe Confuse	Andy Fan	23:26
Re: [PATCH] Add inline comments to the pg_hba_file_rules view	Michael Paquier	23:28
Re: Is it possible to change wal_level online	Andy Fan	23:28
Re: Support prepared statement invalidation when result types change	Andy Fan	23:41

Sept. 15, 2023

Thread	Author	Time
Re: Have better wording for snapshot file reading failure	Andres Freund	00:33
Re: Fixup the variable name to indicate the WAL record reservation status.	Kyotaro Horiguchi	01:12
Re: Is it possible to change wal_level online	Andres Freund	01:28
Re: Extract numeric filed in JSONB more effectively 📎	Andy Fan	01:53
Bug fix for psql's meta-command \ev 📎	Ryoga Yoshida	02:37
Re: bug fix and documentation improvement about vacuumdb	Kyotaro Horiguchi	02:39
RE: logical decoding and replication of sequences, take 2 📎	Zhijie Hou (Fujitsu)	03:11
RE: [PoC] pg_upgrade: allow to upgrade publisher node 📎	Hayato Kuroda (Fujitsu)	03:13
RE: [PoC] pg_upgrade: allow to upgrade publisher node	Hayato Kuroda (Fujitsu)	03:14
RE: [PoC] pg_upgrade: allow to upgrade publisher node	Hayato Kuroda (Fujitsu)	03:15
Re: Have better wording for snapshot file reading failure 📎	Michael Paquier	05:20
Re: Bug fix for psql's meta-command \ev	Michael Paquier	05:26
Re: CHECK Constraint Deferrable	vignesh C	05:58
Re: [PoC] pg_upgrade: allow to upgrade publisher node	Amit Kapila	06:11
Re: Bug fix for psql's meta-command \ev	Kyotaro Horiguchi	06:17
Re: RFC: Logging plan of the running query 📎	Lepikhov Andrei	06:21
Re: make add_paths_to_append_rel aware of startup cost 📎	David Rowley	07:15
Re: BufferUsage counters' values have changed	Karina Litskevich	07:37
Re: [PATCH] Add inline comments to the pg_hba_file_rules view	Jim Jones	07:37
Re: POC: Extension for adding distributed tracing - pg_tracing 📎	Anthonin Bonnefoy	08:04
Re: bug fix and documentation improvement about vacuumdb	Daniel Gustafsson	08:13
Re: Synchronizing slots from primary to standby	Peter Smith	08:51
Re: Possibility to disable `ALTER SYSTEM`	Gabriele Bartolini	09:16
Re: Possibility to disable `ALTER SYSTEM`	Daniel Gustafsson	09:18
Re: pg_upgrade and logical replication 📎	vignesh C	09:38
Improve the log message output of basic_archive when basic_archive.archive_directory parameter is not set 📎	bt23nguyent	09:38
Re: pg_upgrade and logical replication	vignesh C	09:42
pgBufferUsage.blk_{read|write}_time are zero although there are pgBufferUsage.local_blks_{read|written} 📎	Nazir Bilal Yavuz	09:46
Re: psql: Add command to use extended query protocol	Alvaro Herrera	09:51
Re: Improve the log message output of basic_archive when basic_archive.archive_directory parameter is not set	Daniel Gustafsson	09:57
Re: POC PATCH: copy from ... exceptions to: (was Re: VLDB Features) 📎	Damir Belyalov	10:02
Re: Speed up transaction completion faster after many relations are accessed in a transaction	Heikki Linnakangas	10:37
Re: Improve the log message output of basic_archive when basic_archive.archive_directory parameter is not set	Alvaro Herrera	10:49
Re: pg_upgrade and logical replication	vignesh C	11:21
Re: Unlogged relation copy is not fsync'd	Heikki Linnakangas	11:22
Re: POC: Extension for adding distributed tracing - pg_tracing	Aleksander Alekseev	11:32
Re: Unlogged relation copy is not fsync'd	Heikki Linnakangas	11:47
Re: POC: Extension for adding distributed tracing - pg_tracing	Nikita Malakhov	12:13
Implement a column store for pg?	jacktby jacktby	12:31
RE: [PoC] pg_upgrade: allow to upgrade publisher node 📎	Hayato Kuroda (Fujitsu)	12:32
Re: Implement a column store for pg?	Daniel Gustafsson	12:47
Re: Improve the log message output of basic_archive when basic_archive.archive_directory parameter is not set	Daniel Gustafsson	12:48
RE: [PoC] pg_upgrade: allow to upgrade publisher node 📎	Hayato Kuroda (Fujitsu)	13:02
Re: Implement a column store for pg?	jacktby jacktby	13:13
Re: pgBufferUsage.blk_{read|write}_time are zero although there are pgBufferUsage.local_blks_{read|written}	Melanie Plageman	13:30
Re: sslinfo extension - add notbefore and notafter timestamps 📎	Daniel Gustafsson	13:34
Re: Improve the log message output of basic_archive when basic_archive.archive_directory parameter is not set	Nathan Bossart	14:38
Re: Improve the log message output of basic_archive when basic_archive.archive_directory parameter is not set	Daniel Gustafsson	14:41
Re: bug fix and documentation improvement about vacuumdb	Nathan Bossart	14:42
Re: Unlogged relations and WAL-logging	Heikki Linnakangas	14:54
Re: Make --help output fit within 80 columns per line 📎	torikoshia	15:10
Re: Implement a column store for pg?	Jonah H. Harris	16:24
Re: Add 'worker_type' to pg_stat_subscription 📎	Nathan Bossart	16:35
Re: Small patch modifying variable name to reflect the logic involved	Daniel Gustafsson	17:50
SET ROLE documentation improvement 📎	Yurii Rashkovskii	18:26
Re: Faster "SET search_path"	Jeff Davis	18:31
ALTER ROLE documentation improvement 📎	Yurii Rashkovskii	18:46
Re: Detoasting optionally to make Explain-Analyze less misleading 📎	stepan rutz	20:09
Re: JSON Path and GIN Questions	David E. Wheeler	20:13
Re: JSON Path and GIN Questions	David E. Wheeler	20:27
semantics of "convenient to store" in FmgrInfo ?	Chapman Flack	20:39
Re: SET ROLE documentation improvement	Nathan Bossart	20:47
Re: ALTER ROLE documentation improvement	Nathan Bossart	20:53
Re: JSON Path and GIN Questions	Tom Lane	21:14
Re: ALTER ROLE documentation improvement 📎	Yurii Rashkovskii	21:25
Re: SET ROLE documentation improvement	Yurii Rashkovskii	21:36

Sept. 16, 2023

Thread	Author	Time
Re: Infinite Interval 📎	jian he	00:00

Browse Archives

Prev | Next