pgsql-hackers since 2023-09-15 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. 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
Re: Performance degradation on concurrent COPY into a single relation in PG16.	Andres Freund	00:00
Re: [PoC] Improve dead tuple storage for lazy vacuum	Andres Freund	00:03
Re: Add 'worker_type' to pg_stat_subscription	Michael Paquier	00:13
Re: JSON Path and GIN Questions	Erik Rijkers	03:59
Re: [PATCH] Add inline comments to the pg_hba_file_rules view	Michael Paquier	04:18
Re: Add 'worker_type' to pg_stat_subscription	Amit Kapila	12:39
Re: JSON Path and GIN Questions	David E. Wheeler	17:43
Re: JSON Path and GIN Questions	David E. Wheeler	20:19
Re: JSON Path and GIN Questions	David E. Wheeler	20:26
Re: Add 'worker_type' to pg_stat_subscription 📎	Nathan Bossart	20:40
Re: JSON Path and GIN Questions	Erik Wienhold	20:50
Re: JSON Path and GIN Questions	David E. Wheeler	21:29
Re: JSON Path and GIN Questions	Erik Wienhold	22:13
Re: JSON Path and GIN Questions	David E. Wheeler	23:41

Sept. 17, 2023

Thread	Author	Time
Re: [PoC] Improve dead tuple storage for lazy vacuum	Masahiko Sawada	03:21
Re: remaining sql/json patches	Erik Rijkers	06:37
Re: Have better wording for snapshot file reading failure	Yogesh Sharma	12:36
Re: make add_paths_to_append_rel aware of startup cost	Andy Fan	13:42
Re: JSON Path and GIN Questions 📎	Tom Lane	16:20
Fix output of zero privileges in psql 📎	Erik Wienhold	19:31
Re: Fix output of zero privileges in psql	Erik Wienhold	19:37
Re: JSON Path and GIN Questions	David E. Wheeler	22:09
to_regtype() Raises Error	David E. Wheeler	22:13
Re: to_regtype() Raises Error	Erik Wienhold	22:41
Re: to_regtype() Raises Error	Vik Fearing	22:57
Re: to_regtype() Raises Error	Tom Lane	23:28
Re: to_regtype() Raises Error	Erik Wienhold	23:33
Re: to_regtype() Raises Error	David E. Wheeler	23:37
Re: Optimizing nbtree ScalarArrayOp execution, allowing multi-column ordered scans, skip scan 📎	Peter Geoghegan	23:47
Re: to_regtype() Raises Error	Laurenz Albe	23:49

Sept. 18, 2023

