pgsql-hackers before 2023-07-01 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)

Browse Archives

Prev | Next

June 28, 2023

Thread Author Time
Re: Incremental View Maintenance, take 2 jian he 16:40
Re: Detecting use-after-free bugs using gcc's malloc() attribute Andres Freund 18:15
Document efficient self-joins / UPDATE LIMIT techniques. 📎 Corey Huinker 18:20
Re: Changing types of block and chunk sizes in memory contexts Tomas Vondra 21:26
Re: several attstattarget-related improvements Tomas Vondra 21:30
Re: POC, WIP: OR-clause support for indexes Tomas Vondra 21:45
Re: Problems with estimating OR conditions, IS NULL on LEFT JOINs Tomas Vondra 21:53
Re: Changing types of block and chunk sizes in memory contexts Tom Lane 21:56
Re: several attstattarget-related improvements Tom Lane 22:10
Re: Row pattern recognition Vik Fearing 22:30
Re: Add GUC to tune glibc's malloc implementation. Andres Freund 22:31
vacuumdb/clusterdb/reindexdb: allow specifying objects to process in all databases 📎 Nathan Bossart 23:24
Re: Changing types of block and chunk sizes in memory contexts Andres Freund 23:34
Add more sanity checks around callers of changeDependencyFor() 📎 Michael Paquier 23:36
Re: Changing types of block and chunk sizes in memory contexts Andres Freund 23:42

June 29, 2023

