pgsql-hackers since 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
Jump to day: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30

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
Re: Fix error handling in be_tls_open_server() Sergey Shinderuk 08:06
Re: Standardize type of variable when extending Buffers Peter Eisentraut 08:07
Re: [PoC] Reducing planning time when tables have many partitions Andrey Lepikhov 08:21
Re: Improvements in pg_dump/pg_restore toc format and performances Pierre Ducroquet 08:25
Re: pgbnech: allow to cancel queries during benchmark 📎 Yugo NAGATA 08:30
Re: [PATCH] Add native windows on arm64 support Peter Eisentraut 08:33
Re: Fix GIST readme on LSN vs NSN Heikki Linnakangas 08:57
Fix bug in VACUUM and ANALYZE docs 📎 Ryoga Yoshida 08:59
Re: Sync scan & regression tests 📎 Heikki Linnakangas 09:06
Re: Improve the log message output of basic_archive when basic_archive.archive_directory parameter is not set 📎 bt23nguyent 09:21
Re: Should we use MemSet or {0} for struct initialization? Peter Eisentraut 09:37
Re: XLog size reductions: Reduced XLog record header size for PG17 📎 Matthias van de Meent 10:07
Re: Improvements in pg_dump/pg_restore toc format and performances 📎 Pierre Ducroquet 10:15
Re: Move bki file pre-processing from initdb to bootstrap Peter Eisentraut 10:18
Re: remaining sql/json patches 📎 Alvaro Herrera 10:18
Re: Bug fix for psql's meta-command \ev Aleksander Alekseev 10:23
Re: Disabling Heap-Only Tuples Alvaro Herrera 10:26
Re: pg16: XX000: could not find pathkey item to sort 📎 Richard Guo 10:36
Re: remaining sql/json patches jian he 10:37
Re: Should we use MemSet or {0} for struct initialization? Richard Guo 10:39
Re: CHECK Constraint Deferrable Dean Rasheed 10:44
Re: Infinite Interval Dean Rasheed 11:14
Re: Standardize type of variable when extending Buffers Ranier Vilela 11:29
Re: remaining sql/json patches 📎 Amit Langote 11:56
Re: remaining sql/json patches Amit Langote 12:00
Re: Add last_commit_lsn to pg_stat_database Aleksander Alekseev 12:16
Re: [PoC] pg_upgrade: allow to upgrade publisher node 📎 Amit Kapila 12:27
Re: remaining sql/json patches Erik Rijkers 12:34
Re: [PATCH] Add native windows on arm64 support Anthony Roberts 12:35
Re: remaining sql/json patches 📎 Amit Langote 12:51
Re: tablecmds.c/MergeAttributes() cleanup 📎 Peter Eisentraut 13:11
Re: Improving btree performance through specializing by key shape, take 2 Matthias van de Meent 13:28
Re: RFC: Logging plan of the running query torikoshia 13:39
Re: pg_upgrade and logical replication 📎 vignesh C 13:44
RE: pg_ctl start may return 0 even if the postmaster has been already started on Windows 📎 Hayato Kuroda (Fujitsu) 13:48
Re: POC PATCH: copy from ... exceptions to: (was Re: VLDB Features) torikoshia 14:00
Re: Add pg_basetype() function to obtain a DOMAIN base type Steve Chavez 14:20
Re: pg_resetwal tests, logging, and docs update 📎 Peter Eisentraut 14:31
Projection pushdown to index access method Chris Cleveland 14:32
Relation bulk write facility 📎 Heikki Linnakangas 15:13
Re: CREATE FUNCTION ... SEARCH { DEFAULT | SYSTEM | SESSION } Robert Haas 15:41
Re: Checks in RegisterBackgroundWorker.() Heikki Linnakangas 15:47
Re: Disabling Heap-Only Tuples Robert Haas 16:09
Re: dikkop seems unhappy because of openssl stuff (FreeBSD 14-BETA1) Tomas Vondra 16:11
Re: dikkop seems unhappy because of openssl stuff (FreeBSD 14-BETA1) Tomas Vondra 16:21
Re: Fixing tab-complete for dollar-names Heikki Linnakangas 16:30
Re: Disabling Heap-Only Tuples Alvaro Herrera 16:30
Re: dikkop seems unhappy because of openssl stuff (FreeBSD 14-BETA1) Tom Lane 16:45
Re: Disabling Heap-Only Tuples Robert Haas 16:52
Re: Disabling Heap-Only Tuples Andres Freund 16:56
Re: Projection pushdown to index access method Robert Haas 17:10
Re: Disabling Heap-Only Tuples Matthias van de Meent 17:33
Re: Projection pushdown to index access method Tom Lane 17:46
Re: GenBKI emits useless open;close for catalogs without rows 📎 Heikki Linnakangas 18:05
Re: Disabling Heap-Only Tuples Matthias van de Meent 18:20
Re: Disabling Heap-Only Tuples Robert Haas 18:50
Re: Disabling Heap-Only Tuples Andres Freund 18:55
Re: dikkop seems unhappy because of openssl stuff (FreeBSD 14-BETA1) Tomas Vondra 19:40
Re: Improving btree performance through specializing by key shape, take 2 Peter Geoghegan 20:48
Re: Extensible storage manager API - SMGR hook Redux 📎 Tristan Partin 20:54
Re: Disabling Heap-Only Tuples Robert Haas 21:08
Re: [PATCH] Add inline comments to the pg_hba_file_rules view 📎 Jim Jones 22:29
Re: [PATCH] Add native windows on arm64 support Michael Paquier 22:59
Re: dikkop seems unhappy because of openssl stuff (FreeBSD 14-BETA1) Tom Lane 23:24
Re: CREATE FUNCTION ... SEARCH { DEFAULT | SYSTEM | SESSION } Jeff Davis 23:56

Sept. 20, 2023

Thread Author Time
Re: Bug fix for psql's meta-command \ev Michael Paquier 00:32

Browse Archives

Prev | Next
Jump to day: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30