pgsql-hackers since 2024-10-31 16:39

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)

Browse Archives

Prev | Next

Oct. 31, 2024

Thread Author Time
Re: Use "protocol options" name instead of "protocol extensions" everywhere Jacob Champion 16:39
Re: Use "protocol options" name instead of "protocol extensions" everywhere Jelte Fennema-Nio 17:15
Re: "command cannot affect row a second time" in INSERT ... ON CONFLICT Aleksander Alekseev 17:21
Re: DOCS - pg_replication_slot . Fix the 'inactive_since' description 📎 Bruce Momjian 17:22
Re: Use "protocol options" name instead of "protocol extensions" everywhere Jelte Fennema-Nio 17:25
Re: MultiXact\SLRU buffers configuration Andrey M. Borodin 17:32
Re: DOCS - pg_replication_slot . Fix the 'inactive_since' description 📎 Bruce Momjian 17:35
Re: "command cannot affect row a second time" in INSERT ... ON CONFLICT David G. Johnston 17:41
Re: Changing the default random_page_cost value Bruce Momjian 17:43
Re: Changing the default random_page_cost value Tom Lane 17:53
Re: meson and check-tests 📎 Nazir Bilal Yavuz 17:58
[PATCH] Add support for displaying database service in psql prompt 📎 Michael Banck 18:01
Re: WIP: parallel GiST index builds Andrey M. Borodin 18:05
Re: [PATCH] Improve code coverage of network address functions Stepan Neretin 18:07
Re: Count and log pages set all-frozen by vacuum Masahiko Sawada 18:12
Re: UUID v7 Masahiko Sawada 18:15
Re: Using read stream in autoprewarm Andrey M. Borodin 18:18
Re: [PATCH] Improve code coverage of network address functions Aleksander Alekseev 18:19
Re: UUID v7 📎 Andrey M. Borodin 18:45
Re: Count and log pages set all-frozen by vacuum Melanie Plageman 18:50
Re: Fix for consume_xids advancing XIDs incorrectly Masahiko Sawada 18:53
Re: Multi delete wal IDEA Melanie Plageman 18:58
Re: Using read stream in autoprewarm Stepan Neretin 19:01
Re: UUID v7 Stepan Neretin 19:04
Re: Popcount optimization using AVX512 📎 Nathan Bossart 19:21
Re: MultiXact\SLRU buffers configuration Thom Brown 19:25
Re: RFC: Extension Packaging & Lookup David E. Wheeler 19:41
Re: Time to add a Git .mailmap? Nathan Bossart 19:45
RE: Popcount optimization using AVX512 Devulapalli, Raghuveer 19:58
Re: Inval reliability, especially for inplace updates 📎 Noah Misch 20:01
Re: make all ereport in gram.y print out relative location Tom Lane 20:11
Re: RFC: Extension Packaging & Lookup David E. Wheeler 20:12
Re: pg_parse_json() should not leak token copies on failure 📎 Jacob Champion 21:10
Re: In-placre persistance change of a relation Heikki Linnakangas 21:24
Re: [PATCH] New predefined role pg_manage_extensions 📎 Michael Banck 21:47
Re: IPC::Run::time[r|out] vs our TAP tests Heikki Linnakangas 22:18
Re: Count and log pages set all-frozen by vacuum 📎 Melanie Plageman 22:30
Re: Test to dump and restore objects left behind by regression Michael Paquier 22:58
Re: UUID v7 Masahiko Sawada 23:00
Re: Add ExprState hashing for GROUP BY and hashed SubPlans 📎 David Rowley 23:17
Re: Using Expanded Objects other than Arrays from plpgsql Michel Pelletier 23:41
Re: Using Expanded Objects other than Arrays from plpgsql Michel Pelletier 23:51

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

Browse Archives

Prev | Next