Thread	Author	Time
Re: Add 'worker_type' to pg_stat_subscription	Peter Smith	00:40
Re: to_regtype() Raises Error	David G. Johnston	00:58
Re: to_regtype() Raises Error	Chapman Flack	01:24
Re: to_regtype() Raises Error	David G. Johnston	01:58
Re: to_regtype() Raises Error	Chapman Flack	02:44
Re: to_regtype() Raises Error	David G. Johnston	02:58
Re: SQL:2011 application time	jian he	03:11
Re: remaining sql/json patches 📎	Amit Langote	03:15
Re: Add 'worker_type' to pg_stat_subscription	Amit Kapila	03:43
Re: make add_paths_to_append_rel aware of startup cost	David Rowley	03:58
Re: Add 'worker_type' to pg_stat_subscription	Amit Kapila	04:01
Re: Speed up transaction completion faster after many relations are accessed in a transaction 📎	David Rowley	04:08
function "cursor_to_xmlschema" causes a crash 📎	杨伯宇 (长堂)	05:00
Re: Server crash on RHEL 9/s390x platform against PG16	Suraj Kharage	05:50
Re: information_schema and not-null constraints	Peter Eisentraut	06:15
Re: make add_paths_to_append_rel aware of startup cost	Andy Fan	06:38
Re: pg_stat_get_backend_subxact() and backend IDs?	Ian Lawrence Barwick	06:52
Re: Add 'worker_type' to pg_stat_subscription	Peter Smith	06:56
RE: [PoC] pg_upgrade: allow to upgrade publisher node	Zhijie Hou (Fujitsu)	07:03
Re: information_schema and not-null constraints	Alvaro Herrera	07:43
Re: ALTER COLUMN ... SET EXPRESSION to alter stored generated column's expression	Amul Sul	08:29
Re: Infinite Interval	Ashutosh Bapat	09:19
Commitfest 2023-09 half-time	Peter Eisentraut	09:20
Re: remaining sql/json patches	Erik Rijkers	10:12
Re: remaining sql/json patches	Amit Langote	10:20
Re: Synchronizing slots from primary to standby	shveta malik	10:22
Re: Sync scan & regression tests	Heikki Linnakangas	10:49
Re: make add_paths_to_append_rel aware of startup cost 📎	Andy Fan	10:55
Fix GIST readme on LSN vs NSN 📎	Heikki Linnakangas	11:09
Re: remaining sql/json patches 📎	Erik Rijkers	11:14
RE: [PoC] pg_upgrade: allow to upgrade publisher node 📎	Zhijie Hou (Fujitsu)	11:16
Re: Support prepared statement invalidation when result types change 📎	Jelte Fennema-Nio	11:30
Re: Infinite Interval	Dean Rasheed	11:39
Re: [PoC] pg_upgrade: allow to upgrade publisher node 📎	Amit Kapila	11:49
Re: Fix GIST readme on LSN vs NSN	Daniel Gustafsson	11:53
Re: remaining sql/json patches	Erik Rijkers	11:53
Re: Allow specifying a dbname in pg_basebackup connection string	Daniel Gustafsson	12:11
Re: Fix error handling in be_tls_open_server()	Daniel Gustafsson	12:35
Re: SQL:2011 application time	jian he	12:49
dikkop seems unhappy because of openssl stuff (FreeBSD 14-BETA1) 📎	Tomas Vondra	13:11
Re: Cirrus-ci is lowering free CI cycles - what to do with cfbot, etc?	Daniel Gustafsson	13:12
Re: Sync scan & regression tests	Tom Lane	13:45
pg16: XX000: could not find pathkey item to sort	Justin Pryzby	14:02
Re: psql help message contains excessive indentations	Alvaro Herrera	14:39
[PATCH] fastpacth-locks compile time options	Sergey Sergey	14:47
Re: [PATCH] fastpacth-locks compile time options 📎	Sergey Sergey	14:49
Re: GenBKI emits useless open;close for catalogs without rows 📎	Matthias van de Meent	14:50
Re: Extending SMgrRelation lifetimes	Robert Haas	15:19
Re: Add 'worker_type' to pg_stat_subscription	Nathan Bossart	15:20
Re: Make --help output fit within 80 columns per line	Greg Sabino Mullane	15:45
Re: Bug fix for psql's meta-command \ev	Aleksander Alekseev	15:54
Re: Improving btree performance through specializing by key shape, take 2	Matthias van de Meent	15:56
Re: Improving btree performance through specializing by key shape, take 2 📎	Matthias van de Meent	15:57
Re: CREATE FUNCTION ... SEARCH { DEFAULT | SYSTEM | SESSION }	Robert Haas	16:01
Re: Disabling Heap-Only Tuples	Robert Haas	16:22
Questioning an errcode and message in jsonb.c	Chapman Flack	16:55
Re: function "cursor_to_xmlschema" causes a crash	Tom Lane	17:01
Re: XLog size reductions: smaller XLRec block header for PG17 📎	Matthias van de Meent	18:50
Re: dikkop seems unhappy because of openssl stuff (FreeBSD 14-BETA1)	Tom Lane	18:52
Re: New WAL record to detect the checkpoint redo location	Robert Haas	18:57
Re: Disabling Heap-Only Tuples	Laurenz Albe	20:02
Re: Use of additional index columns in rows filtering	Peter Geoghegan	20:35
Re: dikkop seems unhappy because of openssl stuff (FreeBSD 14-BETA1)	Thomas Munro	20:41
Re: CREATE FUNCTION ... SEARCH { DEFAULT | SYSTEM | SESSION }	Jeff Davis	20:50
Re: Add 'worker_type' to pg_stat_subscription	Peter Smith	21:18
Re: Inefficiency in parallel pg_restore with many tables	Nathan Bossart	21:22
Re: Improvements in pg_dump/pg_restore toc format and performances	Nathan Bossart	21:52
Re: Improvements in pg_dump/pg_restore toc format and performances	Nathan Bossart	21:54
Re: Improvements in pg_dump/pg_restore toc format and performances	Pierre Ducroquet	22:41
Re: Index range search optimization	Peter Geoghegan	22:48
Re: Sync scan & regression tests	Andres Freund	22:57
Re: XLog size reductions: smaller XLRec block header for PG17	Andres Freund	23:03
Re: Move bki file pre-processing from initdb to bootstrap	Andres Freund	23:13
Re: dikkop seems unhappy because of openssl stuff (FreeBSD 14-BETA1)	Michael Paquier	23:45
Re: [PATCH] fastpacth-locks compile time options	Michael Paquier	23:52
Re: Optimizing "boundary cases" during backward scan B-Tree index descents 📎	Peter Geoghegan	23:58

