pgsql-hackers since 2025-01-11 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 31

Jan. 11, 2025

Thread Author Time
Re: Restore support for USE_ASSERT_CHECKING in extensions only David Rowley 00:05
Re: Restore support for USE_ASSERT_CHECKING in extensions only Tom Lane 00:15
Re: Add CASEFOLD() function. 📎 Jeff Davis 00:27
Re: Unicode full case mapping: PG_UNICODE_FAST, and standard-compliant UCS_BASIC 📎 Jeff Davis 00:36
Re: Restore support for USE_ASSERT_CHECKING in extensions only David Rowley 00:46
Re: Restore support for USE_ASSERT_CHECKING in extensions only Andrew Kane 01:00
Re: Row pattern recognition 📎 Tatsuo Ishii 05:46
Re: Non-text mode for pg_dumpall 📎 jian he 05:48
Re: Non-text mode for pg_dumpall Mahendra Singh Thalor 07:45
Re: Non-text mode for pg_dumpall Alvaro Herrera 08:44
Re: Some ExecSeqScan optimizations Junwang Zhao 08:57
Re: Some ExecSeqScan optimizations Junwang Zhao 09:00
Re: pgsql: Consolidate docs for vacuum-related GUCs in new subsection Alvaro Herrera 09:02
Re: explain analyze rows=%.0f Guillaume Lelarge 09:15
Re:Re: Re:Re:Re: backup server core when redo btree_xlog_insert that type is XLOG_BTREE_INSERT_POST yuansong 09:40
Re: Include patch id in commitfest page Peter Eisentraut 09:40
Re: Change COPY ... ON_ERROR ignore to ON_ERROR ignore_row Kirill Reshke 09:53
Re: improve DEBUG1 logging of parallel workers for CREATE INDEX? Guillaume Lelarge 10:29
Re: Some ExecSeqScan optimizations Junwang Zhao 10:39
Re: explain analyze rows=%.0f 📎 Ilia Evdokimov 11:10
Missing quotes when deparsing XMLTABLE() and SQL/JSON query functions 📎 Dean Rasheed 12:30
Re: Include patch id in commitfest page Magnus Hagander 12:51
Re: Question about behavior of deletes with REPLICA IDENTITY NOTHING 📎 Robert Treat 13:58
Re: why there is not VACUUM FULL CONCURRENTLY? Andrew Dunstan 14:01
Re: explain analyze rows=%.0f Guillaume Lelarge 14:02
Re: Non-text mode for pg_dumpall Mahendra Singh Thalor 14:38
Re: why there is not VACUUM FULL CONCURRENTLY? Sami Imseih 15:01
Re: Missing quotes when deparsing XMLTABLE() and SQL/JSON query functions Tom Lane 15:42
Re: Non-text mode for pg_dumpall jian he 15:59
Re: Non-text mode for pg_dumpall Mahendra Singh Thalor 16:08
Re: ecpg command does not warn COPY ... FROM STDIN; 📎 Ryo Kanbayashi 17:04
Re: NOT ENFORCED constraint feature Peter Eisentraut 17:13
Re: NOT ENFORCED constraint feature Amul Sul 17:26
Re: explain analyze rows=%.0f Ilia Evdokimov 18:21
Re: pgbench error: (setshell) of script 0; execution of meta-command failed 📎 Tom Lane 19:04
llvm dependency and space concerns Jeremy Schneider 20:56
Re: llvm dependency and space concerns Jeremy Schneider 21:01
Re: Proposal to Enable/Disable Index using ALTER INDEX (with patch) 📎 Shayon Mukherjee 21:10
Re: llvm dependency and space concerns Tom Lane 21:14
Re: llvm dependency and space concerns Jeremy Schneider 21:22
Re: Non-text mode for pg_dumpall 📎 Mahendra Singh Thalor 21:30
Re: Proposal to Enable/Disable Index using ALTER INDEX (with patch) Sami Imseih 22:50
Re: SQL:2011 application time 📎 Paul Jungwirth 23:19
Re: llvm dependency and space concerns Christoph Moench-Tegeder 23:33
Re: Adjusting hash join memory limit to handle batch explosion Tomas Vondra 23:49

Jan. 12, 2025

