public inbox for [email protected]
help / color / mirror / Atom feedSlow queries on simple index
2026-01-17 13:58 UTC Lillian Berry <[email protected]>
` Re: Slow queries on simple index
2026-01-17 14:59 UTC Pavel Stehule <[email protected]>
` Re: Slow queries on simple index
2026-01-17 15:28 UTC Ken Marshall <[email protected]>
` Re: Slow queries on simple index
2026-01-17 16:57 UTC Tom Lane <[email protected]>
` Re: Slow queries on simple index
2026-01-17 19:33 UTC Lillian Berry <[email protected]>
` Re: Slow queries on simple index
2026-01-17 20:21 UTC Andrei Lepikhov <[email protected]>
` Re: Slow queries on simple index
2026-01-17 20:52 UTC Lillian Berry <[email protected]>
` Re: Slow queries on simple index
2026-01-17 21:10 UTC Tom Lane <[email protected]>
` [Solved] Slow queries on simple index
2026-01-17 22:06 UTC Lillian Berry <[email protected]>
` Re: Slow queries on simple index
2026-01-18 09:24 UTC Andrei Lepikhov <[email protected]>
[10+ messages in thread]
Troubleshooting a brief spike in active sessions
2026-01-09 21:41 UTC Dirschel, Steve-CW <[email protected]>
` Re: Troubleshooting a brief spike in active sessions
2026-01-09 21:58 UTC Joshua Banton <[email protected]>
` Re: Troubleshooting a brief spike in active sessions
2026-01-09 22:27 UTC Nikolay Samokhvalov <[email protected]>
` Re: Troubleshooting a brief spike in active sessions
2026-01-09 22:29 UTC Nikolay Samokhvalov <[email protected]>
[4+ messages in thread]
Another unexpected planner choice in simple JOIN
2026-01-09 00:12 UTC Mark Kirkwood <[email protected]>
` Re: Another unexpected planner choice in simple JOIN
2026-01-09 01:15 UTC Mark Kirkwood <[email protected]>
[2+ messages in thread]
Unexpected planner choice in simple JOIN
2026-01-08 01:35 UTC Mark Kirkwood <[email protected]>
` Re: Unexpected planner choice in simple JOIN
2026-01-08 03:34 UTC Mark Kirkwood <[email protected]>
` Re: Unexpected planner choice in simple JOIN
2026-01-08 03:56 UTC David Rowley <[email protected]>
` Re: Unexpected planner choice in simple JOIN
2026-01-08 04:03 UTC Mark Kirkwood <[email protected]>
` Re: Unexpected planner choice in simple JOIN
2026-01-08 04:14 UTC David Rowley <[email protected]>
` Re: Unexpected planner choice in simple JOIN
2026-01-08 04:24 UTC Mark Kirkwood <[email protected]>
` Re: Unexpected planner choice in simple JOIN
2026-01-08 04:34 UTC Tom Lane <[email protected]>
` Re: Unexpected planner choice in simple JOIN
2026-01-08 04:44 UTC Mark Kirkwood <[email protected]>
` Re: Unexpected planner choice in simple JOIN
2026-01-08 04:51 UTC Tom Lane <[email protected]>
` Re: Unexpected planner choice in simple JOIN
2026-01-08 04:55 UTC Mark Kirkwood <[email protected]>
[10+ messages in thread]
Surprising optimizer behavior with a subquery, a GROUP BY, and a range filter
2026-01-02 20:26 UTC wotq <[email protected]>
` Re: Surprising optimizer behavior with a subquery, a GROUP BY, and a range filter
2026-01-02 20:46 UTC Tom Lane <[email protected]>
[2+ messages in thread]
Seeking guidance on extremely slow pg_restore despite strong I/O performance
2025-12-05 10:30 UTC MentionTheElephant <[email protected]>
` Re: Seeking guidance on extremely slow pg_restore despite strong I/O performance
2025-12-05 20:27 UTC [email protected]
` Re: Seeking guidance on extremely slow pg_restore despite strong I/O performance
2025-12-08 00:53 UTC Jeff Janes <[email protected]>
[3+ messages in thread]
Client-server communication for FETCH
2025-12-03 18:02 UTC Tim Fors <[email protected]>
` Re: Client-server communication for FETCH
2025-12-03 18:41 UTC Tom Lane <[email protected]>
` Re: Client-server communication for FETCH
2025-12-03 19:45 UTC Tim Fors <[email protected]>
` Re: Client-server communication for FETCH
2025-12-05 09:08 UTC Jan Claeys <[email protected]>
[4+ messages in thread]
Why is my query 3 times faster on my workstation than on my server?
2025-12-04 18:46 UTC Vincent Veyron <[email protected]>
` Re: Why is my query 3 times faster on my workstation than on my server?
2025-12-04 18:53 UTC Pavel Stehule <[email protected]>
` Re: Why is my query 3 times faster on my workstation than on my server?
2025-12-04 19:06 UTC Tom Lane <[email protected]>
` RE: Why is my query 3 times faster on my workstation than on my server?
2025-12-04 19:51 UTC Clay Jackson (cjackson) <[email protected]>
` Re: Why is my query 3 times faster on my workstation than on my server?
2025-12-04 22:56 UTC Vincent Veyron <[email protected]>
[5+ messages in thread]
Multicolumn index scan efficiency
2025-11-10 02:44 UTC Vitalii Tymchyshyn <[email protected]>
` Re: Multicolumn index scan efficiency
2025-11-10 04:20 UTC Peter Geoghegan <[email protected]>
` Re: Multicolumn index scan efficiency
2025-11-10 05:12 UTC Vitalii Tymchyshyn <[email protected]>
` Re: Multicolumn index scan efficiency
2025-11-10 17:00 UTC Peter Geoghegan <[email protected]>
[4+ messages in thread]
Index Searches higher than expected for skip scan
2025-11-06 19:00 UTC Michael Christofides <[email protected]>
` Re: Index Searches higher than expected for skip scan
2025-11-06 19:54 UTC Peter Geoghegan <[email protected]>
` Re: Index Searches higher than expected for skip scan
2025-11-06 20:39 UTC Peter Geoghegan <[email protected]>
` Re: Index Searches higher than expected for skip scan
2025-11-07 11:16 UTC Michael Christofides <[email protected]>
` Re: Index Searches higher than expected for skip scan
2025-11-07 15:00 UTC Peter Geoghegan <[email protected]>
[5+ messages in thread]
Problem getting query to use index inside a function
2025-11-05 16:02 UTC Dirschel, Steve <[email protected]>
` Re: Problem getting query to use index inside a function
2025-11-05 16:18 UTC Tom Lane <[email protected]>
` RE: [EXT] Re: Problem getting query to use index inside a function
2025-11-05 16:55 UTC Dirschel, Steve <[email protected]>
` Re: [EXT] Re: Problem getting query to use index inside a function
2025-11-05 19:17 UTC Tom Lane <[email protected]>
` RE: [EXT] Re: Problem getting query to use index inside a function
2025-11-05 20:18 UTC Dirschel, Steve <[email protected]>
[5+ messages in thread]
trgm and index-usage when using similarity function
2025-11-05 08:18 UTC Andreas Joseph Krogh <[email protected]>
GEQO plans much slower than standard join plans
2025-10-27 18:17 UTC Carlo Sganzerla <[email protected]>
` Re: GEQO plans much slower than standard join plans
2025-10-28 01:24 UTC Tomas Vondra <[email protected]>
` Re: GEQO plans much slower than standard join plans
2025-10-28 15:43 UTC Carlo Sganzerla <[email protected]>
` Re: GEQO plans much slower than standard join plans
2025-10-29 02:05 UTC Tomas Vondra <[email protected]>
` Re: GEQO plans much slower than standard join plans
2025-10-29 14:57 UTC Carlo Sganzerla <[email protected]>
` Re: GEQO plans much slower than standard join plans
2025-10-31 01:19 UTC David Rowley <[email protected]>
[6+ messages in thread]
Performance implications of partitioning by UUIDv7 range in PostgreSQL v18
2025-10-22 03:37 UTC Jonathan Reis <[email protected]>
` Re: Performance implications of partitioning by UUIDv7 range in PostgreSQL v18
2025-10-22 19:55 UTC David Rowley <[email protected]>
` Re: Performance implications of partitioning by UUIDv7 range in PostgreSQL v18
2025-10-22 21:05 UTC Olof Salberger <[email protected]>
` Re: Performance implications of partitioning by UUIDv7 range in PostgreSQL v18
2025-10-23 16:51 UTC Greg Sabino Mullane <[email protected]>
` Re: Performance implications of partitioning by UUIDv7 range in PostgreSQL v18
2025-10-23 20:11 UTC Jonathan Reis <[email protected]>
` Re: Performance implications of partitioning by UUIDv7 range in PostgreSQL v18
2025-10-23 20:38 UTC Laurenz Albe <[email protected]>
` Re: Performance implications of partitioning by UUIDv7 range in PostgreSQL v18
2025-10-23 22:54 UTC David Rowley <[email protected]>
` Re: Performance implications of partitioning by UUIDv7 range in PostgreSQL v18
2025-10-24 02:14 UTC Jonathan Reis <[email protected]>
` Re: Performance implications of partitioning by UUIDv7 range in PostgreSQL v18
2025-10-24 05:04 UTC Laurenz Albe <[email protected]>
` Re: Performance implications of partitioning by UUIDv7 range in PostgreSQL v18
2025-10-24 12:38 UTC Greg Sabino Mullane <[email protected]>
` Re: Performance implications of partitioning by UUIDv7 range in PostgreSQL v18
2025-10-24 15:24 UTC Jonathan Reis <[email protected]>
[11+ messages in thread]
Re: Indexes on expressions with multiple columns and operators
2025-10-13 14:00 UTC Andrei Lepikhov <[email protected]>
` Re: Indexes on expressions with multiple columns and operators
2025-10-13 14:55 UTC Tom Lane <[email protected]>
` Re: Indexes on expressions with multiple columns and operators
2025-10-14 09:29 UTC Andrei Lepikhov <[email protected]>
[3+ messages in thread]
Re: Indexes on expressions with multiple columns and operators
2025-10-13 13:56 UTC Andrei Lepikhov <[email protected]>
Re: Poor performance with row wise comparisons
2025-10-09 21:53 UTC Peter Geoghegan <[email protected]>
` Re: Poor performance with row wise comparisons
2025-10-10 04:21 UTC [email protected]
` Re: Poor performance with row wise comparisons
2025-10-11 23:03 UTC David G. Johnston <[email protected]>
[3+ messages in thread]
Question about nested loops..
2025-10-09 08:52 UTC Frits Jalvingh <[email protected]>
` Re: Question about nested loops..
2025-10-09 10:00 UTC Andrei Lepikhov <[email protected]>
` Re: Question about nested loops..
2025-10-10 09:28 UTC Andrei Lepikhov <[email protected]>
[3+ messages in thread]
Partition pruning is not happening (even in PG18)
2025-09-25 19:34 UTC Lauro Ojeda <[email protected]>
` Re: Partition pruning is not happening (even in PG18)
2025-09-25 20:10 UTC Michał Kłeczek <[email protected]>
` Re: Partition pruning is not happening (even in PG18)
2025-09-25 20:13 UTC Michał Kłeczek <[email protected]>
` Re: Partition pruning is not happening (even in PG18)
2025-09-25 20:17 UTC David Rowley <[email protected]>
` Re: Partition pruning is not happening (even in PG18)
2025-09-29 13:49 UTC Lauro Ojeda <[email protected]>
` Re: Partition pruning is not happening (even in PG18)
2025-09-29 20:05 UTC Chetan <[email protected]>
` Re: Partition pruning is not happening (even in PG18)
2025-09-29 20:08 UTC David Rowley <[email protected]>
[7+ messages in thread]
Indexes on expressions with multiple columns and operators
2025-09-17 13:55 UTC Frédéric Yhuel <[email protected]>
` Re: Indexes on expressions with multiple columns and operators
2025-09-17 14:22 UTC Laurenz Albe <[email protected]>
` Re: Indexes on expressions with multiple columns and operators
2025-09-17 14:41 UTC Tom Lane <[email protected]>
` Re: Indexes on expressions with multiple columns and operators
2025-09-17 14:57 UTC Frédéric Yhuel <[email protected]>
` Re: Indexes on expressions with multiple columns and operators
2025-09-17 15:33 UTC Frédéric Yhuel <[email protected]>
` Re: Indexes on expressions with multiple columns and operators
2025-09-18 15:26 UTC Jehan-Guillaume de Rorthais <[email protected]>
` Re: Indexes on expressions with multiple columns and operators
2025-09-18 15:32 UTC Tom Lane <[email protected]>
` Re: Indexes on expressions with multiple columns and operators
2025-09-18 16:40 UTC Tom Lane <[email protected]>
` Re: Indexes on expressions with multiple columns and operators
2025-09-18 16:48 UTC Ranier Vilela <[email protected]>
` Re: Indexes on expressions with multiple columns and operators
2025-09-18 16:59 UTC Tom Lane <[email protected]>
` Re: Indexes on expressions with multiple columns and operators
2025-09-19 07:50 UTC Frédéric Yhuel <[email protected]>
` Re: Indexes on expressions with multiple columns and operators
2025-09-19 14:37 UTC Jehan-Guillaume de Rorthais <[email protected]>
` Re: Indexes on expressions with multiple columns and operators
2025-09-20 16:51 UTC Tom Lane <[email protected]>
` Re: Indexes on expressions with multiple columns and operators
2025-09-22 13:37 UTC Frédéric Yhuel <[email protected]>
` Re: Indexes on expressions with multiple columns and operators
2025-09-22 13:57 UTC Andrei Lepikhov <[email protected]>
` Re: Indexes on expressions with multiple columns and operators
2025-09-22 16:09 UTC Frédéric Yhuel <[email protected]>
` Re: Indexes on expressions with multiple columns and operators
2025-09-22 21:15 UTC Andrei Lepikhov <[email protected]>
` Re: Indexes on expressions with multiple columns and operators
2025-09-23 10:20 UTC Frédéric Yhuel <[email protected]>
` Re: Indexes on expressions with multiple columns and operators
2025-09-23 10:43 UTC Andrei Lepikhov <[email protected]>
` Re: Indexes on expressions with multiple columns and operators
2025-09-23 13:31 UTC Frédéric Yhuel <[email protected]>
` Re: Indexes on expressions with multiple columns and operators
2025-09-25 10:41 UTC Frédéric Yhuel <[email protected]>
` Re: Indexes on expressions with multiple columns and operators
2025-09-25 10:43 UTC Frédéric Yhuel <[email protected]>
[22+ messages in thread]
Very expensive update to update a single row
2025-09-23 19:40 UTC Dirschel, Steve <[email protected]>
` Re: Very expensive update to update a single row
2025-09-23 21:12 UTC Sean M <[email protected]>
[2+ messages in thread]
Re: Poor row estimates from planner, stat `most_common_elems` sometimes missing for a text[] column
2025-09-08 19:13 UTC Matt Long <[email protected]>
` Re: Poor row estimates from planner, stat `most_common_elems` sometimes missing for a text[] column
2025-09-08 23:37 UTC Tom Lane <[email protected]>
` Re: Poor row estimates from planner, stat `most_common_elems` sometimes missing for a text[] column
2025-09-09 19:19 UTC Tom Lane <[email protected]>
` Re: Poor row estimates from planner, stat `most_common_elems` sometimes missing for a text[] column
2025-09-19 18:26 UTC Matt Long <[email protected]>
` Re: Poor row estimates from planner, stat `most_common_elems` sometimes missing for a text[] column
2025-09-19 19:23 UTC Tom Lane <[email protected]>
[5+ messages in thread]
Why isn't PG using an index-only scan?
2025-09-18 06:36 UTC Jean-Christophe BOGGIO <[email protected]>
` Re: Why isn't PG using an index-only scan?
2025-09-18 07:20 UTC David Rowley <[email protected]>
` Re: Why isn't PG using an index-only scan?
2025-09-18 07:45 UTC Jean-Christophe BOGGIO <[email protected]>
` Re: Why isn't PG using an index-only scan?
2025-09-18 07:55 UTC Andrei Lepikhov <[email protected]>
` Re: Why isn't PG using an index-only scan?
2025-09-18 11:32 UTC David Rowley <[email protected]>
` Re: Why isn't PG using an index-only scan?
2025-09-18 11:35 UTC David Rowley <[email protected]>
` Re: Why isn't PG using an index-only scan?
2025-09-18 11:55 UTC Andrei Lepikhov <[email protected]>
` Re: Why isn't PG using an index-only scan?
2025-09-19 01:05 UTC David Rowley <[email protected]>
` Re: Why isn't PG using an index-only scan?
2025-09-19 07:50 UTC Andrei Lepikhov <[email protected]>
[9+ messages in thread]
Planner makes sub-optimal execution plan
2025-09-01 09:07 UTC Алексей Борщёв <[email protected]>
` Re: Planner makes sub-optimal execution plan
2025-09-01 12:41 UTC Alena Rybakina <[email protected]>
` Re: Planner makes sub-optimal execution plan
2025-09-02 04:41 UTC David Rowley <[email protected]>
[3+ messages in thread]
Re: Any way to get nested loop index joins on CTEs?
2025-08-29 16:38 UTC Renan Alves Fonseca <[email protected]>
[next (older)]
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox