pgsql-hackers since 2024-12-20 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

Dec. 20, 2024

Thread Author Time
Re: in BeginCopyTo make materialized view using COPY TO instead of COPY (query). Michael Paquier 00:01
Re: Back-patch of: avoid multiple hard links to same WAL file after a crash Michael Paquier 00:13
Re: AIO v2.0 Andres Freund 00:54
Re: Logical Replication of sequences Peter Smith 00:56
Re: [PoC] Federated Authn/z with OAUTHBEARER 📎 Jacob Champion 01:00
Re: [PoC] Let libpq reject unexpected authentication requests Jacob Champion 01:02
Re: pure parsers and reentrant scanners Tom Lane 01:07
Re: [PoC] Let libpq reject unexpected authentication requests Michael Paquier 01:28
Re: Back-patch of: avoid multiple hard links to same WAL file after a crash Robert Pang 01:45
Re: [PATCH] Fixed creation of empty .log files during log rotation Michael Paquier 02:19
Re: Memory leak in WAL sender with pgoutput (v10~) Michael Paquier 02:30
Re: Logical Replication of sequences Peter Smith 02:34
Re: Can rs_cindex be < 0 for bitmap heap scans? Richard Guo 02:35
Re: in BeginCopyTo make materialized view using COPY TO instead of COPY (query). jian he 02:53
Eliminating SPI / SQL from some RI triggers - take 3 📎 Amit Langote 04:23
Speed up ICU case conversion by using ucasemap_utf8To*() 📎 Andreas Karlsson 05:20
Re: Statistics Import and Export 📎 Jeff Davis 05:23
Re: [PoC] Reducing planning time when tables have many partitions 📎 Yuya Watari 05:26
Re: Skip collecting decoded changes of already-aborted transactions Amit Kapila 05:36
Re: Collation & ctype method table, and extension hooks 📎 Andreas Karlsson 05:48
Re: per backend I/O statistics Alexander Lakhin 06:00
Re: Statistics Import and Export Corey Huinker 06:00
Re: Added schema level support for publication. Amit Kapila 06:04
Re: Conflict detection for update_deleted in logical replication 📎 Nisha Moond 07:11
Re: Skip collecting decoded changes of already-aborted transactions 📎 Masahiko Sawada 07:25
Re: Re: proposal: schema variables jian he 07:57
Re: per backend I/O statistics 📎 Bertrand Drouvot 09:09
Re: Parametrization minimum password lenght Bertrand Drouvot 09:15
Re: per backend I/O statistics Michael Paquier 09:24
Re: Introduce XID age and inactive timeout based replication slot invalidation Amit Kapila 09:42
Re: per backend I/O statistics Bertrand Drouvot 09:57
Re: Test to dump and restore objects left behind by regression 📎 Ashutosh Bapat 10:01
Re: Make tuple deformation faster David Rowley 10:04
Additional comments around need_escapes in pg_parse_json() 📎 Corey Huinker 10:21
Re: Fix crash when non-creator being an iteration on shared radix tree 📎 John Naylor 10:27
Re: Make tuple deformation faster 📎 David Rowley 10:31
Re: Can rs_cindex be < 0 for bitmap heap scans? Ranier Vilela 11:31
Some ExecSeqScan optimizations 📎 Amit Langote 11:41
downgrade some aclchk.c errors to internal 📎 Peter Eisentraut 11:47
Re: FileFallocate misbehaving on XFS Jakub Wartak 12:25
Re: proposal: schema variables 📎 Pavel Stehule 12:53
Re: downgrade some aclchk.c errors to internal 📎 Peter Eisentraut 14:03
Re: pure parsers and reentrant scanners Peter Eisentraut 14:29
Re: Can rs_cindex be < 0 for bitmap heap scans? Melanie Plageman 14:45
Re: pure parsers and reentrant scanners Tom Lane 15:23
Re: pure parsers and reentrant scanners Julien Rouhaud 15:30
Re: pure parsers and reentrant scanners Tom Lane 15:35
Fix logging for invalid recovery timeline 📎 David Steele 15:37
Document How Commit Handles Aborted Transactions 📎 David G. Johnston 16:02
Re: FileFallocate misbehaving on XFS Andres Freund 16:39
Re: Sort functions with specialized comparators 📎 Andrey M. Borodin 17:16
Re: AIO v2.0 Jelte Fennema-Nio 17:27
Re: A few patches to clarify snapshot management 📎 Heikki Linnakangas 17:31
Re: AIO v2.0 Andres Freund 17:39
Discussion on a LISTEN-ALL syntax Trey Boudreau 18:56
Re: Fix crash when non-creator being an iteration on shared radix tree Masahiko Sawada 19:16
Re: Memory leak in WAL sender with pgoutput (v10~) Masahiko Sawada 19:23
Re: Speed up ICU case conversion by using ucasemap_utf8To*() Jeff Davis 19:24
Re: allow changing autovacuum_max_workers without restarting 📎 Nathan Bossart 19:46
Re: Discussion on a LISTEN-ALL syntax Tom Lane 20:58
Re: Discussion on a LISTEN-ALL syntax Trey Boudreau 21:41
Re: Discussion on a LISTEN-ALL syntax David G. Johnston 21:42
Re: Discussion on a LISTEN-ALL syntax David G. Johnston 21:49
Re: Discussion on a LISTEN-ALL syntax David G. Johnston 21:57
Re: Re: proposal: schema variables 📎 Pavel Stehule 22:00
Re: Discussion on a LISTEN-ALL syntax Tom Lane 22:07
Re: [PoC] Federated Authn/z with OAUTHBEARER 📎 Daniel Gustafsson 22:20
Re: Discussion on a LISTEN-ALL syntax David G. Johnston 22:23
Bug: mdunlinkfiletag unlinks mainfork seg.0 instead of indicated fork+segment 📎 Matthias van de Meent 22:41
Re: Discussion on a LISTEN-ALL syntax Tom Lane 22:45
Re: Discussion on a LISTEN-ALL syntax Daniel Gustafsson 22:47
Re: Possible integer overflow in bringetbitmap() Michael Paquier 23:22
Re: Parallel heap vacuum 📎 Masahiko Sawada 23:25
Add XMLNamespaces to XMLElement 📎 Jim Jones 23:51

