pgsql-hackers since 2024-10-29 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

Oct. 29, 2024

Thread	Author	Time
Re: EXPLAIN IndexOnlyScan shows disabled when enable_indexonlyscan=on	David G. Johnston	00:29
Re: Questions About TODO: Issuing NOTICEs for row count differences in EXPLAIN ANALYZE	David Rowley	00:39
freespace.c modifies buffer without any locks	Andres Freund	00:50
Re: EXPLAIN IndexOnlyScan shows disabled when enable_indexonlyscan=on	David Rowley	01:03
Re: sunsetting md5 password support 📎	Nathan Bossart	01:06
Re: ActiveState Perl is not valid anymore to build PG17 on the Windows 10/11 platforms, So Documentation still suggesting it should be updated	Michael Paquier	01:24
Re: EXPLAIN IndexOnlyScan shows disabled when enable_indexonlyscan=on	David G. Johnston	01:25
Re: detoast datum into the given buffer as a optimization.	Andy Fan	01:26
Re: EXPLAIN IndexOnlyScan shows disabled when enable_indexonlyscan=on	David G. Johnston	01:40
Re: Statistics Import and Export 📎	Jeff Davis	01:55
Re: Pgoutput not capturing the generated columns	Peter Smith	02:14
Re: Consider the number of columns in the sort cost model 📎	Andrei Lepikhov	02:47
Re: EXPLAIN IndexOnlyScan shows disabled when enable_indexonlyscan=on	David Rowley	03:06
Re: Introduce new multi insert Table AM and improve performance of various SQL commands with it for Heap AM	Jingtang Zhang	03:18
Re: Reduce one comparison in binaryheap's sift down 📎	cca5507	03:21
Re: Add isolation test template in injection_points for wait/wakeup/detach	Michael Paquier	04:12
Re: Pgoutput not capturing the generated columns	Amit Kapila	04:23
Re: Why don't we consider explicit Incremental Sort?	Andrei Lepikhov	04:43
Re: protocol-level wait-for-LSN	Tatsuo Ishii	05:06
Re: Alias of VALUES RTE in explain plan	Yasir	05:32
RE: Pgoutput not capturing the generated columns	Hayato Kuroda (Fujitsu)	05:49
Re: Pgoutput not capturing the generated columns	Peter Smith	06:00
Re: Pgoutput not capturing the generated columns	Amit Kapila	06:15
Re: Wrong result when enable_partitionwise_join is on if collation of PartitionKey and Column is different. 📎	jian he	06:15
Re: Forbid to DROP temp tables of other sessions 📎	Daniil Davydov	06:21
RE: [PoC] Partition path cache	Bykov Ivan	06:27
Re: Pgoutput not capturing the generated columns	Amit Kapila	06:28
Re: protocol-level wait-for-LSN	Peter Eisentraut	06:28
Re: Wrong result when enable_partitionwise_join is on if collation of PartitionKey and Column is different.	Tender Wang	06:38
Re: -Wformat-signedness	Peter Eisentraut	06:38
Re: detoast datum into the given buffer as a optimization. 📎	Andy Fan	06:45
Re: -Wformat-signedness	Michael Paquier	06:51
Re: On disable_cost	Laurenz Albe	07:04
Re: proposal: schema variables 📎	Pavel Stehule	07:16
Re: Converting contrib SQL functions to new style 📎	Ronan Dunklau	07:28
Re: Eager aggregation, take 3	Richard Guo	07:51
Re: define pg_structiszero(addr, s, r) 📎	Bertrand Drouvot	07:54
Re: Eager aggregation, take 3	Richard Guo	07:56
RE: Conflict detection for update_deleted in logical replication	Hayato Kuroda (Fujitsu)	07:59
Re: Add isolation test template in injection_points for wait/wakeup/detach	Bertrand Drouvot	07:59
Remove useless casts to (void *) 📎	Peter Eisentraut	08:06
[PATCH] Fixed creation of empty .log files during log rotation 📎	Арсений Косицын	08:08
Re: Add isolation test template in injection_points for wait/wakeup/detach	Michael Paquier	08:20
Re: general purpose array_sort	jian he	08:28
Re: -Wformat-signedness	Peter Eisentraut	08:33
Re: Support regular expressions with nondeterministic collations	Peter Eisentraut	08:47
Re: Fix for consume_xids advancing XIDs incorrectly	Yushi Ogiwara	09:00
Re: define pg_structiszero(addr, s, r)	Peter Eisentraut	09:23
Re: Alias of VALUES RTE in explain plan	Andrei Lepikhov	09:24
Re: Make all Perl warnings fatal	Peter Eisentraut	09:34
Re: Pgoutput not capturing the generated columns	vignesh C	09:35
Re: define pg_structiszero(addr, s, r)	Heikki Linnakangas	09:39
Re: Pgoutput not capturing the generated columns 📎	vignesh C	09:40
Re: Add ExprState hashing for GROUP BY and hashed SubPlans 📎	David Rowley	09:47
Re: Pgoutput not capturing the generated columns	vignesh C	09:48
Re: Replace current implementations in crypt() and gen_salt() to OpenSSL	Daniel Gustafsson	09:57
Re: Question about VACUUM behavior with sub-transactions in stored procedures	Кириллов Вячеслав	10:21
Re: On disable_cost	David Rowley	10:29
Re: Forbid to DROP temp tables of other sessions	Stepan Neretin	10:37
Re: Conflict detection for update_deleted in logical replication	Michail Nikolaev	10:40
Re: protocol-level wait-for-LSN	Matthias van de Meent	10:45
Re: [PoC] Federated Authn/z with OAUTHBEARER	Daniel Gustafsson	10:52
Re: Vacuum statistics	Alena Rybakina	11:02
Re: Pgoutput not capturing the generated columns	Shubham Khanna	11:38
Re: doc issues in event-trigger-matrix.html 📎	Peter Eisentraut	11:54
[PATCH] Rename trim_array() for consistency with the rest of array_* functions 📎	Aleksander Alekseev	12:01
Avoid possible useless call to makeNode function (src/backend/commands/view.c) 📎	Ranier Vilela	12:07
Re: [PATCH] Rename trim_array() for consistency with the rest of array_* functions	Vik Fearing	12:12
Re: [PATCH] Rename trim_array() for consistency with the rest of array_* functions	Marcos Pegoraro	12:12
Re: general purpose array_sort	Aleksander Alekseev	12:14
Re: detoast datum into the given buffer as a optimization.	Nikita Malakhov	12:19
Re: [PATCH] Rename trim_array() for consistency with the rest of array_* functions	Aleksander Alekseev	12:23
Re: Avoid possible useless call to makeNode function (src/backend/commands/view.c)	David Rowley	12:25
Re: Vacuum statistics	Andrei Zubkov	12:40
Re: Avoid possible useless call to makeNode function (src/backend/commands/view.c)	Ranier Vilela	12:45
Re: detoast datum into the given buffer as a optimization.	Andy Fan	12:48
Re: Replace current implementations in crypt() and gen_salt() to OpenSSL	Joe Conway	12:53
Re: Eager aggregation, take 3	Robert Haas	12:59
Re: Adding OLD/NEW support to RETURNING 📎	Dean Rasheed	13:05
Re: Alias of VALUES RTE in explain plan	Ashutosh Bapat	13:38
Re: detoast datum into the given buffer as a optimization.	Nikita Malakhov	13:44
Re: define pg_structiszero(addr, s, r) 📎	Bertrand Drouvot	13:58
Re: Alias of VALUES RTE in explain plan	Tom Lane	14:02
Re: define pg_structiszero(addr, s, r)	Bertrand Drouvot	14:03
Re: Add isolation test template in injection_points for wait/wakeup/detach	Bertrand Drouvot	14:06
Re: Replace current implementations in crypt() and gen_salt() to OpenSSL	Daniel Gustafsson	14:08
Re: Support regular expressions with nondeterministic collations	Tom Lane	14:12
Re: Remove useless casts to (void *)	Tom Lane	14:20
Cleanup SubPlanstate 📎	Rafia Sabih	14:34
Re: make all ereport in gram.y print out relative location	Alvaro Herrera	14:48
Re: general purpose array_sort 📎	Junwang Zhao	14:49
Re: Enhancing Memory Context Statistics Reporting	Andres Freund	14:51
Re: doc issues in event-trigger-matrix.html	Daniel Gustafsson	14:53
Re: Reduce one comparison in binaryheap's sift down	Nathan Bossart	15:00
Re: Pgoutput not capturing the generated columns 📎	vignesh C	15:20
Scrollable cursors that use an nbtree index scan are subtly broken with array keys (bug affecting 17+) 📎	Peter Geoghegan	16:01
Re: protocol-level wait-for-LSN	Jesper Pedersen	16:03
Re: protocol-level wait-for-LSN	Jesper Pedersen	16:22
Re: RFC: Extension Packaging & Lookup	Paul Ramsey	16:23
Re: CSN snapshots in hot standby 📎	Heikki Linnakangas	16:33
Re: MultiXact\SLRU buffers configuration	Thom Brown	16:38
Re: [PoC] Federated Authn/z with OAUTHBEARER	Jacob Champion	16:40
Re: New "raw" COPY format 📎	Joel Jacobson	16:48
Re: RFC: Extension Packaging & Lookup	Christoph Berg	16:51
Re: Replace current implementations in crypt() and gen_salt() to OpenSSL	Jacob Champion	16:52
Re: RFC: Extension Packaging & Lookup	David E. Wheeler	17:03
Re: RFC: Extension Packaging & Lookup	David E. Wheeler	17:09
Re: RFC: Extension Packaging & Lookup	David E. Wheeler	17:11
Re: Support LIKE with nondeterministic collations	Jacob Champion	17:15
Re: RFC: Extension Packaging & Lookup	David E. Wheeler	17:16
Re: RFC: Extension Packaging & Lookup	Paul Ramsey	17:16
Re: Alias of VALUES RTE in explain plan	Tom Lane	17:19
Re: Replace current implementations in crypt() and gen_salt() to OpenSSL	Joe Conway	17:34
Re: RFC: Extension Packaging & Lookup	Tristan Partin	17:40
Re: [PoC] Federated Authn/z with OAUTHBEARER	Daniel Gustafsson	17:41
Re: MultiXact\SLRU buffers configuration	Thom Brown	17:45
Re: RFC: Extension Packaging & Lookup	David E. Wheeler	17:47
Re: RFC: Extension Packaging & Lookup	David E. Wheeler	17:55
Re: RFC: Extension Packaging & Lookup	Paul Ramsey	18:03
Re: Fix for consume_xids advancing XIDs incorrectly	Fujii Masao	18:09
Re: RFC: Extension Packaging & Lookup	Christoph Berg	18:09
Re: RFC: Extension Packaging & Lookup	David E. Wheeler	18:11
Re: RFC: Extension Packaging & Lookup	David E. Wheeler	18:12
Always have pg_dump write rules in a consistent order 📎	Andreas Karlsson	18:50
Re: Popcount optimization using AVX512	Raghuveer Devulapalli	19:23
Re: SQL Property Graph Queries (SQL/PGQ) 📎	Andreas Karlsson	19:55
Re: Eager aggregation, take 3	Robert Haas	20:05
Re: Skip collecting decoded changes of already-aborted transactions 📎	Masahiko Sawada	20:24
Reorganize cache memory contexts 📎	Jeff Davis	20:29
Re: Skip collecting decoded changes of already-aborted transactions	Masahiko Sawada	20:29
Re: [PoC] Federated Authn/z with OAUTHBEARER 📎	Jacob Champion	20:34
Re: [PoC] Federated Authn/z with OAUTHBEARER	Jacob Champion	20:39
RE: Proposal for Updating CRC32C with AVX-512 Algorithm. 📎	Devulapalli, Raghuveer	21:00
Re: Reorganize cache memory contexts	David Rowley	21:28
Re: Reorganize cache memory contexts	Jeff Davis	21:44
Re: Separate memory contexts for relcache and catcache	Jeff Davis	22:00
Re: Vacuum statistics	Jim Nasby	22:23
Re: doc issues in event-trigger-matrix.html	Michael Paquier	22:33
Re: detoast datum into the given buffer as a optimization.	Andy Fan	23:47
Re: Avoid detoast overhead when possible	Andy Fan	23:59

Oct. 30, 2024

Thread	Author	Time
Re: Alias of VALUES RTE in explain plan	Andrei Lepikhov	01:54
Re: make all ereport in gram.y print out relative location 📎	jian he	02:05
Re: AIO writes vs hint bits vs checksums 📎	Andres Freund	02:21
Re: Cleanup SubPlanstate	Andrei Lepikhov	02:44
RE: Conflict detection for update_deleted in logical replication	Hayato Kuroda (Fujitsu)	02:55
Re: Add isolation test template in injection_points for wait/wakeup/detach 📎	Michael Paquier	03:40
Re: Wrong result when enable_partitionwise_join is on if collation of PartitionKey and Column is different. 📎	jian he	03:57
Re: Psql meta-command conninfo+ 📎	Hunaid Sohail	06:07
Re: protocol-level wait-for-LSN	Tatsuo Ishii	06:49
Re: Fix for consume_xids advancing XIDs incorrectly 📎	Yushi Ogiwara	07:00
Re: [PATCH] Add roman support for to_number function 📎	Hunaid Sohail	07:07
Re: Add isolation test template in injection_points for wait/wakeup/detach	Bertrand Drouvot	07:26
Re: unicode test programs don't build with meson	Peter Eisentraut	07:32
Re: Question about VACUUM behavior with sub-transactions in stored procedures	Кириллов Вячеслав	07:43
Re: Allowing pg_recvlogical to create temporary replication slots	Peter Eisentraut	08:00
Re: define pg_structiszero(addr, s, r)	Peter Eisentraut	08:09
Re: New "raw" COPY format 📎	Joel Jacobson	08:14
RE: Conflict detection for update_deleted in logical replication	Hayato Kuroda (Fujitsu)	08:33
Re: protocol-level wait-for-LSN	Jelte Fennema-Nio	08:41
Re: protocol-level wait-for-LSN	Jelte Fennema-Nio	09:03
Re: protocol-level wait-for-LSN	Jelte Fennema-Nio	09:04
Re: Useless field ispartitioned in CreateStmtContext	Kirill Reshke	09:07
Consider pipeline implicit transaction as a transaction block 📎	Anthonin Bonnefoy	09:14
Re: Add isolation test template in injection_points for wait/wakeup/detach 📎	Michael Paquier	09:21
Re: define pg_structiszero(addr, s, r) 📎	Bertrand Drouvot	09:23
Re: Add isolation test template in injection_points for wait/wakeup/detach	Bertrand Drouvot	09:27
Re: Pgoutput not capturing the generated columns	Amit Kapila	09:36
Re: freespace.c modifies buffer without any locks	Heikki Linnakangas	09:44
Re: Index AM API cleanup	Peter Eisentraut	10:54
Re: Avoid detoast overhead when possible	Nikita Malakhov	11:22
Re: AIO writes vs hint bits vs checksums	Heikki Linnakangas	11:29
Re: Conflict detection for update_deleted in logical replication	Michail Nikolaev	11:31
Re: protocol-level wait-for-LSN	Tatsuo Ishii	11:34
Re: protocol-level wait-for-LSN	Heikki Linnakangas	11:53
Re: New "raw" COPY format	Joel Jacobson	11:53
Re: Reduce one comparison in binaryheap's sift down	Robert Haas	12:09
Re: AIO writes vs hint bits vs checksums	Heikki Linnakangas	12:16
Re: doc issues in event-trigger-matrix.html	jian he	12:31
Re: Forbid to DROP temp tables of other sessions	Rafia Sabih	12:32
Re: Wrong result when enable_partitionwise_join is on if collation of PartitionKey and Column is different.	Junwang Zhao	12:36
Re: Alias of VALUES RTE in explain plan	Ashutosh Bapat	12:46
Re: Eager aggregation, take 3	Robert Haas	13:09
Re: detoast datum into the given buffer as a optimization.	Nikita Malakhov	13:23
Re: general purpose array_sort	Aleksander Alekseev	13:29
Re: AIO writes vs hint bits vs checksums	Andres Freund	13:58
Use "protocol options" name instead of "protocol extensions" everywhere 📎	Jelte Fennema-Nio	13:58
Re: protocol-level wait-for-LSN	Jelte Fennema-Nio	14:01
Re: general purpose array_sort	Junwang Zhao	14:17
Re: general purpose array_sort 📎	Junwang Zhao	14:41
Re: Consider pipeline implicit transaction as a transaction block	Jelte Fennema-Nio	15:06
Re: [17] CREATE SUBSCRIPTION ... SERVER 📎	Jeff Davis	15:08
Re: Eager aggregation, take 3	Robert Haas	15:25
Re: Eager aggregation, take 3	Robert Haas	15:30
Re: Interrupts vs signals	Heikki Linnakangas	16:03
Re: Pgoutput not capturing the generated columns 📎	vignesh C	16:16
Re: Reduce one comparison in binaryheap's sift down	Nathan Bossart	16:30
Re: AIO writes vs hint bits vs checksums	Andres Freund	16:45
Re: protocol-level wait-for-LSN	Ants Aasma	17:17
Re: Parallel heap vacuum 📎	Masahiko Sawada	17:17
Re: Interrupts vs signals	Robert Haas	17:23

Browse Archives

Prev | Next