pgsql-hackers since 2023-09-22 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. 22, 2023

Thread	Author	Time
Re: Questioning an errcode and message in jsonb.c	Andy Fan	00:38
Remove MSVC scripts from the tree 📎	Michael Paquier	01:12
Re: Questioning an errcode and message in jsonb.c	Chapman Flack	01:16
Re: pg_upgrade --check fails to warn about abstime	Bruce Momjian	01:46
RE: CI: Unfamiliar error while testing macOS	Hayato Kuroda (Fujitsu)	02:44
Re: Report planning memory in EXPLAIN ANALYZE	Andy Fan	02:52
Re: Questioning an errcode and message in jsonb.c	Andy Fan	03:02
Re: pg_upgrade --check fails to warn about abstime	Tom Lane	03:18
Re: [PoC] Reducing planning time when tables have many partitions	Lepikhov Andrei	03:48
Re: New WAL record to detect the checkpoint redo location	Dilip Kumar	04:03
Re: [HACKERS] Should logtape.c blocks be of type long? 📎	Michael Paquier	04:46
Try adding type cast with tablespace 📎	程ゆき	04:49
Re: [HACKERS] Should logtape.c blocks be of type long?	Peter Geoghegan	04:53
Doesn't pgstat_report_wal() handle the argument "force" incorrectly	Ryoga Yoshida	04:58
Doesn't pgstat_report_wal() handle the argument "force" incorrectly 📎	Ryoga Yoshida	05:11
Re: Row pattern recognition 📎	Tatsuo Ishii	05:16
Re: Bug fix in vacuumdb --buffer-usage-limit xxx -Z 📎	Michael Paquier	05:21
Re: [PoC] pg_upgrade: allow to upgrade publisher node	Bharath Rupireddy	05:26
Re: information_schema and not-null constraints	Peter Eisentraut	05:59
Re: Remove MSVC scripts from the tree	Peter Eisentraut	06:06
Re: New WAL record to detect the checkpoint redo location	Amit Kapila	06:07
Re: [PoC] pg_upgrade: allow to upgrade publisher node	Bharath Rupireddy	06:29
Re: [PoC] pg_upgrade: allow to upgrade publisher node	Amit Kapila	06:41
Re: [PoC] pg_upgrade: allow to upgrade publisher node	Amit Kapila	06:44
Re: pg_ctl start may return 0 even if the postmaster has been already started on Windows 📎	Kyotaro Horiguchi	07:15
Re: Infinite Interval 📎	Ashutosh Bapat	07:48
Re: Infinite Interval	Dean Rasheed	08:09
Re: Row pattern recognition 📎	Erik Rijkers	08:12
Re: [PATCH] Add extra statistics to explain for Nested Loop	Andrey Lepikhov	08:14
Re: Row pattern recognition	Erik Rijkers	08:23
Re: Questions about the new subscription parameter: password_required	Benoit Lobréau	08:25
Re: Row pattern recognition 📎	Erik Rijkers	08:26
Re: [PoC] pg_upgrade: allow to upgrade publisher node	Amit Kapila	08:39
Re: Infinite Interval	jian he	09:05
Re: bug fix and documentation improvement about vacuumdb	Kuwamura Masaki	09:08
Re: Fix error handling in be_tls_open_server()	Daniel Gustafsson	09:43
Re: Report planning memory in EXPLAIN ANALYZE	Ashutosh Bapat	09:56
Re: Row pattern recognition	Tatsuo Ishii	10:12
Re: Infinite Interval	Ashutosh Bapat	10:12
Re: Synchronizing slots from primary to standby	Amit Kapila	10:18
Re: Dump-restore loosing 'attnotnull' bit for DEFERRABLE PRIMARY KEY column(s). 📎	Amul Sul	10:55
Re: pg_upgrade --check fails to warn about abstime 📎	Alvaro Herrera	11:14
Re: logical decoding and replication of sequences, take 2	Dilip Kumar	11:24
Re: Row pattern recognition	Erik Rijkers	11:28
Re: Synchronizing slots from primary to standby 📎	shveta malik	11:48
Re: Refactor ssl tests to avoid using internal PostgreSQL::Test::Cluster methods	Daniel Gustafsson	11:52
RE: pg_ctl start may return 0 even if the postmaster has been already started on Windows 📎	Hayato Kuroda (Fujitsu)	12:20
Re: Synchronizing slots from primary to standby	Drouvot, Bertrand	12:30
Re: Questions about the new subscription parameter: password_required	Robert Haas	12:36
Re: Use virtual tuple slot for Unique node	Heikki Linnakangas	12:36
Re: bug fix and documentation improvement about vacuumdb 📎	Daniel Gustafsson	12:58
Re: Index range search optimization	Pavel Borisov	14:01
Re: Index range search optimization 📎	Alexander Korotkov	14:24
Re: Row pattern recognition	Jacob Champion	14:48
Re: Questions about the new subscription parameter: password_required	Benoit Lobréau	14:59
Re: GenBKI emits useless open;close for catalogs without rows	Matthias van de Meent	15:26
Re: GUC for temporarily disabling event triggers 📎	Daniel Gustafsson	15:29
Re: POC: Extension for adding distributed tracing - pg_tracing 📎	Anthonin Bonnefoy	15:45
Re: GenBKI emits useless open;close for catalogs without rows	Matthias van de Meent	15:50
Invalidate the subscription worker in cases where a user loses their superuser status 📎	vignesh C	18:52
Re: Questions about the new subscription parameter: password_required	Robert Haas	19:58
Re: CREATE FUNCTION ... SEARCH { DEFAULT | SYSTEM | SESSION }	Jeff Davis	20:05
Is this a problem in GenericXLogFinish()?	Jeff Davis	20:52
Re: Better help output for pgbench -I init_steps	Tristen Raab	21:01
Re: Add support for AT LOCAL	cary huang	21:46
pgsql: Don't trust unvalidated xl_tot_len.	Thomas Munro	22:51
Re: Add support for AT LOCAL	Vik Fearing	22:54