Dec. 21, 2024

Thread Author Time
Re: Bug: mdunlinkfiletag unlinks mainfork seg.0 instead of indicated fork+segment Thomas Munro 00:05
Re: Statistics Import and Export Jeff Davis 00:16
Re: Eager aggregation, take 3 📎 Richard Guo 01:05
Re: Bug: mdunlinkfiletag unlinks mainfork seg.0 instead of indicated fork+segment 📎 Matthias van de Meent 01:21
Re: a litter question about mdunlinkfiletag function Matthias van de Meent 01:29
wrong comments in ClassifyUtilityCommandAsReadOnly jian he 04:05
Re: Discussion on a LISTEN-ALL syntax Vik Fearing 04:12
Re: Discussion on a LISTEN-ALL syntax Tom Lane 04:23
Re: Fix logging for invalid recovery timeline Andrey M. Borodin 04:28
Re: Discussion on a LISTEN-ALL syntax Vik Fearing 05:22
Re: Fix crash when non-creator being an iteration on shared radix tree 📎 John Naylor 05:55
Re: Add XMLNamespaces to XMLElement Pavel Stehule 05:57
Re: New "single" COPY format Joel Jacobson 08:56
Re: Row pattern recognition 📎 Tatsuo Ishii 09:20
Re: Statistics Import and Export Corey Huinker 10:11
Re: pure parsers and reentrant scanners Peter Eisentraut 10:47
Re: SQL Property Graph Queries (SQL/PGQ) 📎 Junwang Zhao 12:51
Re: Additional comments around need_escapes in pg_parse_json() Andrew Dunstan 14:56
Re: Eagerly scan all-visible pages to amortize aggressive vacuum Robert Treat 15:28
Re: Discussion on a LISTEN-ALL syntax Trey Boudreau 17:42
Re: Revisiting {CREATE INDEX, REINDEX} CONCURRENTLY improvements 📎 Michail Nikolaev 18:00
PoC: history of recent vacuum/checkpoint runs (using new hooks) 📎 Tomas Vondra 20:27
Re: SQL Property Graph Queries (SQL/PGQ) 📎 Andreas Karlsson 21:45
Re: TransactionXmin != MyProc->xmin Heikki Linnakangas 22:12

