pgsql-hackers - November 2024

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

Nov. 1, 2024

Thread Author Time
Re: vacuumdb --analyze-only (e.g., after a major upgrade) vs. partitioned tables: pg_statistic missing stats for the partitioned table itself Bruce Momjian 00:27
Re: Time to add a Git .mailmap? Michael Paquier 00:29
Re: pg_upgrade check for invalid databases Bruce Momjian 00:36
Re: Making error message more user-friendly with spaces in a URI Michael Paquier 00:50
Re: libedit history seems to be misbehaving / broken Bruce Momjian 00:50
Re: Remove useless casts to (void *) Bruce Momjian 01:10
Re: [PATCH] Add array_reverse() function Michael Paquier 01:34
Re: Pgoutput not capturing the generated columns 📎 Peter Smith 01:40
Re: Consider the number of columns in the sort cost model Andrei Lepikhov 01:49
Re: Eager aggregation, take 3 Richard Guo 01:50
Re: Wrong result when enable_partitionwise_join is on if collation of PartitionKey and Column is different. Tender Wang 02:39
Re: Wrong result when enable_partitionwise_join is on if collation of PartitionKey and Column is different. Tender Wang 02:59
PG does not support one function of its extension pg_hint_plan 李奇隆 03:13
Re: Pgoutput not capturing the generated columns Peter Smith 03:52
Re: Relcache refactoring Tom Lane 04:19
Re: Inval reliability, especially for inplace updates Noah Misch 04:20
Re: define pg_structiszero(addr, s, r) David Rowley 04:45
Re: UUID v7 Andrey M. Borodin 04:53
Re: Showing applied extended statistics in explain Part 2 📎 Tatsuro Yamada 05:22
Re: Wrong result when enable_partitionwise_join is on if collation of PartitionKey and Column is different. jian he 05:39
Re: Eager aggregation, take 3 Richard Guo 05:54
Re: Eager aggregation, take 3 Richard Guo 06:21
Re: define pg_structiszero(addr, s, r) 📎 Michael Paquier 06:27
Re: Eager aggregation, take 3 Richard Guo 06:30
Re: UUID v7 Masahiko Sawada 06:33
Re: define pg_structiszero(addr, s, r) Bertrand Drouvot 06:33
Re: Wrong result when enable_partitionwise_join is on if collation of PartitionKey and Column is different. Amit Langote 06:55
Re: define pg_structiszero(addr, s, r) Michael Paquier 07:14
Re: define pg_structiszero(addr, s, r) 📎 David Rowley 07:19
Improve the efficiency of _bt_killitems. feichanghong 07:19
Re: define pg_structiszero(addr, s, r) David Rowley 07:21
Re: Wrong result when enable_partitionwise_join is on if collation of PartitionKey and Column is different. 📎 Amit Langote 07:25
Re: Wrong result when enable_partitionwise_join is on if collation of PartitionKey and Column is different. Amit Langote 07:26
Re: define pg_structiszero(addr, s, r) David Rowley 07:27
Re: define pg_structiszero(addr, s, r) 📎 Michael Paquier 07:36
Re: Wrong result when enable_partitionwise_join is on if collation of PartitionKey and Column is different. Tender Wang 07:39
Re: define pg_structiszero(addr, s, r) Bertrand Drouvot 07:44
Re: define pg_structiszero(addr, s, r) Michael Paquier 07:49
RE: Pgoutput not capturing the generated columns Hayato Kuroda (Fujitsu) 07:57
Re: small pg_combinebackup improvements Bertrand Drouvot 08:01
Re: Wrong result when enable_partitionwise_join is on if collation of PartitionKey and Column is different. jian he 08:07
Re: Improve the efficiency of _bt_killitems. Heikki Linnakangas 08:24
Re: Improve the efficiency of _bt_killitems. feichanghong 08:41
Re: define pg_structiszero(addr, s, r) 📎 David Rowley 08:47
Re: Using read stream in autoprewarm Nazir Bilal Yavuz 08:51
Re: Using read stream in autoprewarm Nazir Bilal Yavuz 08:51
Adding NetBSD and OpenBSD to Postgres CI 📎 Nazir Bilal Yavuz 09:17
Proposal to remove message length constant from F/B protocol document Tatsuo Ishii 09:27
Re: New function normal_rand_array function to contrib/tablefunc. 📎 Dean Rasheed 09:33
Re: Improving tracking/processing of buildfarm test failures Alexander Lakhin 10:00
Re: Wrong result when enable_partitionwise_join is on if collation of PartitionKey and Column is different. 📎 Amit Langote 10:08
Add missing tab completion for ALTER TABLE ADD COLUMN IF NOT EXISTS 📎 Kirill Reshke 10:43
Re: Improve the efficiency of _bt_killitems. Heikki Linnakangas 10:50
Re: Adding NetBSD and OpenBSD to Postgres CI Peter Eisentraut 11:16
Re: Time to add a Git .mailmap? Alvaro Herrera 11:53
Re: Count and log pages set all-frozen by vacuum Alastair Turner 12:12
Re: Eager aggregation, take 3 Robert Haas 12:41
Re: Allowing pg_recvlogical to create temporary replication slots Torsten Förtsch 12:42
Re: define pg_structiszero(addr, s, r) Bertrand Drouvot 12:50
Re: Time to add a Git .mailmap? Peter Eisentraut 12:53
Inquiry on Future Plans for Enhancements to PostgreSQL MVCC Model and Vacuum Process 송영욱 12:56
Re: Collation & ctype method table, and extension hooks Andreas Karlsson 13:08
Re: PG does not support one function of its extension pg_hint_plan Bruce Momjian 13:16
Re: Inquiry on Future Plans for Enhancements to PostgreSQL MVCC Model and Vacuum Process Heikki Linnakangas 13:37
Re: Making error message more user-friendly with spaces in a URI Greg Sabino Mullane 13:38
Re: Changing the default random_page_cost value Greg Sabino Mullane 13:54
Re: PG does not support one function of its extension pg_hint_plan Tom Lane 13:57
Re: Having problems generating a code coverage report Aleksander Alekseev 14:22
Re: define pg_structiszero(addr, s, r) Japin Li 15:01
Re: Changing shared_buffers without restart Dmitry Dolgov 15:27
Re: ActiveState Perl is not valid anymore to build PG17 on the Windows 10/11 platforms, So Documentation still suggesting it should be updated Bruce Momjian 15:32
Re: Having problems generating a code coverage report Aleksander Alekseev 15:42
Re: New function normal_rand_array function to contrib/tablefunc. Japin Li 15:45
Re: Count and log pages set all-frozen by vacuum Masahiko Sawada 16:22
Re: Count and log pages set all-frozen by vacuum Robert Haas 16:41
Re: Doc: typo in config.sgml Bruce Momjian 16:47
Re: UUID v7 Andrey M. Borodin 17:32
Re: Using read stream in autoprewarm Andrey M. Borodin 18:06
Re: Add missing tab completion for ALTER TABLE ADD COLUMN IF NOT EXISTS 📎 Kirill Reshke 18:06
Re: AIO writes vs hint bits vs checksums Andres Freund 18:10
Re: Collation & ctype method table, and extension hooks Jeff Davis 18:17
Re: Considering fractional paths in Append node 📎 Nikita Malakhov 18:18
Re: Adding NetBSD and OpenBSD to Postgres CI Andres Freund 18:44
Re: Allowing pg_recvlogical to create temporary replication slots 📎 Torsten Förtsch 19:04
Re: Separate memory contexts for relcache and catcache Andres Freund 19:19
Re: Should we document how column DEFAULT expressions work? Bruce Momjian 20:30
Re: UUID v7 Masahiko Sawada 21:23
Re: New "raw" COPY format Masahiko Sawada 21:28
Re: Using read_stream in index vacuum Kirill Reshke 21:36
Re: Count and log pages set all-frozen by vacuum Masahiko Sawada 21:38
Re: Separate memory contexts for relcache and catcache Jeff Davis 21:47
Re: [PATCH] pg_stat_activity: make slow/hanging authentication more visible 📎 Jacob Champion 21:47
Re: Using Expanded Objects other than Arrays from plpgsql Tom Lane 22:20
Re: Doc: typo in config.sgml Tatsuo Ishii 22:27
Re: Using Expanded Objects other than Arrays from plpgsql 📎 Tom Lane 22:27
Re: Separate memory contexts for relcache and catcache Andres Freund 22:48
Eagerly scan all-visible pages to amortize aggressive vacuum 📎 Melanie Plageman 23:35
Re: Inval reliability, especially for inplace updates 📎 Noah Misch 23:38

