pgsql-hackers since 2023-09-18 21:54

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

Sept. 18, 2023

Thread Author Time
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
Re: pg_upgrade and logical replication Michael Paquier 00:38
Re: Fix bug in VACUUM and ANALYZE docs Shinya Kato 00:43
Re: Move global variables of pgoutput to plugin private scope. Peter Smith 01:42
Re: Inefficiency in parallel pg_restore with many tables Nathan Bossart 02:30
Re: pg_rewind with cascade standby doesn't work well 📎 Kuwamura Masaki 02:46
Re: SQL:2011 application time 📎 Paul Jungwirth 02:50
Re: Disabling Heap-Only Tuples Laurenz Albe 03:02
Re: pg_rewind with cascade standby doesn't work well Michael Paquier 03:04
Re: remaining sql/json patches Amit Langote 03:07
Re: Disabling Heap-Only Tuples Laurenz Albe 03:18
Re: CREATE FUNCTION ... SEARCH { DEFAULT | SYSTEM | SESSION } Maciek Sakrejda 03:23
Re: [PATCH] Clarify the behavior of the system when approaching XID wraparound Peter Geoghegan 03:41
Re: Fix bug in VACUUM and ANALYZE docs Michael Paquier 04:39
Re: Using Btree to Provide Sorting on Suffix Keys with LIMIT Peter Geoghegan 05:04
Re: XLog size reductions: Reduced XLog record header size for PG17 Michael Paquier 05:06
Re: Bug fix for psql's meta-command \ev Ryoga Yoshida 05:08
Re: pg_ctl start may return 0 even if the postmaster has been already started on Windows Kyotaro Horiguchi 05:18
RE: [PoC] pg_upgrade: allow to upgrade publisher node 📎 Hayato Kuroda (Fujitsu) 05:30
Re: RFC: Logging plan of the running query Lepikhov Andrei 05:39
Re: Questioning an errcode and message in jsonb.c Peter Eisentraut 05:50
Re: [PoC] pg_upgrade: allow to upgrade publisher node Dilip Kumar 06:21
Re: CREATE FUNCTION ... SEARCH { DEFAULT | SYSTEM | SESSION } Maciek Sakrejda 06:25
Re: [PoC] pg_upgrade: allow to upgrade publisher node Amit Kapila 06:42
Re: [PoC] pg_upgrade: allow to upgrade publisher node Amit Kapila 06:46
Re: Oversight in reparameterize_path_by_child leading to executor crash Andrey Lepikhov 07:18
Re: disfavoring unparameterized nested loops Andrey Lepikhov 07:56
Re: Show WAL write and fsync stats in pg_stat_io 📎 Nazir Bilal Yavuz 07:57
Re: pg_rewind with cascade standby doesn't work well Fujii Masao 08:27
Re: [PoC] pg_upgrade: allow to upgrade publisher node Dilip Kumar 08:35
Re: Fix error handling in be_tls_open_server() 📎 Daniel Gustafsson 08:42
Re: CREATE FUNCTION ... SEARCH { DEFAULT | SYSTEM | SESSION } Pavel Stehule 08:46
Re: Fix error handling in be_tls_open_server() Sergey Shinderuk 08:55
Re: Fix error handling in be_tls_open_server() Daniel Gustafsson 08:58
Re: There should be a way to use the force flag when restoring databases Peter Eisentraut 09:24
Re: POC, WIP: OR-clause support for indexes Peter Eisentraut 09:37
Re: bug fix and documentation improvement about vacuumdb 📎 Kuwamura Masaki 09:46
Re: disfavoring unparameterized nested loops David Rowley 09:49
Re: logical decoding and replication of sequences, take 2 Dilip Kumar 09:53
Re: [PoC] Reducing planning time when tables have many partitions Yuya Watari 10:04
Comment about set_join_pathlist_hook() 📎 Etsuro Fujita 10:05
Re: [PoC] pg_upgrade: allow to upgrade publisher node Amit Kapila 10:11
Re: Infinite Interval 📎 jian he 10:27
Re: Comment about set_join_pathlist_hook() David Rowley 10:49
Re: [PoC] Reducing planning time when tables have many partitions Ashutosh Bapat 11:03
Re: bug fix and documentation improvement about vacuumdb Daniel Gustafsson 11:17
Re: persist logical slots to disk during shutdown checkpoint Ashutosh Bapat 11:18
Re: persist logical slots to disk during shutdown checkpoint Michael Paquier 11:24
Re: pg_upgrade and logical replication Amit Kapila 11:24
RE: [PoC] pg_upgrade: allow to upgrade publisher node 📎 Hayato Kuroda (Fujitsu) 11:28
RE: [PoC] pg_upgrade: allow to upgrade publisher node Hayato Kuroda (Fujitsu) 11:30
Re: Memory consumed by child SpecialJoinInfo in partitionwise join planning Amit Langote 11:54
Re: There should be a way to use the force flag when restoring databases Daniel Gustafsson 11:57
Re: POC, WIP: OR-clause support for indexes a.rybakina 12:06
Re: Infinite Interval Dean Rasheed 12:09
Re: should frontend tools use syncfs() ? 📎 Maxim Orlov 12:12
Re: Infinite Interval Dean Rasheed 12:13
Re: Improve the log message output of basic_archive when basic_archive.archive_directory parameter is not set Daniel Gustafsson 12:14
Dump-restore loosing 'attnotnull' bit for DEFERRABLE PRIMARY KEY column(s). Amul Sul 12:58
Re: Memory consumed by child SpecialJoinInfo in partitionwise join planning Ashutosh Bapat 13:24
Re: Infinite Interval Ashutosh Bapat 13:29
Re: Parallel Bitmap Heap Scan reports per-worker stats in EXPLAIN ANALYZE David Geier 13:42
Re: Infinite Interval 📎 Ashutosh Bapat 14:00
Re: Infinite Interval Ashutosh Bapat 14:00
Re: Disabling Heap-Only Tuples Stephen Frost 14:02
Re: Index range search optimization 📎 Alexander Korotkov 14:07
Re: Infinite Interval Dean Rasheed 14:53
Re: Dump-restore loosing 'attnotnull' bit for DEFERRABLE PRIMARY KEY column(s). Alvaro Herrera 14:59
Re: disfavoring unparameterized nested loops Lepikhov Andrei 15:17
Re: POC PATCH: copy from ... exceptions to: (was Re: VLDB Features) 📎 Damir 16:15
pg_upgrade --check fails to warn about abstime 📎 Alvaro Herrera 16:54
Re: pg_upgrade --check fails to warn about abstime Tristan Partin 17:45
Re: pg_upgrade --check fails to warn about abstime Alvaro Herrera 17:58
Re: dikkop seems unhappy because of openssl stuff (FreeBSD 14-BETA1) Tomas Vondra 17:59
Re: dikkop seems unhappy because of openssl stuff (FreeBSD 14-BETA1) Tomas Vondra 18:09
Re: pg_upgrade --check fails to warn about abstime Tristan Partin 18:13
Re: should frontend tools use syncfs() ? Nathan Bossart 19:07
Re: remaining sql/json patches Andrew Dunstan 19:14
Re: Add 'worker_type' to pg_stat_subscription 📎 Nathan Bossart 19:30
Re: New WAL record to detect the checkpoint redo location 📎 Robert Haas 20:20
Re: LLVM 16 (opaque pointers) 📎 Thomas Munro 20:22
Re: Improvements in pg_dump/pg_restore toc format and performances Nathan Bossart 20:29
Guiding principle for dropping LLVM versions? Thomas Munro 22:54
Re: Add 'worker_type' to pg_stat_subscription Peter Smith 23:01
Re: pg_upgrade and logical replication Michael Paquier 23:08
Re: Add 'worker_type' to pg_stat_subscription Michael Paquier 23:14
Re: Add 'worker_type' to pg_stat_subscription Nathan Bossart 23:34

Sept. 21, 2023

Thread Author Time
Re: Add 'worker_type' to pg_stat_subscription Peter Smith 00:06
Re: LLVM 16 (opaque pointers) Devrim Gündüz 00:24
Re: Guiding principle for dropping LLVM versions? Devrim Gündüz 00:27
Re: LLVM 16 (opaque pointers) Thomas Munro 00:47
Re: Memory consumed by child SpecialJoinInfo in partitionwise join planning Amit Langote 01:06
Bug fix in vacuumdb --buffer-usage-limit xxx -Z 📎 Ryoga Yoshida 01:44
Re: bug fix and documentation improvement about vacuumdb 📎 Kuwamura Masaki 01:53
Re: Improve the log message output of basic_archive when basic_archive.archive_directory parameter is not set 📎 bt23nguyent 02:18
Re: Bug fix in vacuumdb --buffer-usage-limit xxx -Z Michael Paquier 02:32
Re: Comment about set_join_pathlist_hook() Lepikhov Andrei 02:49
Re: Infinite Interval 📎 jian he 03:05
CI: Unfamiliar error while testing macOS Hayato Kuroda (Fujitsu) 03:25

Browse Archives

Prev | Next