Thread Author Time
Re: llvm dependency and space concerns Andres Freund 00:03
Re: Possible integer overflow in bringetbitmap() Michael Paquier 00:11
Re: Adjusting hash join memory limit to handle batch explosion 📎 Tomas Vondra 00:42
Re: Recovering from detoast-related catcache invalidations Noah Misch 01:26
Re: Reduce TupleHashEntryData struct size by half David Rowley 01:54
Re: llvm dependency and space concerns Jeremy Schneider 02:37
Re: ecpg command does not warn COPY ... FROM STDIN; Fujii Masao 03:56
Re: ecpg command does not warn COPY ... FROM STDIN; Ryo Kanbayashi 09:27
Re: Parallel heap vacuum 📎 Masahiko Sawada 09:34
Compression of bigger WAL records 📎 Andrey M. Borodin 12:43
Re: Missing quotes when deparsing XMLTABLE() and SQL/JSON query functions Dean Rasheed 14:10
benign bug in BufFileLoadBuffer / incorrect sizeof 📎 Tomas Vondra 16:10
Re: Strange assertion in procarray.c Michail Nikolaev 16:40
Re: Compression of bigger WAL records Kirill Reshke 18:36
Re: POC, WIP: OR-clause support for indexes 📎 Alexander Korotkov 18:39
Re: pgsql: Consolidate docs for vacuum-related GUCs in new subsection Daniel Gustafsson 19:07
Re: benign bug in BufFileLoadBuffer / incorrect sizeof Daniel Gustafsson 19:16
Re: pgsql: Consolidate docs for vacuum-related GUCs in new subsection Tom Lane 19:21
Re: Proposal to Enable/Disable Index using ALTER INDEX (with patch) 📎 Shayon Mukherjee 19:58
Re: POC, WIP: OR-clause support for indexes Alena Rybakina 20:38
Re: CREATE OR REPLACE MATERIALIZED VIEW 📎 Erik Wienhold 21:33
Re: Re: Re:Re:Re: backup server core when redo btree_xlog_insert that type is XLOG_BTREE_INSERT_POST Peter Geoghegan 22:43
Re: Include patch id in commitfest page Jelte Fennema-Nio 23:11
Re: Pgoutput not capturing the generated columns 📎 Peter Smith 23:55

Jan. 13, 2025

