pgsql-hackers since 2023-10-08 08:26

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)

Browse Archives

Prev | Next

Oct. 8, 2023

Thread Author Time
Re: BUG #17540: Prepared statement: PG switches to a generic query plan which is consistently much slower 📎 Richard Guo 08:26
Re: pg16: XX000: could not find pathkey item to sort Richard Guo 10:52
Re: CREATE DATABASE with filesystem cloning Andrew Dunstan 13:20
Re: wal recycling problem Christoph Moench-Tegeder 13:57
Re: [PoC/RFC] Multiple passwords, interval expirations Gurjeet Singh 17:24
Re: [PoC/RFC] Multiple passwords, interval expirations Bruce Momjian 17:29
Re: [PoC/RFC] Multiple passwords, interval expirations Gurjeet Singh 17:50
Re: Trigger violates foreign key constraint Noah Misch 18:17
Re: [PoC/RFC] Multiple passwords, interval expirations Bruce Momjian 18:55
Re: [PoC/RFC] Multiple passwords, interval expirations Gurjeet Singh 20:01
Re: Does anyone ever use OPTIMIZER_DEBUG? David Rowley 21:26
Re: Does anyone ever use OPTIMIZER_DEBUG? Tom Lane 21:28
Re: Add a new BGWORKER_BYPASS_ROLELOGINCHECK flag Tom Lane 21:48
Re: Synchronizing slots from primary to standby Peter Smith 21:54
Re: JSON Path and GIN Questions David E. Wheeler 23:13
Re: CREATE DATABASE with filesystem cloning 📎 Thomas Munro 23:19
Re: Problem, partition pruning for prepared statement with IS NULL clause. 📎 David Rowley 23:26
Re: pg16: XX000: could not find pathkey item to sort David Rowley 23:42

Oct. 9, 2023