Dec. 22, 2024

Thread Author Time
Re: general purpose array_sort 📎 jian he 04:28
Several buildfarm animals fail tests because of shared memory error Alexander Lakhin 06:00
Re: Several buildfarm animals fail tests because of shared memory error Robins Tharakan 07:27
Re: Document NULL 📎 jian he 14:26
Re: Document NULL David G. Johnston 15:01
Re: Document NULL Marcos Pegoraro 16:44
Re: magical eref alias names Tom Lane 17:45
Re: Document NULL David G. Johnston 18:07
Re: Discussion on a LISTEN-ALL syntax Trey Boudreau 18:53
Re: pure parsers and reentrant scanners Andreas Karlsson 21:43

Dec. 23, 2024

Thread Author Time
Re: Several buildfarm animals fail tests because of shared memory error Michael Paquier 00:36
Re: wrong comments in ClassifyUtilityCommandAsReadOnly 📎 David Rowley 02:43
Fix a wrong comment in load_file() 📎 cca5507 02:58
Re: wrong comments in ClassifyUtilityCommandAsReadOnly Tom Lane 03:37
Re: Fix a wrong comment in load_file() Michael Paquier 03:42
Re: Fix a wrong comment in load_file() Tom Lane 03:50
Last removed wal segment file mahendrakar s 03:52
Re: Using Expanded Objects other than Arrays from plpgsql Michel Pelletier 03:52
Re: Memory leak in WAL sender with pgoutput (v10~) Michael Paquier 03:53
Re: Fix a wrong comment in load_file() Michael Paquier 04:10
Re: Fix a wrong comment in load_file() Tom Lane 04:15
transaction lost when delete clog file after normal shutdown 04:16
Re: attndims, typndims still not enforced, but make the value within a sane threshold Michael Paquier 04:56
Re: Last removed wal segment file Michael Paquier 05:16
Re: Fix a wrong comment in load_file() cca5507 05:20
Re: wrong comments in ClassifyUtilityCommandAsReadOnly 📎 David Rowley 05:27
Re: Re: transaction lost when delete clog file after normal shutdown 05:43
Re: wrong comments in ClassifyUtilityCommandAsReadOnly Tom Lane 05:53
RE: Conflict detection for update_deleted in logical replication Hayato Kuroda (Fujitsu) 06:14
Re: Re: Re: transaction lost when delete clog file after normal shutdown 06:26
Re: PoC: history of recent vacuum/checkpoint runs (using new hooks) wenhui qiu 06:35
Re: transaction lost when delete clog file after normal shutdown Tom Lane 06:50
Re: Fix a wrong comment in load_file() Michael Paquier 06:51
Re: wrong comments in ClassifyUtilityCommandAsReadOnly David Rowley 06:56
Re: Additional comments around need_escapes in pg_parse_json() Corey Huinker 07:15
Re: Logical Replication of sequences 📎 vignesh C 07:20
Re: Logical Replication of sequences vignesh C 07:22
Repeatable read transaction doesn't see dropped table Daniil Davydov 07:44
Re: Repeatable read transaction doesn't see dropped table David G. Johnston 08:17
Re: Removing unneeded self joins 📎 Andrei Lepikhov 08:25
Re: Re: transaction lost when delete clog file after normal shutdown 09:12
RE: Logical replication timeout Hayato Kuroda (Fujitsu) 09:12
Re: Logical replication timeout RECHTÉ Marc 09:31
Re: transaction lost when delete clog file after normal shutdown Andrey Borodin 09:51
Re: Repeatable read transaction doesn't see dropped table Heikki Linnakangas 10:01
Re: Re: transaction lost when delete clog file after normal shutdown 10:03
Re: Repeatable read transaction doesn't see dropped table Daniil Davydov 10:11
Re: transaction lost when delete clog file after normal shutdown Andrey Borodin 10:15
Re: Exporting float_to_shortest_decimal_buf(n) with Postgres 17 on Windows 📎 Vladlen Popolitov 10:32
Re: Re: transaction lost when delete clog file after normal shutdown 10:36
Re: transaction lost when delete clog file after normal shutdown Daniel Gustafsson 10:43
Re: transaction lost when delete clog file after normal shutdown Andrey Borodin 10:52
Re: Re: transaction lost when delete clog file after normal shutdown 11:01
Re: Exporting float_to_shortest_decimal_buf(n) with Postgres 17 on Windows Heikki Linnakangas 11:05
RE: Logical replication timeout Hayato Kuroda (Fujitsu) 11:17
Re: transaction lost when delete clog file after normal shutdown Andrey Borodin 11:30
Re: Exporting float_to_shortest_decimal_buf(n) with Postgres 17 on Windows 📎 Vladlen Popolitov 12:14
Re: Exporting float_to_shortest_decimal_buf(n) with Postgres 17 on Windows Vladlen Popolitov 12:16
RE: Logical replication timeout Hayato Kuroda (Fujitsu) 12:29
Re: Make tuple deformation faster Alexander Lakhin 13:00
Re: Logical replication timeout RECHTÉ Marc 13:56
Re: Use "protocol options" name instead of "protocol extensions" everywhere Jelte Fennema-Nio 15:39
RE: AIX support 📎 Srirama Kucherlapati 15:55
Re: Use "protocol options" name instead of "protocol extensions" everywhere David G. Johnston 16:15
Re: Using Expanded Objects other than Arrays from plpgsql Tom Lane 16:26
help in allocating shared module within a module Luca Ferrari 17:31
Re: Add new protocol message to change GUCs for usage with future protocol-only GUCs 📎 Jelte Fennema-Nio 17:46
Re: Eagerly scan all-visible pages to amortize aggressive vacuum 📎 Melanie Plageman 17:50
Re: Eagerly scan all-visible pages to amortize aggressive vacuum Melanie Plageman 17:58
More reliable nbtree detection of unsatisfiable RowCompare quals involving a leading NULL key/element 📎 Peter Geoghegan 18:02
Re: transaction lost when delete clog file after normal shutdown Jan Wieck 18:06
Re: help in allocating shared module within a module Matthias van de Meent 18:08
Re: Document NULL Marcos Pegoraro 18:38
Re: Add Postgres module info David E. Wheeler 19:23
Re: [EXTERNAL] Re: Add non-blocking version of PQcancel Tom Lane 20:15
Re: Add Postgres module info Tom Lane 20:17
Re: Make tuple deformation faster David Rowley 20:34
Re: nbtree VACUUM's REDO routine doesn't clear page's VACUUM cycle ID Peter Geoghegan 20:46
Re: nbtree VACUUM's REDO routine doesn't clear page's VACUUM cycle ID Peter Geoghegan 20:47
Re: Document NULL David G. Johnston 21:17
stored procedures vs pg_stat_statements Merlin Moncure 21:31
Re: stored procedures vs pg_stat_statements Tom Lane 21:58
Re: Recovering from detoast-related catcache invalidations 📎 Heikki Linnakangas 22:18
Re: Make tuple deformation faster 📎 David Rowley 22:19
Re: Add Postgres module info David E. Wheeler 22:26

