Mailing lists [pgsql-performance]
- Re: shared_buffers on ubuntu precise Daniel Farina
- Re: shared_buffers on ubuntu precise Mark Kirkwood
- Re: Optimize update query Mark Kirkwood
- Re: Optimize update query Vitalii Tymchyshyn
- Re: Optimize update query Mark Kirkwood
- Re: Optimize update query Niels Kristian Schjødt
- Re: Hints (was Poor performance using CTE) Gavin Flower
- Slow query: bitmap scan troubles
- Re: Slow query: bitmap scan troubles
- Re: Slow query: bitmap scan troubles Claudio Freire
- Re: Comparative tps question John Lister
- Re: Slow query: bitmap scan troubles Jeff Janes
- Re: Slow query: bitmap scan troubles Claudio Freire
- Re: Slow query: bitmap scan troubles
- Re: Slow query: bitmap scan troubles
- Re: Slow query: bitmap scan troubles Claudio Freire
- Re: Slow query: bitmap scan troubles Claudio Freire
- Re: Slow query: bitmap scan troubles Vitalii Tymchyshyn
- Re: Slow query: bitmap scan troubles
- Re: Slow query: bitmap scan troubles
- Re: Slow query: bitmap scan troubles Kevin Grittner
- Re: Slow query: bitmap scan troubles Sergey Konoplev
- Re: Slow query: bitmap scan troubles Jeff Janes
- Re: Slow query: bitmap scan troubles Jeff Janes
- CREATING INDEX on column having null values suhas.basavaraj12
- Re: CREATING INDEX on column having null values Willem Leenen
- xfs perform a lot better than ext4 [WAS: Re: Two identical systems, radically different performance] Andrea Suisani
- Re: xfs perform a lot better than ext4 [WAS: Re: Two identical systems, radically different performance] Jean-David Beyer
- Re: xfs perform a lot better than ext4 [WAS: Re: Two identical systems, radically different performance] Claudio Freire
- Re: xfs perform a lot better than ext4 [WAS: Re: Two identical systems, radically different performance] Andrew Dunstan
- Re: Slow query: bitmap scan troubles Jeff Janes
- Re: Slow query: bitmap scan troubles Claudio Freire
- Re: Slow query: bitmap scan troubles Tom Lane
- Ubuntu 12.04 / 3.2 Kernel Bad for PostgreSQL Performance Shaun Thomas
- Any idea on how to improve the statistics estimates for this plan? Guillaume Smet
- Re: Ubuntu 12.04 / 3.2 Kernel Bad for PostgreSQL Performance Niels Kristian Schjødt
- Re: Ubuntu 12.04 / 3.2 Kernel Bad for PostgreSQL Performance Daniel Farina
- Re: Ubuntu 12.04 / 3.2 Kernel Bad for PostgreSQL Performance Shaun Thomas
- Re: Ubuntu 12.04 / 3.2 Kernel Bad for PostgreSQL Performance Bruce Momjian
- Re: Ubuntu 12.04 / 3.2 Kernel Bad for PostgreSQL Performance Shaun Thomas
- Re: Ubuntu 12.04 / 3.2 Kernel Bad for PostgreSQL Performance Scott Marlowe
- Re: Ubuntu 12.04 / 3.2 Kernel Bad for PostgreSQL Performance Stuart Bishop
- Re: xfs perform a lot better than ext4 [WAS: Re: Two identical systems, radically different performance] John Lister
- Re: Ubuntu 12.04 / 3.2 Kernel Bad for PostgreSQL Performance John Lister
- Re: xfs perform a lot better than ext4 [WAS: Re: Two identical systems, radically different performance] Andrea Suisani
- Re: xfs perform a lot better than ext4 [WAS: Re: Two identical systems, radically different performance] Andrea Suisani
- Re: xfs perform a lot better than ext4 [WAS: Re: Two identical systems, radically different performance] John Lister
- Re: Slow query: bitmap scan troubles
- Re: Re: xfs perform a lot better than ext4 [WAS: Re: Two identical systems, radically different performance] Andrea Suisani
- Re: Slow query: bitmap scan troubles
- Re: Slow query: bitmap scan troubles
- Re: Slow query: bitmap scan troubles Jeff Janes
- Re: Slow query: bitmap scan troubles Claudio Freire
- Re: Slow query: bitmap scan troubles Jeff Janes
- Re: Any idea on how to improve the statistics estimates for this plan? Jeff Janes
- Re: Any idea on how to improve the statistics estimates for this plan? Tom Lane
- Re: Any idea on how to improve the statistics estimates for this plan? Guillaume Smet
- Re: Slow query: bitmap scan troubles Guillaume Lelarge
- Re: Any idea on how to improve the statistics estimates for this plan? Jeff Janes
- Re: Slow query: bitmap scan troubles Philip Scott
- Re: Slow query: bitmap scan troubles Philip Scott
- Re: Slow query: bitmap scan troubles Philip Scott
- Why is PostgreSQL 9.2 slower than 9.1 in my tests? Patryk Sidzina
- Perform scan on Toast table classical_89
- Re: Why is PostgreSQL 9.2 slower than 9.1 in my tests? Jeff Janes
- Re: Perform scan on Toast table Albe Laurenz
- Re: Slow query: bitmap scan troubles
- Do I have a hardware or a software problem? Niels Kristian Schjødt
- Re: Do I have a hardware or a software problem? Evgeny Shishkin
- Re: Do I have a hardware or a software problem? Jeff Janes
- Re: Do I have a hardware or a software problem? Niels Kristian Schjødt
- Re: Do I have a hardware or a software problem? Craig Ringer
- Re: Do I have a hardware or a software problem? Niels Kristian Schjødt
- Re: Do I have a hardware or a software problem? Evgeny Shishkin
- Re: Do I have a hardware or a software problem? Jeff Janes
- Re: Do I have a hardware or a software problem? Niels Kristian Schjødt
- Re: Do I have a hardware or a software problem? Evgeny Shishkin
- Occasional timeouts on TRUNCATE and simple INSERTs Osborn, Jeff
- Re: Occasional timeouts on TRUNCATE and simple INSERTs Sergey Konoplev
- Re: Occasional timeouts on TRUNCATE and simple INSERTs Merlin Moncure
- Re: Occasional timeouts on TRUNCATE and simple INSERTs Osborn, Jeff
- Re: Do I have a hardware or a software problem? Niels Kristian Schjødt
- Re: Do I have a hardware or a software problem? Evgeny Shishkin
- Re: Why is PostgreSQL 9.2 slower than 9.1 in my tests? Jeff Janes
- Re: Why is PostgreSQL 9.2 slower than 9.1 in my tests? Tom Lane
- Re: Do I have a hardware or a software problem? Craig Ringer
- Re: Do I have a hardware or a software problem? Evgeny Shishkin
- Re: Do I have a hardware or a software problem? Craig Ringer
- Re: Do I have a hardware or a software problem? Evgeny Shishkin
- Re: Do I have a hardware or a software problem? Rosser Schwarz
- Re: Do I have a hardware or a software problem? Craig Ringer
- Re: Do I have a hardware or a software problem? Evgeny Shishkin
- Re: Do I have a hardware or a software problem? David Boreham
- Re: Do I have a hardware or a software problem? Evgeny Shishkin
- Re: Do I have a hardware or a software problem? David Boreham
- Re: Do I have a hardware or a software problem? Evgeny Shishkin
- Re: Do I have a hardware or a software problem? David Boreham
- Re: Do I have a hardware or a software problem? Craig Ringer
- Re: Do I have a hardware or a software problem? Evgeny Shishkin
- Re: Do I have a hardware or a software problem? Mark Kirkwood
- Re: Do I have a hardware or a software problem? David Boreham
- Re: Do I have a hardware or a software problem? Evgeny Shishkin
- Re: Do I have a hardware or a software problem? David Boreham
- hash join vs nested loop join Huan Ruan
- Re: hash join vs nested loop join Evgeny Shishkin
- Re: hash join vs nested loop join Evgeny Shishkin
- Re: Do I have a hardware or a software problem? Niels Kristian Schjødt
- Read rows deleted Alejandro Carrillo
- Re: hash join vs nested loop join Jeff Janes
- Re: Do I have a hardware or a software problem? Niels Kristian Schjødt
- Re: Savepoints in transactions for speed? Jeff Janes
- track_activity_query_size Andrew Dunstan
- Re: Read rows deleted Sergey Konoplev
- Re: Read rows deleted Alejandro Carrillo
- Re: Read rows deleted Andrew Dunstan
- encouraging index-only scans Andrew Dunstan
- Re: encouraging index-only scans Andrew Dunstan
- Re: encouraging index-only scans Andrew Dunstan
- Re: Do I have a hardware or a software problem? Craig Ringer
- Re: hash join vs nested loop join Kevin Grittner
- Limit & offset effect on query plans Amitabh Kant
- Re: Limit & offset effect on query plans Pavan Deolasee
- Memory issue for inheritance tables. Hari Babu
- Re: Do I have a hardware or a software problem? Jeff Janes
- Re: hash join vs nested loop join Kevin Grittner
- problem with large inserts Lutz Fischer
- Re: Limit & offset effect on query plans Kevin Grittner
- Re: problem with large inserts Willem Leenen
- Re: problem with large inserts Filip Rembiałkowski
- Re: problem with large inserts Tom Lane
- Re: Limit & offset effect on query plans Tom Lane
- Re: problem with large inserts Lutz Fischer
- Re: problem with large inserts Filip Rembiałkowski
- Re: Limit & offset effect on query plans Kevin Grittner
- Re: Limit & offset effect on query plans Tom Lane
- Re: Limit & offset effect on query plans Kevin Grittner
- How do I track stats on foreign table access through foreign data wrapper? David Crawford
- Re: Why is PostgreSQL 9.2 slower than 9.1 in my tests? Patryk Sidzina
- Re: encouraging index-only scans Tom Lane
- Re: hash join vs nested loop join Huan Ruan
- Re: hash join vs nested loop join Huan Ruan
- Slow queries after vacuum analyze Ghislain ROUVIGNAC
- Re: Slow queries after vacuum analyze Kevin Grittner
- Re: Occasional timeouts on TRUNCATE and simple INSERTs Osborn, Jeff
- Why does the number of rows are different in actual and estimated. AI Rumman
- Re: Why does the number of rows are different in actual and estimated. Andrew Dunstan
- Re: Why does the number of rows are different in actual and estimated. Evgeny Shishkin
- Re: Why does the number of rows are different in actual and estimated. Claudio Freire
- Re: Why does the number of rows are different in actual and estimated. Andrew Dunstan
- Re: Why does the number of rows are different in actual and estimated. Evgeny Shishkin
- Re: Why does the number of rows are different in actual and estimated. Tom Lane
- Re: Why does the number of rows are different in actual and estimated. Evgeny Shishkin
- Re: hash join vs nested loop join Huan Ruan
- Re: Why does the number of rows are different in actual and estimated. Claudio Freire
- Re: hash join vs nested loop join Kevin Grittner
- Re: hash join vs nested loop join Huan Ruan
- Re: hash join vs nested loop join Kevin Grittner
- backend suddenly becomes slow, then remains slow Andrew Dunstan
- Re: Why does the number of rows are different in actual and estimated. AI Rumman
- Re: Why does the number of rows are different in actual and estimated. Claudio Freire
- Re: Why does the number of rows are different in actual and estimated. Kevin Grittner
- Re: Why does the number of rows are different in actual and estimated. Tom Lane
- Re: Why does the number of rows are different in actual and estimated. AI Rumman
- Re: backend suddenly becomes slow, then remains slow Tom Lane
- Re: Why does the number of rows are different in actual and estimated. Claudio Freire
- Re: backend suddenly becomes slow, then remains slow Andrew Dunstan
- Re: Why does the number of rows are different in actual and estimated. AI Rumman
- Re: Why does the number of rows are different in actual and estimated. Claudio Freire
- Re: Why does the number of rows are different in actual and estimated. Kevin Grittner
- Re: Why does the number of rows are different in actual and estimated. AI Rumman
- Re: Why does the number of rows are different in actual and estimated. Kevin Grittner
- Re: Do I have a hardware or a software problem? Scott Marlowe
- Re: How can i find out top high load sql queries in PostgreSQL. suhas.basavaraj12
- Re: How can i find out top high load sql queries in PostgreSQL. Vibhor Kumar
- Re: Slow queries after vacuum analyze Kevin Grittner
- Re: hash join vs nested loop join Huan Ruan
- Re: hash join vs nested loop join Kevin Grittner
- Re: How can i find out top high load sql queries in PostgreSQL. Igor Neyman
- PG 9.1 performance loss due to query plan being changed depending on db data (4s vs 200ms) Rodrigo Rosenfeld Rosas
- Why does the query planner use two full indexes, when a dedicated partial index exists? Richard Neill
- Re: Why does the query planner use two full indexes, when a dedicated partial index exists? Sergey Konoplev
- Re: Why does the query planner use two full indexes, when a dedicated partial index exists? Richard Neill
- Re: Why does the query planner use two full indexes, when a dedicated partial index exists? Sergey Konoplev
- Re: Why does the query planner use two full indexes, when a dedicated partial index exists? Richard Neill
- Re: hash join vs nested loop join Huan Ruan
- Re: Why does the query planner use two full indexes, when a dedicated partial index exists? Tom Lane
- Re: Why does the query planner use two full indexes, when a dedicated partial index exists? Jeff Janes
- Re: Why does the query planner use two full indexes, when a dedicated partial index exists? Richard Neill
- Re: Why does the query planner use two full indexes, when a dedicated partial index exists? Richard Neill
- Re: hash join vs nested loop join Kevin Grittner
- Re: Why does the query planner use two full indexes, when a dedicated partial index exists? Tom Lane
- Re: Why does the query planner use two full indexes, when a dedicated partial index exists? Tom Lane
- Performance on Bulk Insert to Partitioned Table Charles Gomes
- Re: Performance on Bulk Insert to Partitioned Table Scott Marlowe
- Re: Performance on Bulk Insert to Partitioned Table Charles Gomes
- Re: Performance on Bulk Insert to Partitioned Table Stephen Frost
- Re: Performance on Bulk Insert to Partitioned Table Charles Gomes
- Re: hash join vs nested loop join Huan Ruan
- Re: Performance on Bulk Insert to Partitioned Table Jeff Janes
- Re: Performance on Bulk Insert to Partitioned Table Charles Gomes
- Re: Performance on Bulk Insert to Partitioned Table Ondrej Ivanič
- Re: Performance on Bulk Insert to Partitioned Table Charles Gomes
- Re: Performance on Bulk Insert to Partitioned Table Charles Gomes
- Re: Performance on Bulk Insert to Partitioned Table Tom Lane
- Re: Performance on Bulk Insert to Partitioned Table Scott Marlowe
- Re: Why does the query planner use two full indexes, when a dedicated partial index exists? Richard Neill
- Re: Why does the query planner use two full indexes, when a dedicated partial index exists? Richard Neill
- Re: Performance on Bulk Insert to Partitioned Table Jeff Janes
- Re: Why does the query planner use two full indexes, when a dedicated partial index exists? Jeff Janes
- Re: Why does the query planner use two full indexes, when a dedicated partial index exists? Jeff Janes
- Re: Why does the query planner use two full indexes, when a dedicated partial index exists? Jeff Janes
- Re: Performance on Bulk Insert to Partitioned Table Charles Gomes
- Re: Performance on Bulk Insert to Partitioned Table Charles Gomes
- Re: Slow queries after vacuum analyze Kevin Grittner
- Re: Why does the query planner use two full indexes, when a dedicated partial index exists? Richard Neill
- Re: Why does the query planner use two full indexes, when a dedicated partial index exists? Richard Neill
- Re: Performance on Bulk Insert to Partitioned Table Jeff Janes
- Re: Performance on Bulk Insert to Partitioned Table Jeff Janes
- Re: Why is PostgreSQL 9.2 slower than 9.1 in my tests? Jeff Janes
- Re: Performance on Bulk Insert to Partitioned Table Charles Gomes
- Re: Performance on Bulk Insert to Partitioned Table Charles Gomes
- Re: Performance on Bulk Insert to Partitioned Table Evgeny Shishkin
- Re: Performance on Bulk Insert to Partitioned Table Charles Gomes
- Re: Why does the query planner use two full indexes, when a dedicated partial index exists? (solved?) Richard Neill
- Re: Performance on Bulk Insert to Partitioned Table Charles Gomes
- Re: Why does the query planner use two full indexes, when a dedicated partial index exists? (solved?) John Rouillard
- Re: Why does the query planner use two full indexes, when a dedicated partial index exists? Jeff Janes
- Re: Performance on Bulk Insert to Partitioned Table Jeff Janes
- Re: Why does the query planner use two full indexes, when a dedicated partial index exists? (solved?) Jeff Janes
- backend suddenly becomes slow, then remains slow Jeff Janes
- Re: Why does the query planner use two full indexes, when a dedicated partial index exists? (solved?) Jeff Janes
- Re: Performance on Bulk Insert to Partitioned Table Pavel Stehule
- Re: Why does the query planner use two full indexes, when a dedicated partial index exists? Richard Neill
- Improve performance for writing Markus Innerebner
- Re: Improve performance for writing Charles Gomes
- Re: Performance on Bulk Insert to Partitioned Table Charles Gomes
- Why does the query planner use two full indexes, when a dedicated partial index exists? Jeff Janes
- Re: Why does the query planner use two full indexes, when a dedicated partial index exists? Richard Neill
- Re: Why does the query planner use two full indexes, when a dedicated partial index exists? Tom Lane
- explain analyze reports that my queries are fast but they run very slowly Nikolas Everett
- Re: explain analyze reports that my queries are fast but they run very slowly François Beausoleil
- Re: explain analyze reports that my queries are fast but they run very slowly Richard Neill
- Re: backend suddenly becomes slow, then remains slow Andrew Dunstan
- Re: explain analyze reports that my queries are fast but they run very slowly Nikolas Everett
- Re: explain analyze reports that my queries are fast but they run very slowly Nikolas Everett
- Re: explain analyze reports that my queries are fast but they run very slowly Nikolas Everett
- Re: Why does the query planner use two full indexes, when a dedicated partial index exists? Jeff Janes
- Performance on Bulk Insert to Partitioned Table Jeff Janes
- Re: Performance on Bulk Insert to Partitioned Table Jeff Janes
- Re: Performance on Bulk Insert to Partitioned Table Pavel Stehule
- Re: Performance on Bulk Insert to Partitioned Table Charles Gomes
- Re: Performance on Bulk Insert to Partitioned Table Stephen Frost
- Re: explain analyze reports that my queries are fast but they run very slowly Tom Lane
- Re: Performance on Bulk Insert to Partitioned Table Pavel Stehule
- Re: explain analyze reports that my queries are fast but they run very slowly Nikolas Everett
- Re: explain analyze reports that my queries are fast but they run very slowly Nikolas Everett
- Re: explain analyze reports that my queries are fast but they run very slowly Tom Lane
- Re: Performance on Bulk Insert to Partitioned Table Emmanuel Cecchet
- Re: Why does the query planner use two full indexes, when a dedicated partial index exists? Richard Neill
- Re: Slow queries after vacuum analyze Ghislain ROUVIGNAC
- sched_migration_cost for high-connection counts Shaun Thomas
- Re: explain analyze reports that my queries are fast but they run very slowly Tom Lane
- Re: explain analyze reports that my queries are fast but they run very slowly Nikolas Everett
- Re: explain analyze reports that my queries are fast but they run very slowly Tom Lane
- Re: explain analyze reports that my queries are fast but they run very slowly Nikolas Everett
- Re: backend suddenly becomes slow, then remains slow Jeff Janes
- Re: Why does the query planner use two full indexes, when a dedicated partial index exists? Jeff Janes
- Re: Performance on Bulk Insert to Partitioned Table Vitalii Tymchyshyn
- Re: Performance on Bulk Insert to Partitioned Table Vitalii Tymchyshyn
- Re: Performance on Bulk Insert to Partitioned Table Stephen Frost
- Re: Performance on Bulk Insert to Partitioned Table Pavel Stehule
- Re: Performance on Bulk Insert to Partitioned Table Vitalii Tymchyshyn
- Re: Performance on Bulk Insert to Partitioned Table Vitalii Tymchyshyn
- Re: Performance on Bulk Insert to Partitioned Table Pavel Stehule
- Re: Performance on Bulk Insert to Partitioned Table Jeff Janes
- Re: Performance on Bulk Insert to Partitioned Table Stephen Frost
- Re: Performance on Bulk Insert to Partitioned Table Stephen Frost
- Re: Performance on Bulk Insert to Partitioned Table Pavel Stehule
- Re: Performance on Bulk Insert to Partitioned Table Jeff Janes
- RES: Performance on Bulk Insert to Partitioned Table Luciano Ernesto da Silva
- Re: Performance on Bulk Insert to Partitioned Table Pavel Stehule
- serious under-estimation of n_distinct for clustered distributions Stefan Andreatta
- Re: serious under-estimation of n_distinct for clustered distributions Peter Geoghegan
- Re: serious under-estimation of n_distinct for clustered distributions Stefan Andreatta
- Re: serious under-estimation of n_distinct for clustered distributions Claudio Freire
- Slow connections on Win 7 John Kasarda
- Re: Slow connections on Win 7 Sam Gendler
- Re: High %SYS CPU usage Cesar Martin