Thread Author Time
Re: Draft LIMIT pushdown to Append and MergeAppend patch David Rowley 00:52
Re: pg_stat_statements and "IN" conditions Yasuo Honda 01:46
Re: Draft LIMIT pushdown to Append and MergeAppend patch Andy Fan 01:49
Re: Fix output of zero privileges in psql 📎 Erik Wienhold 01:53
Re: pg16: XX000: could not find pathkey item to sort Richard Guo 02:08
Re: REL_15_STABLE: pgbench tests randomly failing on CI, Windows only 📎 Noah Misch 02:25
Re: Server crash on RHEL 9/s390x platform against PG16 Suraj Kharage 02:51
Re: Does anyone ever use OPTIMIZER_DEBUG? David Rowley 02:55
Re: Fix output of zero privileges in psql David G. Johnston 02:58
Re: REL_15_STABLE: pgbench tests randomly failing on CI, Windows only Thomas Munro 03:22
Re: REL_15_STABLE: pgbench tests randomly failing on CI, Windows only Noah Misch 04:08
Re: pg16: XX000: could not find pathkey item to sort 📎 David Rowley 04:13
Re: Making aggregate deserialization (and WAL receive) functions slightly faster David Rowley 04:28
Re: PGDOCS - add more links in the pub/sub reference pages Amit Kapila 04:32
Re: Making aggregate deserialization (and WAL receive) functions slightly faster Tom Lane 04:37
Re: REL_15_STABLE: pgbench tests randomly failing on CI, Windows only David G. Johnston 05:00
Re: Two Window aggregate node for logically same over clause "Anitha S" 05:01
Re: Synchronizing slots from primary to standby Drouvot, Bertrand 05:21
Re: Synchronizing slots from primary to standby Amit Kapila 05:39
Re: pg16: XX000: could not find pathkey item to sort Richard Guo 05:41
Re: PGDOCS - add more links in the pub/sub reference pages 📎 Peter Smith 06:45
Re: Fix output of zero privileges in psql 📎 Laurenz Albe 07:54
Re: Making aggregate deserialization (and WAL receive) functions slightly faster David Rowley 08:17
Re: Fix output of zero privileges in psql 📎 Laurenz Albe 08:29
Re: Where can I find the doxyfile? Stefan Kaltenbrunner 08:38
Re: Checks in RegisterBackgroundWorker.() Heikki Linnakangas 08:52
Re: [PoC] pg_upgrade: allow to upgrade publisher nodeHayato Kuroda (Fujitsu) <[email protected]> vignesh C 08:59
Re: Clean up some pg_dump tests Alvaro Herrera 09:20
Re: [PoC/RFC] Multiple passwords, interval expirations 📎 Gurjeet Singh 09:31
Re: FDW LIM IT pushdown Ashutosh Bapat 09:32
Re: Add a new BGWORKER_BYPASS_ROLELOGINCHECK flag 📎 Michael Paquier 09:37
Crash in add_paths_to_append_rel 📎 Richard Guo 09:45
Re: Check each of base restriction clauses for constant-FALSE-or-NULL Ashutosh Bapat 09:47
Re: should frontend tools use syncfs() ? Maxim Orlov 10:12
Re: UUID v7 Chris Travers 10:15
Re: Remove distprep Peter Eisentraut 10:16
Re: Synchronizing slots from primary to standby 📎 shveta malik 10:30
Re: Synchronizing slots from primary to standby shveta malik 10:34
Re: Draft LIMIT pushdown to Append and MergeAppend patch Ashutosh Bapat 10:35
Re: Synchronizing slots from primary to standby shveta malik 10:38
Re: Making aggregate deserialization (and WAL receive) functions slightly faster 📎 David Rowley 10:47
Re: typo in couple of places Amit Kapila 10:47
Re: Draft LIMIT pushdown to Append and MergeAppend patch David Rowley 11:03
Re: Crash in add_paths_to_append_rel David Rowley 11:35
Re: Synchronizing slots from primary to standby shveta malik 11:50
Re: Draft LIMIT pushdown to Append and MergeAppend patch Ashutosh Bapat 13:04
Re: Draft LIMIT pushdown to Append and MergeAppend patch Michał Kłeczek 13:09
Re: ALTER COLUMN ... SET EXPRESSION to alter stored generated column's expression Amul Sul 13:26
Re: A failure in 031_recovery_conflict.pl on Debian/s390x 📎 Alexander Lakhin 14:00
Re: On login trigger: take three Alexander Korotkov 14:11
Re: Request for comment on setting binary format output per session Jelte Fennema 15:08
Re: Request for comment on setting binary format output per session Jelte Fennema 15:08
Re: Where can I find the doxyfile? 📎 Bohdan Mart 15:14
Re: pg_resetwal: Corrections around -c option Alvaro Herrera 15:48
Re: Logging parallel worker draught Imseih (AWS), Sami 15:51
Re: should frontend tools use syncfs() ? 📎 Nathan Bossart 16:14
Re: Add a new BGWORKER_BYPASS_ROLELOGINCHECK flag Tom Lane 16:20
Re: Fix output of zero privileges in psql David G. Johnston 16:30
Re: UUID v7 Nick Babadzhanian 16:46
Re: Making aggregate deserialization (and WAL receive) functions slightly faster Tom Lane 17:38
Re: UUID v7 Jelte Fennema 18:11
Re: UUID v7 Brad Peabody 18:42
Re: UUID v7 Andrey Borodin 18:46
Re: Fix output of zero privileges in psql Laurenz Albe 18:56
Re: Request for comment on setting binary format output per session Robert Haas 18:59
Re: Pre-proposal: unicode normalized text Robert Haas 19:08
Re: Request for comment on setting binary format output per session Dave Cramer 19:08
Re: Fix output of zero privileges in psql Tom Lane 19:13
Re: should frontend tools use syncfs() ? 📎 Nathan Bossart 19:34
Re: [PoC/RFC] Multiple passwords, interval expirations 📎 Gurjeet Singh 19:53
Re: New WAL record to detect the checkpoint redo location Robert Haas 19:58
Re: CHECK Constraint Deferrable Robert Haas 20:11
Re: New WAL record to detect the checkpoint redo location Andres Freund 20:14
Re: Request for comment on setting binary format output per session Jeff Davis 20:25
Re: CHECK Constraint Deferrable Robert Haas 20:26
Re: Request for comment on setting binary format output per session Jelte Fennema 20:27
Re: Fix output of zero privileges in psql David G. Johnston 20:34
Re: New WAL record to detect the checkpoint redo location Andres Freund 20:47
Re: should frontend tools use syncfs() ? Nathan Bossart 20:48
Re: On login trigger: take three Andres Freund 20:58
Re: Request for comment on setting binary format output per session Jelte Fennema 21:02
Re: CHECK Constraint Deferrable David G. Johnston 21:07
Re: Request for comment on setting binary format output per session Jelte Fennema 21:11
Re: Remove distprep Andres Freund 21:14
Re: New WAL record to detect the checkpoint redo location Robert Haas 22:31
Re: Add a new BGWORKER_BYPASS_ROLELOGINCHECK flag Michael Paquier 22:37
Lowering the default wal_blocksize to 4K Andres Freund 23:08
Re: Proposal to use JSON for Postgres Parser format Thomas Munro 23:11
Re: New WAL record to detect the checkpoint redo location Andres Freund 23:20
Re: Lowering the default wal_blocksize to 4K Bruce Momjian 23:26
Re: Lowering the default wal_blocksize to 4K Andres Freund 23:36
Re: Lowering the default wal_blocksize to 4K Bruce Momjian 23:45
Re: post-recovery amcheck expectations Peter Geoghegan 23:46
Re: CREATE DATABASE with filesystem cloning Andres Freund 23:48