Thread Author Time
Re: Another incorrect comment for pg_stat_statements Michael Paquier 00:19
Re: [PATCH] Honor PG_TEST_NOCLEAN for tempdirs Michael Paquier 00:40
Re: Another incorrect comment for pg_stat_statements Japin Li 00:44
Re: pg_rewind WAL segments deletion pitfall Kyotaro Horiguchi 01:25
Re: POC, WIP: OR-clause support for indexes 📎 Ranier Vilela 01:36
RE: add \dpS to psq [16beta1] 📎 Shinoda, Noriyoshi (PN Japan FSIP) 02:11
Re: Assert !bms_overlap(joinrel->relids, required_outer) Richard Guo 02:39
Re: [PGdocs] fix description for handling pf non-ASCII characters jian he 02:58
Trivial revise for the check of parameterized partial paths 📎 Richard Guo 03:23
Re: Another incorrect comment for pg_stat_statements Richard Guo 03:25
Re: Changing types of block and chunk sizes in memory contexts David Rowley 03:46
Re: pg_decode_message vs skip_empty_xacts and xact_wrote_changes 📎 vignesh C 04:05
Re: harmonize password reuse in vacuumdb, clusterdb, and reindexdb Gurjeet Singh 04:20
RE: pg_decode_message vs skip_empty_xacts and xact_wrote_changes Zhijie Hou (Fujitsu) 04:28
Re: add \dpS to psq [16beta1] Nathan Bossart 04:38
Re: vacuumdb/clusterdb/reindexdb: allow specifying objects to process in all databases Kyotaro Horiguchi 05:16
Re: harmonize password reuse in vacuumdb, clusterdb, and reindexdb Nathan Bossart 05:24
Re: POC, WIP: OR-clause support for indexes 📎 Alena Rybakina 05:50
Re: POC, WIP: OR-clause support for indexes 📎 Alena Rybakina 06:10
Re: Assert !bms_overlap(joinrel->relids, required_outer) Richard Guo 06:44
Re: Do we want a hashset type? 📎 jian he 06:54
Re: Add more sanity checks around callers of changeDependencyFor() 📎 Heikki Linnakangas 07:06
Re: ReadRecentBuffer() doesn't scale well 📎 Thomas Munro 07:35
Re: Assert !bms_overlap(joinrel->relids, required_outer) Richard Guo 07:39
Unified File API 📎 John Morris 07:50
RE: [PGdocs] fix description for handling pf non-ASCII characters 📎 Hayato Kuroda (Fujitsu) 07:51
Re: Do we want a hashset type? 📎 Joel Jacobson 08:43
Does a cancelled REINDEX CONCURRENTLY need to be messy? Thom Brown 09:13
Re: POC, WIP: OR-clause support for indexes 📎 Alena Rybakina 09:32
Re: pg_rewind WAL segments deletion pitfall torikoshia 09:42
Re: POC, WIP: OR-clause support for indexes Alena Rybakina 09:55
Re: Changing types of block and chunk sizes in memory contexts Tomas Vondra 09:58
Re: Incremental View Maintenance, take 2 jian he 10:20
RE: Synchronizing slots from primary to standby Hayato Kuroda (Fujitsu) 10:22
Re: Synchronizing slots from primary to standby Amit Kapila 10:36
Re: Synchronizing slots from primary to standby Amit Kapila 10:45
Re: Incremental View Maintenance, take 2 jian he 10:51
Re: tablecmds.c/MergeAttributes() cleanup Alvaro Herrera 11:03
Re: Does a cancelled REINDEX CONCURRENTLY need to be messy? Andreas Karlsson 11:04
Re: Does a cancelled REINDEX CONCURRENTLY need to be messy? Tom Lane 11:17
Re: Meson build updates Peter Eisentraut 11:18
Re: POC, WIP: OR-clause support for indexes Ranier Vilela 11:23
Re: Memory leak in incremental sort re-scan Laurenz Albe 11:49
Re: Incremental View Maintenance, take 2 jian he 12:21
Re: POC, WIP: OR-clause support for indexes 📎 Ranier Vilela 12:25
Re: Meson build updates Tristan Partin 13:15
Re: Does a cancelled REINDEX CONCURRENTLY need to be messy? Álvaro Herrera 13:45
plan_create_index_workers doesn't account for TOAST Jonathan S. Katz 14:12
Re: POC, WIP: OR-clause support for indexes 📎 Alena Rybakina 15:15
Re: POC, WIP: OR-clause support for indexes Alena Rybakina 15:16
Re: pgsql: Fix search_path to a safe value during maintenance operations. Robert Haas 15:19
Re: ReadRecentBuffer() doesn't scale well Andres Freund 15:39
Re: [PATCH] Honor PG_TEST_NOCLEAN for tempdirs Jacob Champion 16:05
Re: pg_decode_message vs skip_empty_xacts and xact_wrote_changes vignesh C 16:09
Re: Assert !bms_overlap(joinrel->relids, required_outer) Tom Lane 16:16
Re: Assert !bms_overlap(joinrel->relids, required_outer) Tom Lane 16:20
Re: pg_dump needs SELECT privileges on irrelevant extension table 📎 Jacob Champion 16:24
Re: [PoC] Federated Authn/z with OAUTHBEARER Jacob Champion 16:28
Re: Meson build updates 📎 Andres Freund 17:35
pg_upgrade instructions involving "rsync --size-only" might lead to standby corruption? Nikolay Samokhvalov 17:50
Re: Meson build updates 📎 Tristan Partin 18:34
Re: pg_upgrade instructions involving "rsync --size-only" might lead to standby corruption? Robert Haas 18:38
Re: Meson build updates Andres Freund 18:58
Re: Meson build updates Andres Freund 19:02
Re: Meson build updates Tristan Partin 19:03
Re: Meson build updates Tristan Partin 19:07
Re: pgsql: Fix search_path to a safe value during maintenance operations. Andrew Dunstan 19:08
Re: Meson build updates Andres Freund 19:13
Re: pg_waldump: add test for coverage Tristen Raab 19:16
Re: Meson build updates Tristan Partin 19:17
Re: plan_create_index_workers doesn't account for TOAST Jonathan S. Katz 19:51
Re: pgsql: Fix search_path to a safe value during maintenance operations. Nathan Bossart 20:29
Re: vacuumdb/clusterdb/reindexdb: allow specifying objects to process in all databases Nathan Bossart 20:56
Re: harmonize password reuse in vacuumdb, clusterdb, and reindexdb Nathan Bossart 21:05
Re: RFC: logical publication via inheritance root? 📎 Jacob Champion 23:46

June 30, 2023