Dec. 24, 2024

Thread Author Time
Re: transaction lost when delete clog file after normal shutdown wenhui qiu 01:45
Re: Add Postgres module info Andrei Lepikhov 01:49
Re: transaction lost when delete clog file after normal shutdown wenhui qiu 01:55
Re: Make tuple deformation faster David Rowley 01:57
Re: Add Postgres module info Yurii Rashkovskii 03:42
Re: Add Postgres module info Chapman Flack 03:48
Re: stored procedures vs pg_stat_statements Merlin Moncure 04:06
Exists pull-up application with JoinExpr 📎 Alena Rybakina 04:44
Re: stored procedures vs pg_stat_statements Michael Paquier 05:01
Re: transaction lost when delete clog file after normal shutdown Michael Paquier 05:13
Re: per backend I/O statistics Michael Paquier 05:35
Re: Make pg_stat_io view count IOs as bytes instead of blocks Michael Paquier 06:12
adjust_limit_rows_costs algorithm wenhui qiu 06:20
RE: Parallel heap vacuum 📎 Hayato Kuroda (Fujitsu) 06:26
Re: Allow ILIKE forward matching to use btree index Yugo Nagata 07:04
Re: date_trunc invalid units with infinite value Michael Paquier 07:33
Re: Recovering from detoast-related catcache invalidations Michael Paquier 07:38

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