pgsql-hackers - July 2023

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

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 31

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
Re: CI and test improvements Peter Eisentraut 08:37
Re: Cleaning up threading code πŸ“Ž Heikki Linnakangas 08:43
Re: On /*----- comments Daniel Gustafsson 08:48
Re: Outdated description of PG_CACHE_LINE_SIZE Heikki Linnakangas 09:01
Re: patch: improve "user mapping not found" error message Peter Eisentraut 09:22
Re: Outdated description of PG_CACHE_LINE_SIZE Julien Rouhaud 09:24
Re: Should heapam_estimate_rel_size consider fillfactor? Tomas Vondra 09:40
Re: Improve list manipulation in several places Peter Eisentraut 09:41
Re: [PATCH] Remove unnecessary unbind in LDAP search+bind mode Peter Eisentraut 09:53
Re: Performance degradation on concurrent COPY into a single relation in PG16. Jakub Wartak 09:53
Re: sslinfo extension - add notbefore and notafter timestamps Daniel Gustafsson 09:56
Re: Optionally using a better backtrace library? Alvaro Herrera 09:58
why doesn't call XLogCheckInvalidPages during primary crash recovery? ηŽ‹δΌŸ (学弈) 10:11
Re: Todo: Teach planner to evaluate multiple windows in the optimal order πŸ“Ž David Rowley 10:14
Re: Consider \v to the list of whitespace characters in the parser Peter Eisentraut 10:17
Re: Optionally using a better backtrace library? David Steele 10:24
Re: Commitfest manager for July Daniel Gustafsson 10:26
logicalrep_message_type throws an error Ashutosh Bapat 10:30
Re: XLog size reductions: Reduced XLog record header size for PG17 πŸ“Ž Matthias van de Meent 11:08
Re: pg_decode_message vs skip_empty_xacts and xact_wrote_changes vignesh C 11:19
Re: Avoid unncessary always true test (src/backend/storage/buffer/bufmgr.c) πŸ“Ž Ranier Vilela 11:26
Re: Refactor ssl tests to avoid using internal PostgreSQL::Test::Cluster methods Heikki Linnakangas 11:37
Re: [PATCH] Reuse Workers and Replication Slots during Logical Replication vignesh C 11:49
Re: Cleaning up array_in() πŸ“Ž jian he 11:52
Re: pgbnech: allow to cancel queries during benchmark Fabien COELHO 12:11
Re: [PGdocs] fix description for handling pf non-ASCII characters jian he 12:22
Allow specifying a dbname in pg_basebackup connection string πŸ“Ž Jelte Fennema 12:22
Re: Deleting prepared statements from libpq. Jelte Fennema 12:33
Re: cataloguing NOT NULL constraints Alvaro Herrera 12:58
Re: Creation of an empty table is not fsync'd at checkpoint πŸ“Ž Daniel Gustafsson 12:59
Re: logicalrep_message_type throws an error πŸ“Ž Euler Taveira 13:01
Re: Flush SLRU counters in checkpointer process Daniel Gustafsson 13:18
Re: Make uselocale protection more consistent Tristan Partin 13:21
Re: logicalrep_message_type throws an error Ashutosh Bapat 13:22
Re: generic plans and "initial" pruning Daniel Gustafsson 13:27
Re: Track Oldest Initialized WAL Buffer Page Heikki Linnakangas 13:27
Re: Add support for AT LOCAL πŸ“Ž Daniel Gustafsson 13:42
Is a pg_stat_force_next_flush() call sufficient for regression tests? Tomas Vondra 13:45
Re: logicalrep_message_type throws an error πŸ“Ž Ashutosh Bapat 13:57
Re: Introduce "log_connection_stages" setting. Daniel Gustafsson 13:57
Re: cataloguing NOT NULL constraints πŸ“Ž Peter Eisentraut 14:02
Re: Mark a transaction uncommittable Daniel Gustafsson 14:07
Re: pg_basebackup check vs Windows file path limits Andrew Dunstan 14:12
Re: Make uselocale protection more consistent Peter Eisentraut 14:15
Re: logicalrep_message_type throws an error Euler Taveira 14:16
Re: pg_basebackup check vs Windows file path limits Daniel Gustafsson 14:16
Re: Make uselocale protection more consistent Peter Eisentraut 14:21
Re: Add support for AT LOCAL Vik Fearing 14:23
Re: Optionally using a better backtrace library? Peter Eisentraut 14:26
Re: BUG #17946: LC_MONETARY & DO LANGUAGE plperl - BUG πŸ“Ž Tristan Partin 14:42
Re: Make uselocale protection more consistent Tristan Partin 14:49
Re: check_strxfrm_bug() Tristan Partin 14:52
Re: pg_basebackup check vs Windows file path limits Andrew Dunstan 15:18
Re: pg_basebackup check vs Windows file path limits Daniel Gustafsson 15:19
Re: Inconsistent results with libc sorting on Windows Alvaro Herrera 15:42
Re: Extension Enhancement: Buffer Invalidation in pg_buffercache jian he 15:46
Re: Sampling-based timing for EXPLAIN ANALYZE Daniel Gustafsson 16:01
Re: BUG #17946: LC_MONETARY & DO LANGUAGE plperl - BUG Tristan Partin 16:17
Re: Proposal: %T Prompt parameter for psql for current time (like Oracle has) Daniel Gustafsson 16:18
Re: BUG #17946: LC_MONETARY & DO LANGUAGE plperl - BUG Tristan Partin 16:25
Re: BUG #17946: LC_MONETARY & DO LANGUAGE plperl - BUG Joe Conway 16:28
Re: BUG #17946: LC_MONETARY & DO LANGUAGE plperl - BUG Joe Conway 16:31
Re: explain analyze rows=%.0f Daniel Gustafsson 16:34
Re: Inconsistent results with libc sorting on Windows Juan JosΓ© SantamarΓ­a Flecha 16:37
Re: [PATCH] Add <<none>> support to sepgsql_restorecon Daniel Gustafsson 16:42
Re: Fdw batch insert error out when set batch_size > 65535 Tomas Vondra 16:48
Re: Optionally using a better backtrace library? Andres Freund 17:43
Re: Does a cancelled REINDEX CONCURRENTLY need to be messy? Álvaro Herrera 17:46
Re: Should heapam_estimate_rel_size consider fillfactor? Tomas Vondra 17:54
Re: Optionally using a better backtrace library? Tristan Partin 17:54
Why is DATESTYLE, ordering ignored for output but used for input ? Dave Cramer 18:06
Re: pgsql: Fix search_path to a safe value during maintenance operations. Nathan Bossart 18:19
Size vs size_t or, um, PgSize? Yurii Rashkovskii 18:32
Including a sample Table Access Method with core code Hannu Krosing 18:33
Re: pgbnech: allow to cancel queries during benchmark Fabien COELHO 18:39
Re: Cutting support for OpenSSL 1.0.1 and 1.0.2 in 17~? Thomas Munro 18:40
Re: Size vs size_t or, um, PgSize? Daniel Gustafsson 18:46
Re: Cutting support for OpenSSL 1.0.1 and 1.0.2 in 17~? Daniel Gustafsson 18:53
Re: Size vs size_t or, um, PgSize? Thomas Munro 19:02
Re: Size vs size_t or, um, PgSize? Yurii Rashkovskii 19:14
Re: Size vs size_t or, um, PgSize? Daniel Gustafsson 19:20
Re: Size vs size_t or, um, PgSize? Yurii Rashkovskii 19:37
Re: Cutting support for OpenSSL 1.0.1 and 1.0.2 in 17~? Mikael KjellstrΓΆm 20:23
Re: ProcessStartupPacket(): database_name and user_name truncation Nathan Bossart 20:34
Re: Why is DATESTYLE, ordering ignored for output but used for input ? Matthias van de Meent 21:13
Re: [PATCH] Extend the length of BackgroundWorker.bgw_library_name Nathan Bossart 22:08
Re: Cutting support for OpenSSL 1.0.1 and 1.0.2 in 17~? Michael Paquier 22:13
Re: Cutting support for OpenSSL 1.0.1 and 1.0.2 in 17~? Michael Paquier 22:16
Re: Size vs size_t or, um, PgSize? Tom Lane 22:20
brininsert optimization opportunity πŸ“Ž Soumyadeep Chakraborty 22:21
Re: Add information about command path and version of flex in meson output Michael Paquier 22:29
Re: ProcessStartupPacket(): database_name and user_name truncation Tom Lane 22:33
Re: Large files for relations Thomas Munro 22:41
Re: Does a cancelled REINDEX CONCURRENTLY need to be messy? Michael Paquier 22:48
Re: Deleting prepared statements from libpq. Michael Paquier 23:28

July 4, 2023

Thread Author Time
Re: Consider \v to the list of whitespace characters in the parser πŸ“Ž Michael Paquier 00:00
Re: Commitfest manager for July Michael Paquier 00:03
Re: Consider \v to the list of whitespace characters in the parser Tom Lane 00:15
Re: Consider \v to the list of whitespace characters in the parser Michael Paquier 00:28
Re: Making empty Bitmapsets always be NULL David Rowley 00:36
Re: Improve list manipulation in several places Richard Guo 00:48
Re: [PATCH] Extend the length of BackgroundWorker.bgw_library_name Yurii Rashkovskii 01:00
pgindent (probably my missing something obvious) James Coleman 01:12
Re: pgindent (probably my missing something obvious) Tom Lane 01:20
Re: Parallelize correlated subqueries that execute within each worker πŸ“Ž James Coleman 01:26
RE: [PGdocs] fix description for handling pf non-ASCII characters Hayato Kuroda (Fujitsu) 01:30
Re: pgindent (probably my missing something obvious) James Coleman 01:41
Re: pgindent (probably my missing something obvious) Tom Lane 02:04
Re: Commitfest manager for July Ibrar Ahmed 02:27
Re: Is a pg_stat_force_next_flush() call sufficient for regression tests? πŸ“Ž Kyotaro Horiguchi 02:29

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 31