Nov. 2, 2024

Thread Author Time
Re: Using Expanded Objects other than Arrays from plpgsql Michel Pelletier 00:50
Re: Using Expanded Objects other than Arrays from plpgsql Michel Pelletier 00:53
Re: Doc: typo in config.sgml Bruce Momjian 01:28
Re: Doc: typo in config.sgml Tatsuo Ishii 03:02
Re: Consider pipeline implicit transaction as a transaction block Michael Paquier 03:11
Re: proposal: schema variables Laurenz Albe 05:46
Announcing Release 18 of the PostgreSQL Buildfarm client Andrew Dunstan 06:14
Re: proposal: schema variables Pavel Stehule 07:36
Re: What is a typical precision of gettimeofday()? Andrey M. Borodin 08:37
Re: Add ExprState hashing for GROUP BY and hashed SubPlans 📎 Andrei Lepikhov 09:13
Re: Count and log pages set all-frozen by vacuum Nitin Jadhav 11:04
Re: New "raw" COPY format Joel Jacobson 11:08
Re: Fix for Extra Parenthesis in pgbench progress message Tatsuo Ishii 11:43
Re: Vacuum statistics 📎 Alena Rybakina 12:22
Re: Vacuum statistics Alena Rybakina 12:24
Re: Doc: typo in config.sgml Bruce Momjian 13:18
Re: What is a typical precision of gettimeofday()? Tom Lane 14:27
Re: Alias of VALUES RTE in explain plan 📎 Tom Lane 17:09

