pgsql-hackers since 2023-06-30 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

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

July 1, 2023

Thread Author Time
Re: cataloguing NOT NULL constraints Andres Freund 01:12
Re: Synchronizing slots from primary to standby Amit Kapila 01:42
Re: Extensible storage manager API - SMGR hook Redux Andres Freund 01:50
Re: RFC: pg_stat_logmsg Pavel Stehule 03:20
Re: [PoC] Federated Authn/z with OAUTHBEARER Thomas Munro 04:28
Re: pg_upgrade and logical replication vignesh C 05:09
Re: Schema variables - new implementation for Postgres 15 📎 Pavel Stehule 05:13
Outdated description of PG_CACHE_LINE_SIZE 📎 Julien Rouhaud 07:49
Re: pg_upgrade instructions involving "rsync --size-only" might lead to standby corruption? Andrey M. Borodin 09:02
Re: Do we want a hashset type? Joel Jacobson 09:04
Re: MERGE ... RETURNING 📎 Dean Rasheed 11:07
Re: SPI isolation changes Seino Yuki 11:31
Re: MERGE ... WHEN NOT MATCHED BY SOURCE 📎 Dean Rasheed 12:33
possible bug in handling of contrecords in dd38ff28ad (Fix recovery_prefetch with low maintenance_io_concurrency) Tomas Vondra 13:40
Re: ProcessStartupPacket(): database_name and user_name truncation 📎 Drouvot, Bertrand 14:02
Re: Preventing non-superusers from altering session authorization Joseph Koshakow 15:33
Re: check_strxfrm_bug() Noah Misch 16:25
Re: Does a cancelled REINDEX CONCURRENTLY need to be messy? Thom Brown 16:39
Re: ICU locale validation / canonicalization Noah Misch 17:31
Re: RFC: pg_stat_logmsg 📎 Joe Conway 19:52
Re: Adding SHOW CREATE TABLE Kirk Wolak 21:41

July 2, 2023

Thread Author Time
Re: Incremental View Maintenance, take 2 jian he 00:25
Re: possible bug in handling of contrecords in dd38ff28ad (Fix recovery_prefetch with low maintenance_io_concurrency) 📎 Thomas Munro 02:09
Re: Incremental View Maintenance, take 2 jian he 02:38
Re: Incremental sort for access method with ordered scan support (amcanorderbyop) 📎 Miroslav Bendik 04:02
Re: Should CSV parsing be stricter about mid-field quotes? Noah Misch 05:45
Re: Fdw batch insert error out when set batch_size > 65535 Andres Freund 06:09
Re: Supporting MERGE on updatable views 📎 Dean Rasheed 10:29
/src/include/access/htup_details.h some comments kind of confusing.... jian he 11:56
pg_basebackup check vs Windows file path limits Andrew Dunstan 13:15
Re: Fdw batch insert error out when set batch_size > 65535 Tom Lane 13:23
Re: Fdw batch insert error out when set batch_size > 65535 Tomas Vondra 13:50
Re: [PATCH] Extend ALTER OPERATOR to support adding commutator, negator, hashes, and merges 📎 Tommy Pavlicek 14:42
Improve tab completion for ALTER DEFAULT PRIVILEGE and ALTER TABLE 📎 vignesh C 15:12
Re: BRIN indexes vs. SK_SEARCHARRAY (and preprocessing scan keys) 📎 Tomas Vondra 16:09
010_database.pl fails on openbsd w/ LC_ALL=LANG=C Andres Freund 16:56
Replacing abort() with __builtin_trap()? Andres Freund 17:41
Re: Replacing abort() with __builtin_trap()? Tom Lane 17:55
Re: Replacing abort() with __builtin_trap()? Andres Freund 18:09
Re: possible bug in handling of contrecords in dd38ff28ad (Fix recovery_prefetch with low maintenance_io_concurrency) Tomas Vondra 18:12
Re: Memory leak in incremental sort re-scan Tomas Vondra 18:13
Optionally using a better backtrace library? Andres Freund 18:31
Re: Optionally using a better backtrace library? Pavel Stehule 18:34
Re: Memory leak in incremental sort re-scan Laurenz Albe 19:52
Re: memory leak in trigger handling (since PG12) Tomas Vondra 20:26
Re: Optionally using a better backtrace library? Joe Conway 20:34
Re: Making empty Bitmapsets always be NULL 📎 David Rowley 21:27
Re: Replacing abort() with __builtin_trap()? Tom Lane 21:50
Re: possible bug in handling of contrecords in dd38ff28ad (Fix recovery_prefetch with low maintenance_io_concurrency) Thomas Munro 23:32
Re: [PATCH] Extend the length of BackgroundWorker.bgw_library_name Yurii Rashkovskii 23:37