Thread Author Time
Re: Pgoutput not capturing the generated columns Peter Smith 00:15
Re: Adding a '--two-phase' option to 'pg_createsubscriber' utility. Ajin Cherian 00:16
Re: POC, WIP: OR-clause support for indexes 📎 Yura Sokolov 00:47
Issue with markers in isolation tester? Or not? 📎 Michail Nikolaev 01:02
Re: POC, WIP: OR-clause support for indexes Alexander Korotkov 01:06
Re: Question about behavior of deletes with REPLICA IDENTITY NOTHING Peter Smith 01:11
Re: pg_createsubscriber TAP test wrapping makes command options hard to read. Peter Smith 01:37
Re: Eager aggregation, take 3 📎 Richard Guo 02:04
Re: Enhancing Memory Context Statistics Reporting 📎 Rahila Syed 02:36
Re: Support for NO INHERIT to INHERIT state change with named NOT NULL constraints 📎 Suraj Kharage 02:56
Re: POC, WIP: OR-clause support for indexes 📎 Andrei Lepikhov 03:39
Re: Question about behavior of deletes with REPLICA IDENTITY NOTHING Amit Kapila 04:00
Re: Question about behavior of deletes with REPLICA IDENTITY NOTHING Robert Treat 04:51
Re: Compression of bigger WAL records Andrey Borodin 05:14
Re: Conflict detection for update_deleted in logical replication Amit Kapila 06:36
Re: Introduce XID age and inactive timeout based replication slot invalidation vignesh C 06:52
Re: POC: enable logical decoding when wal_level = 'replica' without a server restart 📎 Peter Smith 06:52
Re: Documentation update of wal_retrieve_retry_interval to mention table sync worker 📎 vignesh C 07:03
Re: Introduce XID age and inactive timeout based replication slot invalidation Peter Smith 07:18
Re: Documentation update of wal_retrieve_retry_interval to mention table sync worker Peter Smith 07:29
Re: Changing shared_buffers without restart 📎 Ashutosh Bapat 08:11
Re: Psql meta-command conninfo+ Alvaro Herrera 08:44
Re: Vacuum statistics Andrei Zubkov 08:54
Re: Question about behavior of deletes with REPLICA IDENTITY NOTHING Amit Kapila 08:55
Re: Documentation update of wal_retrieve_retry_interval to mention table sync worker Shlok Kyal 09:13
Re: POC: enable logical decoding when wal_level = 'replica' without a server restart vignesh C 09:22
Re: Pgoutput not capturing the generated columns Amit Kapila 09:26
Re: POC: enable logical decoding when wal_level = 'replica' without a server restart Ashutosh Bapat 09:31
Re: proposal: plpgsql, new check for extra_errors - strict_expr_check 📎 Pavel Stehule 09:32
Accept recovery conflict interrupt on blocked writing 📎 Anthonin Bonnefoy 10:30
Re: Skip collecting decoded changes of already-aborted transactions Amit Kapila 11:06
Re: Psql meta-command conninfo+ Dean Rasheed 11:12
Re: Vacuum statistics 📎 Alena Rybakina 11:19
Re: Vacuum statistics Alena Rybakina 11:29
Re: Reorder shutdown sequence, to flush pgstats later Bertrand Drouvot 12:20
Re: Conflict detection for update_deleted in logical replication 📎 Nisha Moond 12:21
Re: Vacuum statistics 📎 Alena Rybakina 13:26
Re: why there is not VACUUM FULL CONCURRENTLY? 📎 Antonin Houska 13:48
Re: why there is not VACUUM FULL CONCURRENTLY? Michael Banck 13:55
Re: Replace current implementations in crypt() and gen_salt() to OpenSSL 📎 Daniel Gustafsson 14:18
Re: pgsql: Consolidate docs for vacuum-related GUCs in new subsection Melanie Plageman 15:22
Re: [PATCH] SVE popcount support Malladi, Rama 15:28
Re: [PATCH] Hex-coding optimizations using SVE on ARM. Chiranmoy.Bhattacharya@fujitsu.com 15:48
Re: POC: track vacuum/analyze cumulative time per relation Bertrand Drouvot 15:55
Re: pgbench error: (setshell) of script 0; execution of meta-command failed 📎 Nathan Bossart 16:04
Re: Modern SHA2- based password hashes for pgcrypto Alvaro Herrera 16:06
Re: [PATCH] Hex-coding optimizations using SVE on ARM. Nathan Bossart 16:18
Re: Adjusting hash join memory limit to handle batch explosion Melanie Plageman 16:32
Re: Exists pull-up application with JoinExpr 📎 Alena Rybakina 17:19
Re: Adjusting hash join memory limit to handle batch explosion Tomas Vondra 17:29
Re: Conflict Detection and Resolution Michail Nikolaev 17:31
Re: [PATCH] Add get_bytes() and set_bytes() functions 📎 Aleksander Alekseev 17:35
Re: Virtual generated columns Dean Rasheed 18:15
SQLJSON: errmsg(" .. should ...") -> must 📎 Alvaro Herrera 18:19
Re: Pgoutput not capturing the generated columns 📎 vignesh C 18:21
Re: [PATCH] Add get_bytes() and set_bytes() functions Dean Rasheed 18:24
Re: Skip collecting decoded changes of already-aborted transactions Masahiko Sawada 18:54
Re: Skip collecting decoded changes of already-aborted transactions 📎 Masahiko Sawada 18:56
InitControlFile misbehaving on graviton Christoph Berg 19:04
Re: [PATCH] Add get_bytes() and set_bytes() functions Alvaro Herrera 19:23
Re: connection establishment versus parallel workers Nathan Bossart 19:50
Re: pgsql: Consolidate docs for vacuum-related GUCs in new subsection 📎 Melanie Plageman 19:57
Re: InitControlFile misbehaving on graviton Alexander Lakhin 20:00
Re: Incorrect CHUNKHDRSZ in nodeAgg.c 📎 Jeff Davis 20:09
Re: explain analyze rows=%.0f 📎 Ilia Evdokimov 20:18
Re: New GUC autovacuum_max_threshold ? 📎 Nathan Bossart 20:21
Re: Adding skip scan (including MDAM style range skip scan) to nbtree 📎 Peter Geoghegan 20:22
Re: InitControlFile misbehaving on graviton Matthias van de Meent 20:39
Re: connection establishment versus parallel workers Thomas Munro 20:42
Re: AIO v2.2 Robert Haas 20:43
Re: pgsql: Consolidate docs for vacuum-related GUCs in new subsection Alvaro Herrera 20:46
Re: Question about behavior of deletes with REPLICA IDENTITY NOTHING Robert Treat 21:22
Re: POC: enable logical decoding when wal_level = 'replica' without a server restart Masahiko Sawada 21:32
Re: POC: enable logical decoding when wal_level = 'replica' without a server restart Masahiko Sawada 21:45
Re: AIO v2.2 Andres Freund 21:46
Re: Eagerly scan all-visible pages to amortize aggressive vacuum 📎 Melanie Plageman 21:46
question about relation_open Giampaolo Capelli 21:47
Re: [PATCH] Add get_bytes() and set_bytes() functions Dean Rasheed 21:53
Re: Issues with ON CONFLICT UPDATE and REINDEX CONCURRENTLY 📎 Michail Nikolaev 21:58
Re: Reduce TupleHashEntryData struct size by half Jeff Davis 22:11
Re: Reorder shutdown sequence, to flush pgstats later Andres Freund 22:33
Re: pgsql: Consolidate docs for vacuum-related GUCs in new subsection 📎 Melanie Plageman 22:35
Re: Eagerly scan all-visible pages to amortize aggressive vacuum Alena Rybakina 22:37
Re: pgbench error: (setshell) of script 0; execution of meta-command failed Tom Lane 22:51
Re: New GUC autovacuum_max_threshold ? Sami Imseih 23:17
Re: [PoC] Federated Authn/z with OAUTHBEARER 📎 Jacob Champion 23:21
Re: Issue with markers in isolation tester? Or not? Michail Nikolaev 23:33
Re: pgsql: Consolidate docs for vacuum-related GUCs in new subsection Alena Rybakina 23:51