Sept. 23, 2023

Thread	Author	Time
Re: Synchronizing slots from primary to standby	Amit Kapila	01:38
Failures on gombessa -- EIO?	Thomas Munro	01:53
Re: Questions about the new subscription parameter: password_required	Jeff Davis	01:57
nbtree's ScalarArrayOp array mark/restore code appears to be buggy 📎	Peter Geoghegan	03:17
RE: [PoC] pg_upgrade: allow to upgrade publisher node 📎	Hayato Kuroda (Fujitsu)	04:48
RE: [PoC] pg_upgrade: allow to upgrade publisher node	Hayato Kuroda (Fujitsu)	04:49
Re: Invalidate the subscription worker in cases where a user loses their superuser status	Amit Kapila	05:58
Avoid a possible out-of-bounds access (src/backend/optimizer/util/relnode.c) 📎	Ranier Vilela	11:58
Should rolpassword be toastable?	Alexander Lakhin	12:00
Re: Failures on gombessa -- EIO?	Nikola Ivanov	14:29
Re: Should rolpassword be toastable?	Tom Lane	14:39
Re: Should rolpassword be toastable?	Alexander Lakhin	18:00
Re: nbtree's ScalarArrayOp array mark/restore code appears to be buggy	Peter Geoghegan	18:47
Re: bug fix and documentation improvement about vacuumdb	Nathan Bossart	19:29
Re: Eager page freeze criteria clarification	Melanie Plageman	19:53
Re: nbtree's ScalarArrayOp array mark/restore code appears to be buggy 📎	Peter Geoghegan	23:22

Sept. 24, 2023

Thread	Author	Time
Re: [HACKERS] Should logtape.c blocks be of type long?	Michael Paquier	01:42
Re: Avoid a possible out-of-bounds access (src/backend/optimizer/util/relnode.c)	Etsuro Fujita	04:50
Re: bug fix and documentation improvement about vacuumdb	Kuwamura Masaki	08:22
How to Know the number of attrs?	jacktby jacktby	12:56
How to Know the number of attrs?	jacktby jacktby	12:57
Re: How to Know the number of attrs?	Erik Wienhold	13:38
Re: Eager page freeze criteria clarification	Melanie Plageman	16:45
Re: Invalidate the subscription worker in cases where a user loses their superuser status	vignesh C	19:02
Various small doc improvements; plpgsql, schemas, permissions, oidvector 📎	Karl O. Pinc	22:57
Re: Fix bug in VACUUM and ANALYZE docs	Karl O. Pinc	23:30
Re: GUC for temporarily disabling event triggers 📎	Michael Paquier	23:35

Sept. 25, 2023