Nov. 3, 2024

Thread Author Time
Re: general purpose array_sort 📎 Junwang Zhao 03:33
Clear padding in PgStat_HashKey keys 📎 Bertrand Drouvot 04:25
Repeat the condition check twice in function distribute_qual_to_rels [email protected] 06:18
Re: Improve the efficiency of _bt_killitems. feichanghong 11:56
Re: Pgoutput not capturing the generated columns 📎 vignesh C 13:27
Re: Pgoutput not capturing the generated columns vignesh C 15:22
Re: Inval reliability, especially for inplace updates 📎 Noah Misch 18:29
Re: EphemeralNamedRelation and materialized view Tom Lane 18:42
Re: Repeat the condition check twice in function distribute_qual_to_rels Tom Lane 19:07
Re: Time to add a Git .mailmap? Daniel Gustafsson 19:36
Re: pgsql: Implement pg_wal_replay_wait() stored procedure 📎 Alexander Korotkov 20:54
Re: pgsql: Implement pg_wal_replay_wait() stored procedure Alexander Korotkov 21:03
Re: What is a typical precision of gettimeofday()? Hannu Krosing 22:15
Re: What is a typical precision of gettimeofday()? Tom Lane 22:19

Nov. 4, 2024

Thread Author Time
Re: New function normal_rand_array function to contrib/tablefunc. Andy Fan 00:51
Re: Pgoutput not capturing the generated columns Peter Smith 02:12
Re: Pgoutput not capturing the generated columns Amit Kapila 03:20
Re: Wrong result when enable_partitionwise_join is on if collation of PartitionKey and Column is different. 📎 jian he 03:27
Re: pgsql: Implement pg_wal_replay_wait() stored procedure 📎 Alexander Korotkov 04:29
Re: Pgoutput not capturing the generated columns Ajin Cherian 04:30
Re: small pg_combinebackup improvements Amul Sul 04:40
Re: Pgoutput not capturing the generated columns Peter Smith 04:59
Re: [PoC] Federated Authn/z with OAUTHBEARER jian he 05:00
Re: Pgoutput not capturing the generated columns Amit Kapila 05:26
Re: general purpose array_sort Michael Paquier 05:46
Re: [PATCH] Rename trim_array() for consistency with the rest of array_* functions Michael Paquier 05:49
Re: pgsql: Implement pg_wal_replay_wait() stored procedure Michael Paquier 06:04
Re: Allowing pg_recvlogical to create temporary replication slots Michael Paquier 06:13
Re: general purpose array_sort jian he 07:16
Re: Clear padding in PgStat_HashKey keys Michael Paquier 07:25
Re: Support LIKE with nondeterministic collations 📎 Peter Eisentraut 08:26
Re: Clear padding in PgStat_HashKey keys Jelte Fennema-Nio 08:27
optimize the value of vacthresh and anlthresh 📎 wenhui qiu 08:30
Re: Clear padding in PgStat_HashKey keys Bertrand Drouvot 08:48
Re: Clear padding in PgStat_HashKey keys Bertrand Drouvot 08:52
Re: [PoC] Federated Authn/z with OAUTHBEARER Daniel Gustafsson 09:11
Re: proposal: schema variables Laurenz Albe 09:24
Re: relfilenode statistics Bertrand Drouvot 09:27
Re: relfilenode statistics 📎 Bertrand Drouvot 09:35
Re: Consider pipeline implicit transaction as a transaction block 📎 Anthonin Bonnefoy 09:42
Re: protocol-level wait-for-LSN Peter Eisentraut 09:47
Re: Clear padding in PgStat_HashKey keys Michael Paquier 09:49
Re: define pg_structiszero(addr, s, r) Bertrand Drouvot 09:50
Re: Pgoutput not capturing the generated columns Amit Kapila 10:01
Re: per backend I/O statistics Bertrand Drouvot 10:01
Re: Clear padding in PgStat_HashKey keys Bertrand Drouvot 10:07
Re: protocol-level wait-for-LSN Matthias van de Meent 10:08
Re: [PATCH] Rename trim_array() for consistency with the rest of array_* functions Aleksander Alekseev 10:36
Re: Pgoutput not capturing the generated columns Amit Kapila 10:54
Re: psql: Add leakproof field to \dAo+ meta-command results Dean Rasheed 11:00
Re: define pg_structiszero(addr, s, r) David Rowley 11:24
Re: Changing the state of data checksums in a running cluster 📎 Daniel Gustafsson 11:27
Re: Allowing pg_recvlogical to create temporary replication slots Amit Kapila 11:31
Re: general purpose array_sort Dean Rasheed 11:33
Re: Add missing tab completion for ALTER TABLE ADD COLUMN IF NOT EXISTS 📎 Kirill Reshke 11:50
Re: NOT ENFORCED constraint feature 📎 Amul Sul 12:17
Re: PG_TEST_EXTRA and meson Heikki Linnakangas 12:25
Re: Useless field ispartitioned in CreateStmtContext Kirill Reshke 13:38
Re: Allow default \watch interval in psql to be configured Kirill Reshke 13:55
Re: pgsql: Implement pg_wal_replay_wait() stored procedure Alexander Korotkov 14:02
Re: pgsql: Implement pg_wal_replay_wait() stored procedure Alvaro Herrera 14:19
Fix a typo in the comment of gistdoinsert() 📎 Tender Wang 14:31
Re: New function normal_rand_array function to contrib/tablefunc. Aleksander Alekseev 14:34
pg_dump --no-comments confusion Bruce Momjian 14:41
Re: New function normal_rand_array function to contrib/tablefunc. Aleksander Alekseev 14:46
Re: Pgoutput not capturing the generated columns 📎 vignesh C 14:58
Re: Pgoutput not capturing the generated columns vignesh C 15:11
Re: pg_dump --no-comments confusion Matthias van de Meent 15:13
Re: Pgoutput not capturing the generated columns vignesh C 15:16
Re: small pg_combinebackup improvements Robert Haas 15:26
Re: pgsql: Implement pg_wal_replay_wait() stored procedure Robert Haas 15:53
Re: pgsql: Implement pg_wal_replay_wait() stored procedure Heikki Linnakangas 15:57
Re: Popcount optimization using AVX512 Nathan Bossart 16:07
Re: Latches vs lwlock contention Heikki Linnakangas 16:08
Re: Converting contrib SQL functions to new style Tom Lane 16:10
Bug in create type when missed the comma between element list Diego 16:17
Re: Bug in create type when missed the comma between element list David G. Johnston 16:19
Re: Wrong security context for deferred triggers? Tom Lane 16:22
Re: pg_dump --no-comments confusion Erik Wienhold 16:24
Re: Bug in create type when missed the comma between element list Diego 16:28
Re: Adding skip scan (including MDAM style range skip scan) to nbtree 📎 Peter Geoghegan 16:41
Re: documentation structure Heikki Linnakangas 16:42
Re: pgsql: Implement pg_wal_replay_wait() stored procedure Robert Haas 16:53
Re: pgsql: Implement pg_wal_replay_wait() stored procedure Heikki Linnakangas 17:11

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