Sept. 19, 2023

Thread	Author	Time
Re: [ psql - review request ] review request for \d+ tablename, \d+ indexname indenting 📎	쿼리트릭스	00:19
Re: Fix error handling in be_tls_open_server()	Michael Paquier	00:54
Re: XLog size reductions: smaller XLRec block header for PG17	Michael Paquier	00:57
Re: Inefficiency in parallel pg_restore with many tables	Tom Lane	01:23
Re: Inefficiency in parallel pg_restore with many tables	Nathan Bossart	01:28
Re: Improving btree performance through specializing by key shape, take 2	Peter Geoghegan	01:29
Re: Inefficiency in parallel pg_restore with many tables	Michael Paquier	01:29
Re: Inefficiency in parallel pg_restore with many tables	Tom Lane	01:36
Re: Inefficiency in parallel pg_restore with many tables	Nathan Bossart	01:54
Re: Improving btree performance through specializing by key shape, take 2	Peter Geoghegan	01:56
Re: dikkop seems unhappy because of openssl stuff (FreeBSD 14-BETA1)	Thomas Munro	02:25
RE: pg_ctl start may return 0 even if the postmaster has been already started on Windows	Hayato Kuroda (Fujitsu)	02:37
Re: Add 'worker_type' to pg_stat_subscription	Amit Kapila	03:06
Re: Bug fix for psql's meta-command \ev 📎	Michael Paquier	03:53
Move global variables of pgoutput to plugin private scope. 📎	Zhijie Hou (Fujitsu)	04:10
Re: POC: GROUP BY optimization	Andrey Lepikhov	04:42
Re: Synchronizing slots from primary to standby 📎	shveta malik	04:50
Re: Synchronizing slots from primary to standby	shveta malik	04:59
Re: Move global variables of pgoutput to plugin private scope.	Michael Paquier	05:43
Re: [PATCH] fastpacth-locks compile time options	Sergey Sergey	06:01
RE: [PoC] pg_upgrade: allow to upgrade publisher node 📎	Hayato Kuroda (Fujitsu)	06:17
Re: pg_upgrade and logical replication	Michael Paquier	06:19
Re: Bug fix for psql's meta-command \ev 📎	Ryoga Yoshida	06:29
Re: information_schema and not-null constraints 📎	Peter Eisentraut	07:01
Re: Better help output for pgbench -I init_steps	Peter Eisentraut	07:20
Re: Bug fix for psql's meta-command \ev	Ryoga Yoshida	07:23
Re: Questioning an errcode and message in jsonb.c	Andy Fan	07:55

Browse Archives

Prev | Next