agora inbox for pgsql-performance@postgresql.org
help / color / mirror / Atom feedsmall database huge planning time
2026-01-13 09:16 UTC Alexander Kulikov <a-kulikov@hotmail.com>
` Re: small database huge planning time
2026-01-13 09:29 UTC Andrei Lepikhov <lepihov@gmail.com>
` Re: small database huge planning time
2026-01-13 14:44 UTC Greg Sabino Mullane <htamfids@gmail.com>
` Re: small database huge planning time
2026-01-13 16:07 UTC Huanbing Lu <luhuanbing@outlook.com>
` Re: small database huge planning time
2026-01-24 22:12 UTC Andrei Lepikhov <lepihov@gmail.com>
[5+ messages in thread]
Slow queries on simple index
2026-01-17 13:58 UTC Lillian Berry <lillian@star-ark.net>
` Re: Slow queries on simple index
2026-01-17 14:59 UTC Pavel Stehule <pavel.stehule@gmail.com>
` Re: Slow queries on simple index
2026-01-17 15:28 UTC Ken Marshall <ktm@rice.edu>
` Re: Slow queries on simple index
2026-01-17 16:57 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Slow queries on simple index
2026-01-17 19:33 UTC Lillian Berry <lillian@star-ark.net>
` Re: Slow queries on simple index
2026-01-17 20:21 UTC Andrei Lepikhov <lepihov@gmail.com>
` Re: Slow queries on simple index
2026-01-17 20:52 UTC Lillian Berry <lillian@star-ark.net>
` Re: Slow queries on simple index
2026-01-17 21:10 UTC Tom Lane <tgl@sss.pgh.pa.us>
` [Solved] Slow queries on simple index
2026-01-17 22:06 UTC Lillian Berry <lillian@star-ark.net>
` Re: Slow queries on simple index
2026-01-18 09:24 UTC Andrei Lepikhov <lepihov@gmail.com>
[10+ messages in thread]
Troubleshooting a brief spike in active sessions
2026-01-09 21:41 UTC Dirschel, Steve-CW <Steve.Dirschel@bestbuy.com>
` Re: Troubleshooting a brief spike in active sessions
2026-01-09 21:58 UTC Joshua Banton <bantonj@gmail.com>
` Re: Troubleshooting a brief spike in active sessions
2026-01-09 22:27 UTC Nikolay Samokhvalov <nik@postgres.ai>
` Re: Troubleshooting a brief spike in active sessions
2026-01-09 22:29 UTC Nikolay Samokhvalov <nik@postgres.ai>
[4+ messages in thread]
Another unexpected planner choice in simple JOIN
2026-01-09 00:12 UTC Mark Kirkwood <mark.kirkwood@gmail.com>
` Re: Another unexpected planner choice in simple JOIN
2026-01-09 01:15 UTC Mark Kirkwood <mark.kirkwood@gmail.com>
[2+ messages in thread]
Unexpected planner choice in simple JOIN
2026-01-08 01:35 UTC Mark Kirkwood <mark.kirkwood@gmail.com>
` Re: Unexpected planner choice in simple JOIN
2026-01-08 03:34 UTC Mark Kirkwood <mark.kirkwood@gmail.com>
` Re: Unexpected planner choice in simple JOIN
2026-01-08 03:56 UTC David Rowley <dgrowleyml@gmail.com>
` Re: Unexpected planner choice in simple JOIN
2026-01-08 04:03 UTC Mark Kirkwood <mark.kirkwood@gmail.com>
` Re: Unexpected planner choice in simple JOIN
2026-01-08 04:14 UTC David Rowley <dgrowleyml@gmail.com>
` Re: Unexpected planner choice in simple JOIN
2026-01-08 04:24 UTC Mark Kirkwood <mark.kirkwood@gmail.com>
` Re: Unexpected planner choice in simple JOIN
2026-01-08 04:34 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Unexpected planner choice in simple JOIN
2026-01-08 04:44 UTC Mark Kirkwood <mark.kirkwood@gmail.com>
` Re: Unexpected planner choice in simple JOIN
2026-01-08 04:51 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Unexpected planner choice in simple JOIN
2026-01-08 04:55 UTC Mark Kirkwood <mark.kirkwood@gmail.com>
[10+ messages in thread]
Surprising optimizer behavior with a subquery, a GROUP BY, and a range filter
2026-01-02 20:26 UTC wotq <wotq@wotq.dev>
` Re: Surprising optimizer behavior with a subquery, a GROUP BY, and a range filter
2026-01-02 20:46 UTC Tom Lane <tgl@sss.pgh.pa.us>
[2+ messages in thread]
Seeking guidance on extremely slow pg_restore despite strong I/O performance
2025-12-05 10:30 UTC MentionTheElephant <MentionTheElephant@gmail.com>
` Re: Seeking guidance on extremely slow pg_restore despite strong I/O performance
2025-12-05 20:27 UTC pg254kl@georgiou.vip
` Re: Seeking guidance on extremely slow pg_restore despite strong I/O performance
2025-12-08 00:53 UTC Jeff Janes <jeff.janes@gmail.com>
[3+ messages in thread]
Client-server communication for FETCH
2025-12-03 18:02 UTC Tim Fors <tim4stheenchanter@gmail.com>
` Re: Client-server communication for FETCH
2025-12-03 18:41 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Client-server communication for FETCH
2025-12-03 19:45 UTC Tim Fors <tim4stheenchanter@gmail.com>
` Re: Client-server communication for FETCH
2025-12-05 09:08 UTC Jan Claeys <lists@janc.be>
[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 <vv.lists@wanadoo.fr>
` Re: Why is my query 3 times faster on my workstation than on my server?
2025-12-04 18:53 UTC Pavel Stehule <pavel.stehule@gmail.com>
` Re: Why is my query 3 times faster on my workstation than on my server?
2025-12-04 19:06 UTC Tom Lane <tgl@sss.pgh.pa.us>
` RE: Why is my query 3 times faster on my workstation than on my server?
2025-12-04 19:51 UTC Clay Jackson (cjackson) <Clay.Jackson@quest.com>
` Re: Why is my query 3 times faster on my workstation than on my server?
2025-12-04 22:56 UTC Vincent Veyron <vv.lists@wanadoo.fr>
[5+ messages in thread]
Multicolumn index scan efficiency
2025-11-10 02:44 UTC Vitalii Tymchyshyn <vit@tym.im>
` Re: Multicolumn index scan efficiency
2025-11-10 04:20 UTC Peter Geoghegan <pg@bowt.ie>
` Re: Multicolumn index scan efficiency
2025-11-10 05:12 UTC Vitalii Tymchyshyn <vit@tym.im>
` Re: Multicolumn index scan efficiency
2025-11-10 17:00 UTC Peter Geoghegan <pg@bowt.ie>
[4+ messages in thread]
Index Searches higher than expected for skip scan
2025-11-06 19:00 UTC Michael Christofides <michael@pgmustard.com>
` Re: Index Searches higher than expected for skip scan
2025-11-06 19:54 UTC Peter Geoghegan <pg@bowt.ie>
` Re: Index Searches higher than expected for skip scan
2025-11-06 20:39 UTC Peter Geoghegan <pg@bowt.ie>
` Re: Index Searches higher than expected for skip scan
2025-11-07 11:16 UTC Michael Christofides <michael@pgmustard.com>
` Re: Index Searches higher than expected for skip scan
2025-11-07 15:00 UTC Peter Geoghegan <pg@bowt.ie>
[5+ messages in thread]
Problem getting query to use index inside a function
2025-11-05 16:02 UTC Dirschel, Steve <steve.dirschel@thomsonreuters.com>
` Re: Problem getting query to use index inside a function
2025-11-05 16:18 UTC Tom Lane <tgl@sss.pgh.pa.us>
` RE: [EXT] Re: Problem getting query to use index inside a function
2025-11-05 16:55 UTC Dirschel, Steve <steve.dirschel@thomsonreuters.com>
` Re: [EXT] Re: Problem getting query to use index inside a function
2025-11-05 19:17 UTC Tom Lane <tgl@sss.pgh.pa.us>
` RE: [EXT] Re: Problem getting query to use index inside a function
2025-11-05 20:18 UTC Dirschel, Steve <steve.dirschel@thomsonreuters.com>
[5+ messages in thread]
trgm and index-usage when using similarity function
2025-11-05 08:18 UTC Andreas Joseph Krogh <andreas@visena.com>
GEQO plans much slower than standard join plans
2025-10-27 18:17 UTC Carlo Sganzerla <carlo@alude.com.br>
` Re: GEQO plans much slower than standard join plans
2025-10-28 01:24 UTC Tomas Vondra <tomas@vondra.me>
` Re: GEQO plans much slower than standard join plans
2025-10-28 15:43 UTC Carlo Sganzerla <carlo@alude.com.br>
` Re: GEQO plans much slower than standard join plans
2025-10-29 02:05 UTC Tomas Vondra <tomas@vondra.me>
` Re: GEQO plans much slower than standard join plans
2025-10-29 14:57 UTC Carlo Sganzerla <carlo@alude.com.br>
` Re: GEQO plans much slower than standard join plans
2025-10-31 01:19 UTC David Rowley <dgrowleyml@gmail.com>
[6+ messages in thread]
Performance implications of partitioning by UUIDv7 range in PostgreSQL v18
2025-10-22 03:37 UTC Jonathan Reis <jon.reis@conevity.com>
` Re: Performance implications of partitioning by UUIDv7 range in PostgreSQL v18
2025-10-22 19:55 UTC David Rowley <dgrowleyml@gmail.com>
` Re: Performance implications of partitioning by UUIDv7 range in PostgreSQL v18
2025-10-22 21:05 UTC Olof Salberger <olof.salberger@gmail.com>
` Re: Performance implications of partitioning by UUIDv7 range in PostgreSQL v18
2025-10-23 16:51 UTC Greg Sabino Mullane <htamfids@gmail.com>
` Re: Performance implications of partitioning by UUIDv7 range in PostgreSQL v18
2025-10-23 20:11 UTC Jonathan Reis <jon.reis@conevity.com>
` Re: Performance implications of partitioning by UUIDv7 range in PostgreSQL v18
2025-10-23 20:38 UTC Laurenz Albe <laurenz.albe@cybertec.at>
` Re: Performance implications of partitioning by UUIDv7 range in PostgreSQL v18
2025-10-23 22:54 UTC David Rowley <dgrowleyml@gmail.com>
` Re: Performance implications of partitioning by UUIDv7 range in PostgreSQL v18
2025-10-24 02:14 UTC Jonathan Reis <jon.reis@conevity.com>
` Re: Performance implications of partitioning by UUIDv7 range in PostgreSQL v18
2025-10-24 05:04 UTC Laurenz Albe <laurenz.albe@cybertec.at>
` Re: Performance implications of partitioning by UUIDv7 range in PostgreSQL v18
2025-10-24 12:38 UTC Greg Sabino Mullane <htamfids@gmail.com>
` Re: Performance implications of partitioning by UUIDv7 range in PostgreSQL v18
2025-10-24 15:24 UTC Jonathan Reis <jon.reis@conevity.com>
[11+ messages in thread]
Indexes on expressions with multiple columns and operators
2025-09-17 13:55 UTC Frédéric Yhuel <frederic.yhuel@dalibo.com>
` Re: Indexes on expressions with multiple columns and operators
2025-09-17 14:22 UTC Laurenz Albe <laurenz.albe@cybertec.at>
` Re: Indexes on expressions with multiple columns and operators
2025-09-17 14:41 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Indexes on expressions with multiple columns and operators
2025-09-17 14:57 UTC Frédéric Yhuel <frederic.yhuel@dalibo.com>
` Re: Indexes on expressions with multiple columns and operators
2025-09-17 15:33 UTC Frédéric Yhuel <frederic.yhuel@dalibo.com>
` Re: Indexes on expressions with multiple columns and operators
2025-09-18 15:26 UTC Jehan-Guillaume de Rorthais <jgdr@dalibo.com>
` Re: Indexes on expressions with multiple columns and operators
2025-09-18 15:32 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Indexes on expressions with multiple columns and operators
2025-09-18 16:40 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Indexes on expressions with multiple columns and operators
2025-09-18 16:48 UTC Ranier Vilela <ranier.vf@gmail.com>
` Re: Indexes on expressions with multiple columns and operators
2025-09-18 16:59 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Indexes on expressions with multiple columns and operators
2025-09-19 07:50 UTC Frédéric Yhuel <frederic.yhuel@dalibo.com>
` Re: Indexes on expressions with multiple columns and operators
2025-09-19 14:37 UTC Jehan-Guillaume de Rorthais <jgdr@dalibo.com>
` Re: Indexes on expressions with multiple columns and operators
2025-09-20 16:51 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Indexes on expressions with multiple columns and operators
2025-09-22 13:37 UTC Frédéric Yhuel <frederic.yhuel@dalibo.com>
` Re: Indexes on expressions with multiple columns and operators
2025-09-22 13:57 UTC Andrei Lepikhov <lepihov@gmail.com>
` Re: Indexes on expressions with multiple columns and operators
2025-09-22 16:09 UTC Frédéric Yhuel <frederic.yhuel@dalibo.com>
` Re: Indexes on expressions with multiple columns and operators
2025-09-22 21:15 UTC Andrei Lepikhov <lepihov@gmail.com>
` Re: Indexes on expressions with multiple columns and operators
2025-09-23 10:20 UTC Frédéric Yhuel <frederic.yhuel@dalibo.com>
` Re: Indexes on expressions with multiple columns and operators
2025-09-23 10:43 UTC Andrei Lepikhov <lepihov@gmail.com>
` Re: Indexes on expressions with multiple columns and operators
2025-09-23 13:31 UTC Frédéric Yhuel <frederic.yhuel@dalibo.com>
` Re: Indexes on expressions with multiple columns and operators
2025-09-25 10:41 UTC Frédéric Yhuel <frederic.yhuel@dalibo.com>
` Re: Indexes on expressions with multiple columns and operators
2025-09-25 10:43 UTC Frédéric Yhuel <frederic.yhuel@dalibo.com>
` Re: Indexes on expressions with multiple columns and operators
2025-10-13 13:56 UTC Andrei Lepikhov <lepihov@gmail.com>
` Re: Indexes on expressions with multiple columns and operators
2025-10-13 14:00 UTC Andrei Lepikhov <lepihov@gmail.com>
` Re: Indexes on expressions with multiple columns and operators
2025-10-13 14:55 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Indexes on expressions with multiple columns and operators
2025-10-14 09:29 UTC Andrei Lepikhov <lepihov@gmail.com>
[26+ messages in thread]
Poor performance with row wise comparisons
2025-02-06 21:13 UTC Jon Emord <jon@peregrine.io>
` Re: Poor performance with row wise comparisons
2025-02-07 14:43 UTC Greg Sabino Mullane <htamfids@gmail.com>
` Re: Poor performance with row wise comparisons
2025-02-07 16:16 UTC Jon Emord <jon@peregrine.io>
` Re: Poor performance with row wise comparisons
2025-02-09 22:40 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Poor performance with row wise comparisons
2025-02-10 12:36 UTC Laurenz Albe <laurenz.albe@cybertec.at>
` Re: Poor performance with row wise comparisons
2025-10-09 21:53 UTC Peter Geoghegan <pg@bowt.ie>
` Re: Poor performance with row wise comparisons
2025-10-10 04:21 UTC lokesh@empays.com
` Re: Poor performance with row wise comparisons
2025-10-11 23:03 UTC David G. Johnston <david.g.johnston@gmail.com>
[8+ messages in thread]
Question about nested loops..
2025-10-09 08:52 UTC Frits Jalvingh <jal@etc.to>
` Re: Question about nested loops..
2025-10-09 10:00 UTC Andrei Lepikhov <lepihov@gmail.com>
` Re: Question about nested loops..
2025-10-10 09:28 UTC Andrei Lepikhov <lepihov@gmail.com>
[3+ messages in thread]
Partition pruning is not happening (even in PG18)
2025-09-25 19:34 UTC Lauro Ojeda <lauro.ojeda@gmail.com>
` Re: Partition pruning is not happening (even in PG18)
2025-09-25 20:10 UTC Michał Kłeczek <michal@kleczek.org>
` Re: Partition pruning is not happening (even in PG18)
2025-09-25 20:13 UTC Michał Kłeczek <michal@kleczek.org>
` Re: Partition pruning is not happening (even in PG18)
2025-09-25 20:17 UTC David Rowley <dgrowleyml@gmail.com>
` Re: Partition pruning is not happening (even in PG18)
2025-09-29 13:49 UTC Lauro Ojeda <lauro.ojeda@gmail.com>
` Re: Partition pruning is not happening (even in PG18)
2025-09-29 20:05 UTC Chetan <chetansuttraway@gmail.com>
` Re: Partition pruning is not happening (even in PG18)
2025-09-29 20:08 UTC David Rowley <dgrowleyml@gmail.com>
[7+ messages in thread]
Very expensive update to update a single row
2025-09-23 19:40 UTC Dirschel, Steve <steve.dirschel@thomsonreuters.com>
` Re: Very expensive update to update a single row
2025-09-23 21:12 UTC Sean M <sean.f.massey@gmail.com>
[2+ messages in thread]
Poor row estimates from planner, stat `most_common_elems` sometimes missing for a text[] column
2025-06-05 15:42 UTC Mark Frost <FROSTMAR@uk.ibm.com>
` Re: Poor row estimates from planner, stat `most_common_elems` sometimes missing for a text[] column
2025-06-05 17:09 UTC Frédéric Yhuel <frederic.yhuel@dalibo.com>
` Re: Poor row estimates from planner, stat `most_common_elems` sometimes missing for a text[] column
2025-06-05 18:57 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Poor row estimates from planner, stat `most_common_elems` sometimes missing for a text[] column
2025-06-05 21:52 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Poor row estimates from planner, stat `most_common_elems` sometimes missing for a text[] column
2025-06-06 08:07 UTC Frédéric Yhuel <frederic.yhuel@dalibo.com>
` RE: Poor row estimates from planner, stat `most_common_elems` sometimes missing for a text[] column
2025-06-06 09:21 UTC Mark Frost <FROSTMAR@uk.ibm.com>
` Re: Poor row estimates from planner, stat `most_common_elems` sometimes missing for a text[] column
2025-06-07 01:29 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Poor row estimates from planner, stat `most_common_elems` sometimes missing for a text[] column
2025-07-18 21:54 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Poor row estimates from planner, stat `most_common_elems` sometimes missing for a text[] column
2025-09-08 19:13 UTC Matt Long <matt@mattlong.org>
` Re: Poor row estimates from planner, stat `most_common_elems` sometimes missing for a text[] column
2025-09-08 23:37 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Poor row estimates from planner, stat `most_common_elems` sometimes missing for a text[] column
2025-09-09 19:19 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Poor row estimates from planner, stat `most_common_elems` sometimes missing for a text[] column
2025-09-19 18:26 UTC Matt Long <matt@mattlong.org>
` Re: Poor row estimates from planner, stat `most_common_elems` sometimes missing for a text[] column
2025-09-19 19:23 UTC Tom Lane <tgl@sss.pgh.pa.us>
[13+ messages in thread]
Why isn't PG using an index-only scan?
2025-09-18 06:36 UTC Jean-Christophe BOGGIO <postgresql@thefreecat.org>
` Re: Why isn't PG using an index-only scan?
2025-09-18 07:20 UTC David Rowley <dgrowleyml@gmail.com>
` Re: Why isn't PG using an index-only scan?
2025-09-18 07:45 UTC Jean-Christophe BOGGIO <postgresql@thefreecat.org>
` Re: Why isn't PG using an index-only scan?
2025-09-18 07:55 UTC Andrei Lepikhov <lepihov@gmail.com>
` Re: Why isn't PG using an index-only scan?
2025-09-18 11:32 UTC David Rowley <dgrowleyml@gmail.com>
` Re: Why isn't PG using an index-only scan?
2025-09-18 11:35 UTC David Rowley <dgrowleyml@gmail.com>
` Re: Why isn't PG using an index-only scan?
2025-09-18 11:55 UTC Andrei Lepikhov <lepihov@gmail.com>
` Re: Why isn't PG using an index-only scan?
2025-09-19 01:05 UTC David Rowley <dgrowleyml@gmail.com>
` Re: Why isn't PG using an index-only scan?
2025-09-19 07:50 UTC Andrei Lepikhov <lepihov@gmail.com>
[9+ messages in thread]
Planner makes sub-optimal execution plan
2025-09-01 09:07 UTC Алексей Борщёв <aborschev@gmail.com>
` Re: Planner makes sub-optimal execution plan
2025-09-01 12:41 UTC Alena Rybakina <a.rybakina@postgrespro.ru>
` Re: Planner makes sub-optimal execution plan
2025-09-02 04:41 UTC David Rowley <dgrowleyml@gmail.com>
[3+ messages in thread]
Any way to get nested loop index joins on CTEs?
2025-07-15 13:29 UTC Clemens Eisserer <linuxhippy@gmail.com>
` Re: Any way to get nested loop index joins on CTEs?
2025-07-16 11:24 UTC Jean-Christophe BOGGIO <postgresql@thefreecat.org>
` Re: Any way to get nested loop index joins on CTEs?
2025-08-29 16:38 UTC Renan Alves Fonseca <renanfonseca@gmail.com>
[3+ messages in thread]
Keeping some tables in cache
2025-08-26 08:21 UTC Ertan Küçükoglu <ertan.kucukoglu@gmail.com>
` Re: Keeping some tables in cache
2025-08-26 09:04 UTC Achilleas Mantzios <a.mantzios@cloud.gatewaynet.com>
` Re: Keeping some tables in cache
2025-08-26 12:21 UTC Laurenz Albe <laurenz.albe@cybertec.at>
[3+ messages in thread]
[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