July 3, 2023

Thread Author Time
Re: Making empty Bitmapsets always be NULL 📎 David Rowley 00:09
Re: Remove WindowClause PARTITION BY items belonging to redundant pathkeys David Rowley 00:50
Re: [PATCH] Honor PG_TEST_NOCLEAN for tempdirs Michael Paquier 01:17
Re: Skip collecting decoded changes of already-aborted transactions 📎 Masahiko Sawada 01:45
Re: check_strxfrm_bug() Thomas Munro 01:49
Re: ProcessStartupPacket(): database_name and user_name truncation Kyotaro Horiguchi 01:50
Re: ProcessStartupPacket(): database_name and user_name truncation Kyotaro Horiguchi 02:09
doc: improve the restriction description of using indexes on REPLICA IDENTITY FULL table. 📎 Masahiko Sawada 02:15
Performance degradation on concurrent COPY into a single relation in PG16. 📎 Masahiko Sawada 02:55
Re: Performance degradation on concurrent COPY into a single relation in PG16. 📎 Masahiko Sawada 02:59
Re: pgsql: Fix search_path to a safe value during maintenance operations. Noah Misch 03:57
Re: [PATCH] Reuse Workers and Replication Slots during Logical Replication Amit Kapila 04:12
Re: Cleaning up array_in() jian he 04:16
Re: Introduce WAIT_EVENT_EXTENSION and WAIT_EVENT_BUFFER_PIN Michael Paquier 04:18
Re: Cutting support for OpenSSL 1.0.1 and 1.0.2 in 17~? Michael Paquier 04:26
Re: Optionally using a better backtrace library? Kyotaro Horiguchi 04:46
Re: several attstattarget-related improvements Peter Eisentraut 05:26
Re: generate syscache info automatically 📎 Peter Eisentraut 05:45
Re: Assert !bms_overlap(joinrel->relids, required_outer) Richard Guo 05:53
Re: [PATCH] Reuse Workers and Replication Slots during Logical Replication Amit Kapila 05:58
Re: Making empty Bitmapsets always be NULL Yuya Watari 06:10
Re: Make uselocale protection more consistent Peter Eisentraut 06:13
Re: Fix last unitialized memory warning Peter Eisentraut 06:19
Re: Make uselocale protection more consistent Thomas Munro 06:24
Re: Add information about command path and version of flex in meson output Peter Eisentraut 06:34
Re: Should heapam_estimate_rel_size consider fillfactor? Peter Eisentraut 06:46
Re: Fix regression tests to work with REGRESS_OPTS=--no-locale Peter Eisentraut 06:48
Re: Autogenerate some wait events code and documentation 📎 Michael Paquier 06:57
Re: Should heapam_estimate_rel_size consider fillfactor? Tomas Vondra 07:00
Re: Autogenerate some wait events code and documentation Michael Paquier 07:11
Re: Fix regression tests to work with REGRESS_OPTS=--no-locale Michael Paquier 07:17
Re: Should we remove db_user_namespace? Michael Paquier 07:20
Re: pgbench: option delaying queries till connections establishment? Fabien COELHO 07:24
Re: Cleaning up threading code Peter Eisentraut 07:29
Re: Add information about command path and version of flex in meson output 📎 Michael Paquier 07:30
Re: Performance degradation on concurrent COPY into a single relation in PG16. Heikki Linnakangas 07:36
Re: pg_upgrade --copy-file-range Peter Eisentraut 07:47
Re: Performance degradation on concurrent COPY into a single relation in PG16. Masahiko Sawada 07:54
Re: Add information about command path and version of flex in meson output Peter Eisentraut 08:17
Re: Extension Enhancement: Buffer Invalidation in pg_buffercache 📎 Palak Chaturvedi 08:26

Browse Archives

Prev | Next