Oct. 10, 2023

Thread Author Time
Re: typo in couple of places vignesh C 00:43
Re: PGDOCS - add more links in the pub/sub reference pages vignesh C 00:46
Re: pgBufferUsage.blk_{read|write}_time are zero although there are pgBufferUsage.local_blks_{read|written} Michael Paquier 00:54
Re: Included xid in restoring reorder buffer changes from disk log message Kyotaro Horiguchi 01:29
Re: pg_ctl start may return 0 even if the postmaster has been already started on Windows Kyotaro Horiguchi 01:52
Re: Making aggregate deserialization (and WAL receive) functions slightly faster 📎 David Rowley 02:59
Re: Evaluate arguments of correlated SubPlans in the referencing ExprState Andres Freund 03:00
Re: Add a new BGWORKER_BYPASS_ROLELOGINCHECK flag Tom Lane 03:11
Re: Lowering the default wal_blocksize to 4K Tom Lane 03:16
Re: PGDOCS - add more links in the pub/sub reference pages 📎 Peter Smith 03:17
Re: [PATCH] hstore: Fix parsing on Mac OS X: isspace() is locale specific Thomas Munro 03:17
Re: Crash in add_paths_to_append_rel David Rowley 03:52
Re: Lowering the default wal_blocksize to 4K Andres Freund 04:14
Re: Add support for AT LOCAL 📎 Michael Paquier 04:34
Re: Add a new BGWORKER_BYPASS_ROLELOGINCHECK flag Michael Paquier 04:36
Re: Crash in add_paths_to_append_rel Andy Fan 04:48
Minor edit to src/bin/pg_upgrade/IMPLEMENTAION 📎 Gurjeet Singh 04:55
Re: Add a new BGWORKER_BYPASS_ROLELOGINCHECK flag 📎 Drouvot, Bertrand 04:57
Re: On login trigger: take three 📎 Alexander Korotkov 05:18
Re: Check each of base restriction clauses for constant-FALSE-or-NULL Richard Guo 05:39
Re: Check each of base restriction clauses for constant-FALSE-or-NULL Ashutosh Bapat 05:45
Re: Crash in add_paths_to_append_rel Richard Guo 05:49
Re: Crash in add_paths_to_append_rel Richard Guo 05:50
Re: Add const to values and nulls arguments Peter Eisentraut 05:57
Re: [Code Cleanup] : Small code cleanup in twophase.sql Nishant Sharma 05:57
Re: Add a new BGWORKER_BYPASS_ROLELOGINCHECK flag 📎 Michael Paquier 05:58
Re: Minor edit to src/bin/pg_upgrade/IMPLEMENTAION Michael Paquier 05:59
Re: [Code Cleanup] : Small code cleanup in twophase.sql Michael Paquier 06:04
Re: PGDOCS - add more links in the pub/sub reference pages vignesh C 06:10
Re: Fix output of zero privileges in psql Laurenz Albe 06:31
[PoC] run SQL over ciphertext Mingyu Li 06:42
Re: Pre-proposal: unicode normalized text Peter Eisentraut 06:44
Re: Pre-proposal: unicode normalized text Peter Eisentraut 06:47
Re: Add a new BGWORKER_BYPASS_ROLELOGINCHECK flag Drouvot, Bertrand 07:12
Re: Add a new BGWORKER_BYPASS_ROLELOGINCHECK flag Drouvot, Bertrand 07:18
Re: False "pg_serial": apparent wraparound” in logs Michael Paquier 07:20
Re: Add a new BGWORKER_BYPASS_ROLELOGINCHECK flag Michael Paquier 07:21
Re: Synchronizing slots from primary to standby Peter Smith 07:22
Re: Add a new BGWORKER_BYPASS_ROLELOGINCHECK flag Drouvot, Bertrand 07:26
Re: pg_resetwal: Corrections around -c option Peter Eisentraut 07:30
Re: [PoC] pg_upgrade: allow to upgrade publisher node Amit Kapila 07:40
Re: Add annotation syntax to pg_hba.conf entries Jim Jones 07:43
Re: Problem, partition pruning for prepared statement with IS NULL clause. tender wang 07:58
Re: Clean up some pg_dump tests 📎 Peter Eisentraut 08:03
Re: [PoC] run SQL over ciphertext Giampaolo Capelli 08:17
Retire has_multiple_baserels() 📎 Richard Guo 08:22
Re: Problem, partition pruning for prepared statement with IS NULL clause. Sergei Glukhov 08:31
Re: Check each of base restriction clauses for constant-FALSE-or-NULL Richard Guo 08:32
Re: Use virtual tuple slot for Unique node 📎 David Rowley 08:48
Fwd: Advice about preloaded libraries Esteban Zimanyi 08:58
Re: Check each of base restriction clauses for constant-FALSE-or-NULL David Rowley 09:10
Re: Add const to values and nulls arguments Aleksander Alekseev 09:14
Re: Retire has_multiple_baserels() Aleksander Alekseev 09:43
Re: Advice about preloaded libraries Aleksander Alekseev 10:01
Comparing two double values method 📎 Bowen Shi 10:31
Re: Making aggregate deserialization (and WAL receive) functions slightly faster vignesh C 10:34
Re: Check each of base restriction clauses for constant-FALSE-or-NULL Richard Guo 10:52
Re: pg_resetwal: Corrections around -c option Alvaro Herrera 10:53
Re: Comparing two double values method Matthias van de Meent 10:55
Re: Comparing two double values method Heikki Linnakangas 10:56
Re: Lowering the default wal_blocksize to 4K Matthias van de Meent 10:57
Re: Retire has_multiple_baserels() Richard Guo 11:01
Re: [PoC/RFC] Multiple passwords, interval expirations 📎 Gurjeet Singh 11:03
RE: [PoC] pg_upgrade: allow to upgrade publisher node 📎 Hayato Kuroda (Fujitsu) 11:21
RE: [PoC] pg_upgrade: allow to upgrade publisher node Hayato Kuroda (Fujitsu) 11:22
RE: [PoC] pg_upgrade: allow to upgrade publisher node Hayato Kuroda (Fujitsu) 11:23
Re: Infinite Interval 📎 Ashutosh Bapat 11:36
Re: Comparing two double values method Bowen Shi 12:12
Re: Request for comment on setting binary format output per session Dave Cramer 12:24
Re: PGDOCS - add more links in the pub/sub reference pages Amit Kapila 12:33
Re: [PoC] pg_upgrade: allow to upgrade publisher node Amit Kapila 12:47
Re: RFC: Logging plan of the running query 📎 torikoshia 13:27
Re: Pre-proposal: unicode normalized text Robert Haas 14:02
Re: CHECK Constraint Deferrable Robert Haas 14:12
Re: Comparing two double values method Tom Lane 14:13
Re: Request for comment on setting binary format output per session Robert Haas 14:25
Re: Request for comment on setting binary format output per session Dave Cramer 14:30
Re: Request for comment on setting binary format output per session Robert Haas 14:33
Re: Request for comment on setting binary format output per session Robert Haas 14:35
Re: On login trigger: take three Robert Haas 14:50
Re: [PATCH] hstore: Fix parsing on Mac OS X: isspace() is locale specific Evan Jones 14:51
Re: Fwd: Advice about preloaded libraries Alvaro Herrera 15:15
Re: On login trigger: take three Andres Freund 16:37
Fix typo in psql zh_CN.po 📎 jinser 17:11
Re: Retire has_multiple_baserels() Tom Lane 17:13
Suggestion. Optional local ORDER BY clause for DISTINCT ON Stefan Stefanov 17:21
Re: Check each of base restriction clauses for constant-FALSE-or-NULL Tom Lane 17:56
Re: Check each of base restriction clauses for constant-FALSE-or-NULL Tom Lane 18:24

Browse Archives

Prev | Next