Thread Author Time
Re: Incremental View Maintenance, take 2 jian he 00:00
Re: [PATCH] Using named captures in Catalog::ParseHeader() Michael Paquier 00:26
Re: Changing types of block and chunk sizes in memory contexts Andres Freund 00:29
Re: pgsql: Fix search_path to a safe value during maintenance operations. 📎 Jeff Davis 00:36
Re: pgsql: Fix search_path to a safe value during maintenance operations. Tom Lane 00:53
Re: Tab completion for CREATE SCHEMAAUTHORIZATION Michael Paquier 01:36
Re: Making empty Bitmapsets always be NULL 📎 Yuya Watari 02:10
Re: ReadRecentBuffer() doesn't scale well 📎 Thomas Munro 02:13
Re: BUG #17946: LC_MONETARY & DO LANGUAGE plperl - BUG Tristan Partin 02:13
Re: Assert while autovacuum was executing Amit Kapila 02:56
Re: Assert !bms_overlap(joinrel->relids, required_outer) Richard Guo 03:02
Re: vacuumdb/clusterdb/reindexdb: allow specifying objects to process in all databases Kyotaro Horiguchi 03:05
Re: Assert !bms_overlap(joinrel->relids, required_outer) Richard Guo 03:05
Re: ReadRecentBuffer() doesn't scale well Andres Freund 03:09
Re: pg_decode_message vs skip_empty_xacts and xact_wrote_changes Amit Kapila 04:08
Re: pg_decode_message vs skip_empty_xacts and xact_wrote_changes Amit Kapila 04:25
Re: Do we want a hashset type? jian he 04:50
Re: pgsql: Fix search_path to a safe value during maintenance operations. 📎 Nathan Bossart 05:09
Re: vacuumdb/clusterdb/reindexdb: allow specifying objects to process in all databases Nathan Bossart 05:13
Re: Synchronizing slots from primary to standby Drouvot, Bertrand 05:55
Re: Synchronizing slots from primary to standby Drouvot, Bertrand 06:09
Re: Todo: Teach planner to evaluate multiple windows in the optimal order 📎 John Naylor 06:45
Re: Allow pg_archivecleanup to remove backup history files Michael Paquier 06:48
Re: ExecRTCheckPerms() and many prunable partitions (checkAsUser) Amit Langote 06:54
Re: Support logical replication of DDLs 📎 shveta malik 07:06
Re: [PATCH] Honor PG_TEST_NOCLEAN for tempdirs Michael Paquier 07:09
Re: pgsql: Fix search_path to a safe value during maintenance operations. Jeff Davis 07:41
Re: [PATCH] Honor PG_TEST_NOCLEAN for tempdirs Daniel Gustafsson 07:42
Re: PG 16 draft release notes ready Masahiro Ikeda 08:29
Re: [HACKERS] make async slave to wait for lsn to be replayed 📎 Картышов Иван 08:32
Re: Tab completion for CREATE SCHEMAAUTHORIZATION Dagfinn Ilmari Mannsåker 09:33
Re: [PATCH] Using named captures in Catalog::ParseHeader() Dagfinn Ilmari Mannsåker 09:34
Extension Enhancement: Buffer Invalidation in pg_buffercache 📎 Palak Chaturvedi 10:46
Re: Removing unneeded self joins 📎 Andrey Lepikhov 10:50
Re: EBCDIC sorting as a use case for ICU rules 📎 Daniel Verite 11:08
Re: index prefetching 📎 Tomas Vondra 11:38
Re: cataloguing NOT NULL constraints 📎 Alvaro Herrera 11:44
Re: BUG #17946: LC_MONETARY & DO LANGUAGE plperl - BUG Joe Conway 12:13
Extensible storage manager API - SMGR hook Redux 📎 Matthias van de Meent 12:26
RE: [PoC] pg_upgrade: allow to upgrade publisher node Hayato Kuroda (Fujitsu) 13:58
SPI isolation changes Seino Yuki 14:15
Re: Avoid unused value (src/fe_utils/print.c) Karina Litskevich 14:25
Re: SPI isolation changes Heikki Linnakangas 14:26
Re: SPI isolation changes Seino Yuki 14:56
Re: Assert !bms_overlap(joinrel->relids, required_outer) Tom Lane 15:00
Re: SPI isolation changes Tom Lane 15:06
On /*----- comments Heikki Linnakangas 15:07
Re: On /*----- comments Tom Lane 15:22
Re: XLog size reductions: Reduced XLog record header size for PG17 📎 Matthias van de Meent 15:36
Re: ProcessStartupPacket(): database_name and user_name truncation Nathan Bossart 15:42
[PATCH] pgrowlocks: Make mode names consistent with docs 📎 David Cook 15:45
Re: ProcessStartupPacket(): database_name and user_name truncation Tom Lane 15:54
Re: Avoid unused value (src/fe_utils/print.c) Alexander Lakhin 16:00
Re: Avoid unused value (src/fe_utils/print.c) Ranier Vilela 16:15
Re: Avoid unused value (src/fe_utils/print.c) Ranier Vilela 16:20
Re: SPI isolation changes Seino Yuki 16:21
Re: SPI isolation changes Tom Lane 16:47
Re: ProcessStartupPacket(): database_name and user_name truncation Drouvot, Bertrand 17:32
Initdb-time block size specification 📎 David Christensen 17:35
Re: pg_upgrade instructions involving "rsync --size-only" might lead to standby corruption? Bruce Momjian 17:41
Re: Adding SHOW CREATE TABLE Kirk Wolak 17:56
Re: sslinfo extension - add notbefore and notafter timestamps 📎 Cary Huang 18:12
Re: Initdb-time block size specification Tomas Vondra 18:14
Re: Move un-parenthesized syntax docs to "compatibility" for few SQL commands Nathan Bossart 18:25
Re: pgsql: Fix search_path to a safe value during maintenance operations. Nathan Bossart 18:35
Re: Avoid unncessary always true test (src/backend/storage/buffer/bufmgr.c) 📎 Karina Litskevich 18:48
Re: Initdb-time block size specification David Christensen 19:09
Re: Initdb-time block size specification Andres Freund 19:39
Should we remove db_user_namespace? 📎 Nathan Bossart 20:05
Re: Initdb-time block size specification David Christensen 20:05
Re: pg_upgrade instructions involving "rsync --size-only" might lead to standby corruption? Robert Haas 20:16
Re: Initdb-time block size specification Andres Freund 20:27
Re: Should we remove db_user_namespace? 📎 Nathan Bossart 20:42
Re: Initdb-time block size specification Andres Freund 21:11
Re: Initdb-time block size specification Tomas Vondra 21:12
Re: Initdb-time block size specification Tomas Vondra 21:27
Re: Initdb-time block size specification David Christensen 21:28
Re: Should we remove db_user_namespace? Bruce Momjian 21:29
Re: Initdb-time block size specification David Christensen 21:29
Re: pg_upgrade instructions involving "rsync --size-only" might lead to standby corruption? Bruce Momjian 21:33
Re: Initdb-time block size specification David Christensen 21:33
Re: PG 16 draft release notes ready Bruce Momjian 21:36
Re: [PATCH] Extend the length of BackgroundWorker.bgw_library_name 📎 Nathan Bossart 21:39
Re: Should we remove db_user_namespace? Tom Lane 21:40
Re: Initdb-time block size specification David Christensen 21:40
Re: Initdb-time block size specification Tomas Vondra 21:42
Re: Should we remove db_user_namespace? Nathan Bossart 21:42
Re: Should we remove db_user_namespace? Nathan Bossart 21:43
Re: Initdb-time block size specification Bruce Momjian 21:53
Re: Initdb-time block size specification Andres Freund 22:05
Re: Extension Enhancement: Buffer Invalidation in pg_buffercache Thomas Munro 22:09
Re: Should we remove db_user_namespace? Magnus Hagander 22:13
Re: pg_upgrade instructions involving "rsync --size-only" might lead to standby corruption? Nikolay Samokhvalov 22:18
Re: Initdb-time block size specification Andres Freund 22:20
Re: Initdb-time block size specification Tomas Vondra 22:21
Re: Should we remove db_user_namespace? Nathan Bossart 22:27
Re: pg_upgrade instructions involving "rsync --size-only" might lead to standby corruption? Bruce Momjian 22:36
Re: Initdb-time block size specification Bruce Momjian 22:37
Re: Initdb-time block size specification Andres Freund 22:51
Re: Initdb-time block size specification Tomas Vondra 22:56
Re: Initdb-time block size specification Bruce Momjian 22:58
Re: Initdb-time block size specification Andres Freund 22:59
Re: Initdb-time block size specification Bruce Momjian 23:01
Re: Initdb-time block size specification Andres Freund 23:04
Re: Initdb-time block size specification Tomas Vondra 23:13
Re: Initdb-time block size specification Bruce Momjian 23:16
Re: Initdb-time block size specification Tomas Vondra 23:18
Re: Initdb-time block size specification Bruce Momjian 23:26
Re: Initdb-time block size specification Andres Freund 23:44
RFC: pg_stat_logmsg 📎 Joe Conway 23:57

Browse Archives

Prev | Next