Thread	Author	Time
Re: Fix bug in VACUUM and ANALYZE docs	Michael Paquier	00:00
Re: DROP DATABASE is interruptible	Peter Eisentraut	00:48
Re: Doesn't pgstat_report_wal() handle the argument "force" incorrectly	Michael Paquier	00:56
Re: pg_upgrade and logical replication 📎	Michael Paquier	01:57
Re: Synchronizing slots from primary to standby	Peter Smith	02:13
Re: Doesn't pgstat_report_wal() handle the argument "force" incorrectly 📎	Ryoga Yoshida	02:27
Confused about gram.y referencs in Makefile?	Japin Li	02:38
Confused about gram.y referencs in Makefile?	Japin Li	02:41
Re: Confused about gram.y referencs in Makefile?	Tom Lane	03:17
RE: Partial aggregates pushdown 📎	[email protected]	03:18
Re: Confused about gram.y referencs in Makefile?	Japin Li	03:34
Re: Report planning memory in EXPLAIN ANALYZE	Andy Fan	03:35
Re: Doesn't pgstat_report_wal() handle the argument "force" incorrectly 📎	Michael Paquier	03:47
Re: Remove MSVC scripts from the tree	Michael Paquier	04:00
Re: Synchronizing slots from primary to standby	shveta malik	04:03
Re: Synchronizing slots from primary to standby 📎	Ajin Cherian	04:09
Re: Synchronizing slots from primary to standby	shveta malik	04:10
Re: Postgres picks suboptimal index after building of an extended statistics	Andrey Lepikhov	04:30
Re: pg_upgrade and logical replication	Amit Kapila	04:35
Re: SQL:2011 application time	jian he	04:52
Re: Doesn't pgstat_report_wal() handle the argument "force" incorrectly	Ryoga Yoshida	05:16
Re: Row pattern recognition 📎	Tatsuo Ishii	05:26
RE: pg_upgrade and logical replication	Hayato Kuroda (Fujitsu)	05:35
Re: Doesn't pgstat_report_wal() handle the argument "force" incorrectly	Michael Paquier	05:38
Re: [PoC] pg_upgrade: allow to upgrade publisher node	Bharath Rupireddy	05:45
Re: Doesn't pgstat_report_wal() handle the argument "force" incorrectly	Ryoga Yoshida	05:49
Re: pg_upgrade and logical replication	Michael Paquier	05:58
Re: Document efficient self-joins / UPDATE LIMIT techniques.	jian he	06:04
Re: pg_upgrade and logical replication	Michael Paquier	06:13
Clarify where the severity level is defined 📎	Kuwamura Masaki	06:22
Re: Make --help output fit within 80 columns per line 📎	torikoshia	06:27
Doc: vcregress .bat commands list lacks "taptest" 📎	Yugo NAGATA	06:32
RE: logical decoding and replication of sequences, take 2	Zhijie Hou (Fujitsu)	06:33
Re: Clarify where the severity level is defined	Daniel Gustafsson	06:37
Re: Doc: vcregress .bat commands list lacks "taptest"	Michael Paquier	06:58
Re: [PoC] pg_upgrade: allow to upgrade publisher node	Dilip Kumar	07:00
Re: [PoC] pg_upgrade: allow to upgrade publisher node	Dilip Kumar	07:02
How to update unicode mapping table?	Japin Li	07:02
Wrong results with grouping sets 📎	Richard Guo	07:11
Re: Doc: vcregress .bat commands list lacks "taptest"	Daniel Gustafsson	07:14
Re: GUC for temporarily disabling event triggers 📎	Daniel Gustafsson	07:19
Re: RFC: Logging plan of the running query	torikoshia	07:21
Re: Various small doc improvements; plpgsql, schemas, permissions, oidvector	Daniel Gustafsson	07:26
Re: Confused about gram.y referencs in Makefile?	Daniel Gustafsson	07:29
Re: [PoC/RFC] Multiple passwords, interval expirations 📎	Gurjeet Singh	07:31
Re: Invalidate the subscription worker in cases where a user loses their superuser status 📎	vignesh C	07:35
Re: [PoC] pg_upgrade: allow to upgrade publisher node	Bharath Rupireddy	07:36
Re: GUC for temporarily disabling event triggers	Michael Paquier	07:50
Re: GUC for temporarily disabling event triggers	Daniel Gustafsson	07:52
Re: [PoC] pg_upgrade: allow to upgrade publisher node	Bharath Rupireddy	07:53
Regression in COPY FROM caused by 9f8377f7a2	Laurenz Albe	07:54
Re: pipe_read_line for reading arbitrary strings 📎	Daniel Gustafsson	07:55
Re: [PoC] pg_upgrade: allow to upgrade publisher node	Dilip Kumar	08:33
Re: [PoC] pg_upgrade: allow to upgrade publisher node	Amit Kapila	08:36
Re: Synchronizing slots from primary to standby	Drouvot, Bertrand	08:44
Re: Regression in COPY FROM caused by 9f8377f7a2 📎	Laurenz Albe	08:59
Re: On login trigger: take three	Alexander Korotkov	09:13
Re: POC: GUC option for skipping shared buffers in core dumps 📎	Andrey Lepikhov	09:42
Re: RFC: Logging plan of the running query	Andrey Lepikhov	09:49
Re: Index range search optimization 📎	Pavel Borisov	09:58
Re: Is this a problem in GenericXLogFinish()?	Heikki Linnakangas	10:04
Fix a wrong comment in setrefs.c 📎	Richard Guo	10:11
Re: Index range search optimization 📎	Pavel Borisov	10:11
Re: Make --help output fit within 80 columns per line	torikoshia	10:13
Re: Index range search optimization 📎	Alexander Korotkov	10:18
Re: [PATCH] Extend ALTER OPERATOR to support adding commutator, negator, hashes, and merges	jian he	10:52
RE: [PoC] pg_upgrade: allow to upgrade publisher node	Hayato Kuroda (Fujitsu)	11:01
Re: Avoid a possible out-of-bounds access (src/backend/optimizer/util/relnode.c)	Ashutosh Bapat	11:23
Re: Build the docs if there are changes in docs and don't run other tasks if the changes are only in docs 📎	Nazir Bilal Yavuz	11:56
Re: Various small doc improvements; plpgsql, schemas, permissions, oidvector	Karl O. Pinc	12:00
Re: Various small doc improvements; plpgsql, schemas, permissions, oidvector	Daniel Gustafsson	12:14
Re: GUC for temporarily disabling event triggers	Daniel Gustafsson	12:22
Re: On login trigger: take three	Daniel Gustafsson	12:42
Re: generic plans and "initial" pruning	Amit Langote	12:57
Re: Avoid a possible out-of-bounds access (src/backend/optimizer/util/relnode.c)	Ranier Vilela	13:43
RE: Synchronizing slots from primary to standby 📎	Hayato Kuroda (Fujitsu)	14:15
Re: bug fix and documentation improvement about vacuumdb	Daniel Gustafsson	14:18
Re: Synchronizing slots from primary to standby	Drouvot, Bertrand	14:37
Re: [PATCH] Extend ALTER OPERATOR to support adding commutator, negator, hashes, and merges	jian he	14:55
Why need a lock?	jacktby jacktby	15:04
Re: Regression in COPY FROM caused by 9f8377f7a2	Andrew Dunstan	15:06
Re: Doc: vcregress .bat commands list lacks "taptest"	Andrew Dunstan	15:07
Re: Remove MSVC scripts from the tree	Andrew Dunstan	15:19
Re: Confused about gram.y referencs in Makefile?	Tom Lane	15:29
Re: CREATE FUNCTION ... SEARCH { DEFAULT | SYSTEM | SESSION }	Robert Haas	15:30
Re: Why need a lock?	Tom Lane	15:33
Re: CREATE FUNCTION ... SEARCH { DEFAULT | SYSTEM | SESSION }	Joe Conway	16:00
Re: Improving btree performance through specializing by key shape, take 2	Matthias van de Meent	16:13
Re: Improve tab completion for ALTER DEFAULT PRIVILEGE and ALTER TABLE	vignesh C	17:07
Re: XLog size reductions: smaller XLRec block header for PG17	Matthias van de Meent	17:16
Re: nbtree's ScalarArrayOp array mark/restore code appears to be buggy	Peter Geoghegan	17:33
Re: CREATE FUNCTION ... SEARCH { DEFAULT | SYSTEM | SESSION }	Robert Haas	17:35
Re: XLog size reductions: Reduced XLog record header size for PG17	Matthias van de Meent	17:40
Re: CREATE FUNCTION ... SEARCH { DEFAULT | SYSTEM | SESSION }	Jeff Davis	17:56
Re: CREATE FUNCTION ... SEARCH { DEFAULT | SYSTEM | SESSION }	Jeff Davis	18:03
Re: Eager page freeze criteria clarification	Robert Haas	18:45
Re: DROP DATABASE is interruptible	Andres Freund	18:52
Re: Performance degradation on concurrent COPY into a single relation in PG16. 📎	Tom Lane	19:42
Re: Performance degradation on concurrent COPY into a single relation in PG16.	Andres Freund	19:48
Re: CREATE FUNCTION ... SEARCH { DEFAULT | SYSTEM | SESSION }	Joe Conway	20:11
Re: Eager page freeze criteria clarification	Robert Haas	20:19
Re: SQL:2011 application time 📎	Paul Jungwirth	20:20
Re: Regression in COPY FROM caused by 9f8377f7a2	Andrew Dunstan	20:52
Re: SQL:2011 application time	Peter Eisentraut	21:00
Re: Add 'worker_type' to pg_stat_subscription	Nathan Bossart	21:16
Re: Eager page freeze criteria clarification	Peter Geoghegan	21:16

Browse Archives

Prev | Next