Jan. 14, 2025

Thread Author Time
Re: [PoC] Federated Authn/z with OAUTHBEARER Jacob Champion 01:00
Re: Question about behavior of deletes with REPLICA IDENTITY NOTHING Peter Smith 01:07
Re: Skip collecting decoded changes of already-aborted transactions Peter Smith 01:35
Re: Conflict detection for update_deleted in logical replication Masahiko Sawada 01:43
Re: Skip collecting decoded changes of already-aborted transactions Peter Smith 02:01
Re: Several buildfarm animals fail tests because of shared memory error Tom Lane 02:02
Re: New GUC autovacuum_max_threshold ? 📎 Nathan Bossart 02:09
Re: Some ExecSeqScan optimizations Amit Langote 02:13
Re: Some ExecSeqScan optimizations Amit Langote 02:17
Docs for pg_basebackup needs v17 note for incremental backup David G. Johnston 03:13
Re: Make pg_stat_io view count IOs as bytes instead of blocks Michael Paquier 03:18
Re: WAL-logging facility for pgstats kinds 📎 Michael Paquier 03:54
Re: Issue with markers in isolation tester? Or not? Noah Misch 04:03
Re: Conflict detection for update_deleted in logical replication Amit Kapila 04:39
Re: Log a warning in pg_createsubscriber for max_slot_wal_keep_size 📎 Peter Smith 04:40
Re: Skip collecting decoded changes of already-aborted transactions Amit Kapila 04:47
Re: per backend I/O statistics Michael Paquier 04:56
Re: Conflict Detection and Resolution Amit Kapila 04:57
Re: [PATCH] Hex-coding optimizations using SVE on ARM. 📎 John Naylor 05:27
Re: [PATCH] Hex-coding optimizations using SVE on ARM. Michael Paquier 05:40
Re: Change COPY ... ON_ERROR ignore to ON_ERROR ignore_row 📎 jian he 05:51
Re: Reorder shutdown sequence, to flush pgstats later 📎 Andres Freund 05:58
Re: [PATCH] Hex-coding optimizations using SVE on ARM. Tom Lane 05:59
Re: Possible integer overflow in bringetbitmap() Michael Paquier 06:28
RE: COPY performance on Windows Ryohei Takahashi (Fujitsu) 06:50
Re: Log a warning in pg_createsubscriber for max_slot_wal_keep_size 📎 Shubham Khanna 06:54
RE: COPY performance on Windows Ryohei Takahashi (Fujitsu) 06:55
Re: Log a warning in pg_createsubscriber for max_slot_wal_keep_size Shubham Khanna 07:02
Re: pg_createsubscriber TAP test wrapping makes command options hard to read. Peter Smith 07:03
Re: Log a warning in pg_createsubscriber for max_slot_wal_keep_size Shubham Khanna 07:05
Prevent an error on attaching/creating a DSM/DSA from an interrupt handler. 📎 Rahila Syed 07:45
Re: Psql meta-command conninfo+ Hunaid Sohail 07:57
Re: XMLDocument (SQL/XML X030) Pavel Stehule 08:14
Re: psql: Add leakproof field to \dAo+ meta-command results 📎 Yugo NAGATA 08:44
Re: Add Pipelining support in psql 📎 Anthonin Bonnefoy 08:49
Re: Psql meta-command conninfo+ Alvaro Herrera 08:51
Re: Sort functions with specialized comparators 📎 John Naylor 08:58
Re: Reduce TupleHashEntryData struct size by half David Rowley 09:01
question about executor hooks Luca Ferrari 09:08
Re: downgrade some aclchk.c errors to internal Alvaro Herrera 09:10
Re: SCRAM pass-through authentication for postgres_fdw 📎 Peter Eisentraut 09:21
Re: Sort functions with specialized comparators Andrey Borodin 09:22
Re: Modern SHA2- based password hashes for pgcrypto Bernd Helmle 09:34

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