Mailing lists [pgsql-performance]
- Re: Performance Problem with postgresql 9.03, 8GB RAM,Quadcore Processor Server--Need help!!!!!!! Mohamed Hashim
- Re: Performance Problem with postgresql 9.03, 8GB RAM,Quadcore Processor Server--Need help!!!!!!! Marcus Engene
- Re: Performance Problem with postgresql 9.03, 8GB RAM,Quadcore Processor Server--Need help!!!!!!! ktm@rice.edu
- Re: Performance Problem with postgresql 9.03, 8GB RAM,Quadcore Processor Server--Need help!!!!!!! Tomas Vondra
- Re: Performance Problem with postgresql 9.03, 8GB RAM,Quadcore Processor Server--Need help!!!!!!! Tom Lane
- procedure takes much more time than its query statement Sabin Coanda
- Re: procedure takes much more time than its query statement Dave Crooke
- Re: procedure takes much more time than its query statement Craig Ringer
- Re: Performance Problem with postgresql 9.03, 8GB RAM,Quadcore Processor Server--Need help!!!!!!! Mohamed Hashim
- Re: procedure takes much more time than its query statement Sabin Coanda
- Intel 710 pgbench write latencies Yeb Havinga
- Re: Intel 710 pgbench write latencies Kevin Grittner
- Guide to PG's capabilities for inlining, predicate hoisting, flattening, etc? Jay Levitt
- Re: Intel 710 pgbench write latencies Merlin Moncure
- Re: Performance Problem with postgresql 9.03, 8GB RAM,Quadcore Processor Server--Need help!!!!!!! Tom Lane
- Re: Guide to PG's capabilities for inlining, predicate hoisting, flattening, etc? Tom Lane
- Re: Intel 710 pgbench write latencies Yeb Havinga
- Re: Intel 710 pgbench write latencies Magnus Hagander
- Re: Guide to PG's capabilities for inlining, predicate hoisting, flattening, etc? Robert Haas
- Re: Intel 710 pgbench write latencies Yeb Havinga
- Re: Intel 710 pgbench write latencies David Boreham
- Re: Guide to PG's capabilities for inlining, predicate hoisting, flattening, etc? Andres Freund
- Re: Guide to PG's capabilities for inlining, predicate hoisting, flattening, etc? Claudio Freire
- Re: Intel 710 pgbench write latencies Merlin Moncure
- Re: Guide to PG's capabilities for inlining, predicate hoisting, flattening, etc? Craig James
- two table join just not fast enough. Brian Fehrle
- Poor performance on a simple join CS DBA
- Re: Guide to PG's capabilities for inlining, predicate hoisting, flattening, etc? Igor Neyman
- Re: Intel 710 pgbench write latencies Yeb Havinga
- Re: Poor performance on a simple join Scott Marlowe
- Re: Intel 710 pgbench write latencies Merlin Moncure
- Re: Poor performance on a simple join CS DBA
- Re: two table join just not fast enough. Tom Lane
- Re: two table join just not fast enough. Brian Fehrle
- Re: two table join just not fast enough. Mark Kirkwood
- Re: Poor performance on a simple join Scott Marlowe
- Re: Intel 710 pgbench write latencies Andy
- Re: Intel 710 pgbench write latencies Yeb Havinga
- Re: Guide to PG's capabilities for inlining, predicate hoisting, flattening, etc? Craig Ringer
- Re: Guide to PG's capabilities for inlining, predicate hoisting, flattening, etc? Igor Neyman
- Re: Intel 710 pgbench write latencies Merlin Moncure
- Re: Poor performance on a simple join Shaun Thomas
- Re: Intel 710 pgbench write latencies Shaun Thomas
- Re: Intel 710 pgbench write latencies Yeb Havinga
- Re: function slower than the same code in an sql file Robert Haas
- Re: SSL encryption makes bytea transfer slow Albe Laurenz
- Re: SSL encryption makes bytea transfer slow ktm@rice.edu
- Re: Performance Problem with postgresql 9.03, 8GB RAM,Quadcore Processor Server--Need help!!!!!!! Mario Weilguni
- Re: function slower than the same code in an sql file Rodrigo Gonzalez
- Re: Query running a lot faster with enable_nestloop=false Robert Haas
- Re: function slower than the same code in an sql file Robert Haas
- Optimization required for multiple insertions in PostgreSQL siva palanisamy
- Re: Intel 710 pgbench write latencies Yeb Havinga
- Re: Optimization required for multiple insertions in PostgreSQL Kevin Grittner
- Re: Performance Problem with postgresql 9.03, 8GB RAM,Quadcore Processor Server--Need help!!!!!!! Tomas Vondra
- Re: Optimization required for multiple insertions in PostgreSQL Tomas Vondra
- Re: SSL encryption makes bytea transfer slow Marti Raudsepp
- Re: Guide to PG's capabilities for inlining, predicate hoisting, flattening, etc? Justin Pitts
- Re: Guide to PG's capabilities for inlining, predicate hoisting, flattening, etc? Gavin Flower
- Predicates not getting pushed into SQL function? Jay Levitt
- Blocking excessively in FOR UPDATE Claudio Freire
- Re: Blocking excessively in FOR UPDATE Claudio Freire
- Re: Optimization required for multiple insertions in PostgreSQL Kevin Grittner
- Re: Predicates not getting pushed into SQL function? Tom Lane
- Re: Blocking excessively in FOR UPDATE Tom Lane
- Re: Predicates not getting pushed into SQL function? Jay Levitt
- Re: Blocking excessively in FOR UPDATE Claudio Freire
- Re: Blocking excessively in FOR UPDATE Claudio Freire
- Re: Performance Problem with postgresql 9.03, 8GB RAM,Quadcore Processor Server--Need help!!!!!!! Mario Weilguni
- Re: Predicates not getting pushed into SQL function? Tom Lane
- Re: function slower than the same code in an sql file CS DBA
- Re: Blocking excessively in FOR UPDATE Tom Lane
- Re: SSL encryption makes bytea transfer slow Albe Laurenz
- Error while vacuuming Bhakti Ghatkar
- Re: Error while vacuuming Guillaume Cottenceau
- Re: Error while vacuuming Tom Lane
- Re: Strange query plan Robert Haas
- Re: Blocking excessively in FOR UPDATE Claudio Freire
- Re: Blocking excessively in FOR UPDATE Robert Haas
- Re: Strange query plan Sorbara, Giorgio (CIOK)
- Re: Blocking excessively in FOR UPDATE Kevin Grittner
- Re: Blocking excessively in FOR UPDATE Claudio Freire
- Re: Blocking excessively in FOR UPDATE Kevin Grittner
- Re: Blocking excessively in FOR UPDATE Claudio Freire
- Re: Blocking excessively in FOR UPDATE Shaun Thomas
- Re: Blocking excessively in FOR UPDATE Claudio Freire
- Re: Strange query plan Robert Haas
- Re: Blocking excessively in FOR UPDATE Robert Haas
- Re: Blocking excessively in FOR UPDATE Shaun Thomas
- Re: Blocking excessively in FOR UPDATE Claudio Freire
- Re: SSL encryption makes bytea transfer slow Heikki Linnakangas
- PostgreSQL perform poorly on VMware ESXi Lucas Mocellin
- Re: PostgreSQL perform poorly on VMware ESXi Tomas Vondra
- Re: PostgreSQL perform poorly on VMware ESXi ktm@rice.edu
- Re: PostgreSQL perform poorly on VMware ESXi Ivan Voras
- Re: Predicates not getting pushed into SQL function? Jay Levitt
- Re: Predicates not getting pushed into SQL function? Jay Levitt
- Re: Blocking excessively in FOR UPDATE Claudio Freire
- Subquery in a JOIN not getting restricted? Jay Levitt
- Re: Subquery in a JOIN not getting restricted? Tom Lane
- Re: Subquery in a JOIN not getting restricted? Kevin Grittner
- WAL partition filling up after high WAL activity Richard Yen
- Re: Subquery in a JOIN not getting restricted? Kevin Grittner
- Re: Subquery in a JOIN not getting restricted? Jay Levitt
- Re: Subquery in a JOIN not getting restricted? Jay Levitt
- Re: Performance Problem with postgresql 9.03, 8GB RAM,Quadcore Processor Server--Need help!!!!!!! Mohamed Hashim
- Re: Error while vacuuming Bhakti Ghatkar
- Re: Error while vacuuming Samuel Gendler
- Re: Performance Problem with postgresql 9.03, 8GB RAM,Quadcore Processor Server--Need help!!!!!!! Sam Gendler
- Re: SSL encryption makes bytea transfer slow Albe Laurenz
- Re: SSL encryption makes bytea transfer slow Marti Raudsepp
- Re: Performance Problem with postgresql 9.03, 8GB RAM,Quadcore Processor Server--Need help!!!!!!! Tomas Vondra
- Re: Performance Problem with postgresql 9.03, 8GB RAM,Quadcore Processor Server--Need help!!!!!!! Mohamed Hashim
- Re: SSL encryption makes bytea transfer slow Albe Laurenz
- Re: Performance Problem with postgresql 9.03, 8GB RAM,Quadcore Processor Server--Need help!!!!!!! Tomas Vondra
- Re: Performance Problem with postgresql 9.03, 8GB RAM,Quadcore Processor Server--Need help!!!!!!! Mario Weilguni
- Re: SSL encryption makes bytea transfer slow Albe Laurenz
- STRICT SQL functions never inline Josh Berkus
- Re: STRICT SQL functions never inline Andres Freund
- Re: STRICT SQL functions never inline Tom Lane
- : bg_writer overloaded ? Venkat Balaji
- Re: : bg_writer overloaded ? Scott Marlowe
- Re: Subquery in a JOIN not getting restricted? Kevin Grittner
- Re: WAL partition filling up after high WAL activity Greg Smith
- Re: Subquery in a JOIN not getting restricted? Merlin Moncure
- Re: Subquery in a JOIN not getting restricted? Kevin Grittner
- Re: Subquery in a JOIN not getting restricted? Jay Levitt
- IMMUTABLE STABLE functions, daily updates Sorin Dudui
- Re: IMMUTABLE STABLE functions, daily updates Thom Brown
- Re: Subquery in a JOIN not getting restricted? Jay Levitt
- Re: IMMUTABLE STABLE functions, daily updates Craig Ringer
- Re: Subquery in a JOIN not getting restricted? Tom Lane
- Re: Subquery in a JOIN not getting restricted? Jay Levitt
- Re: Heavy contgnous load kzsolt
- Re: WAL partition filling up after high WAL activity Rafael Martinez
- avoiding seq scans when two columns are very correlated Ruslan Zakirov
- Re: avoiding seq scans when two columns are very correlated Tom Lane
- where clause + function, execution order Sorin Dudui
- Re: where clause + function, execution order Julius Tuskenis
- Re: where clause + function, execution order Richard Huxton
- Re: where clause + function, execution order Tom Lane
- Re: where clause + function, execution order Sorin Dudui
- Re: avoiding seq scans when two columns are very correlated Ruslan Zakirov
- Re: where clause + function, execution order Richard Huxton
- unlogged tables Anibal David Acosta
- Re: unlogged tables Stephen Frost
- Using incrond for archiving Shaun Thomas
- Re: Performance Problem with postgresql 9.03, 8GB RAM,Quadcore Processor Server--Need help!!!!!!! Lucas Mocellin
- Trying to understand Stats/Query planner issue Strange, John W
- Re: Heavy contgnous load kzsolt
- Re: Subquery in a JOIN not getting restricted? Gavin Flower
- Re: Heavy contgnous load Pavel Stehule
- Re: Trying to understand Stats/Query planner issue Tom Lane
- Re: : bg_writer overloaded ? Venkat Balaji
- Re: unlogged tables Sergey Konoplev
- Re: unlogged tables Richard Huxton
- Re: unlogged tables Sergey Konoplev
- Re: unlogged tables Richard Huxton
- Re: unlogged tables Sergey Konoplev
- Re: unlogged tables Anibal David Acosta
- Re: unlogged tables Kevin Grittner
- Re: unlogged tables Anibal David Acosta
- Re: unlogged tables Kevin Grittner
- Slow queries / commits, mis-configuration or hardware issues? Cody Caughlan
- Re: Slow queries / commits, mis-configuration or hardware issues? Tomas Vondra
- Re: Using incrond for archiving Shaun Thomas
- Re: Using incrond for archiving Kevin Grittner
- Re: Using incrond for archiving Shaun Thomas
- Re: Slow queries / commits, mis-configuration or hardware issues? Cody Caughlan
- Query planner suggestion, for indexes with similar but not exact ordering. Andrew Barnham
- Re: Slow queries / commits, mis-configuration or hardware issues? Tomas Vondra
- Re: Slow queries / commits, mis-configuration or hardware issues? Cody Caughlan
- Large number of short lived connections - could a connection pool help? Cody Caughlan
- Re: Large number of short lived connections - could a connection pool help? Cody Caughlan
- Re: Large number of short lived connections - could a connection pool help? Ben Chobot
- Re: avoiding seq scans when two columns are very correlated Stuart Bishop
- What's the state of postgresql on ext4 now? Alexandru
- Re: What's the state of postgresql on ext4 now? Maciek Sakrejda
- Re: Large number of short lived connections - could a connection pool help? Mario Weilguni
- Re: avoiding seq scans when two columns are very correlated Ruslan Zakirov
- Re: What's the state of postgresql on ext4 now? Josh Berkus
- Re: unlogged tables Josh Berkus
- Re: What's the state of postgresql on ext4 now? Scott Marlowe
- Re: Slow queries / commits, mis-configuration or hardware issues? Tomas Vondra
- Re: Slow queries / commits, mis-configuration or hardware issues? Tomas Vondra
- Re: Slow queries / commits, mis-configuration or hardware issues? Cody Caughlan
- Re: Slow queries / commits, mis-configuration or hardware issues? Tomas Vondra
- Re: What's the state of postgresql on ext4 now? Greg Smith
- Re: What's the state of postgresql on ext4 now? Scott Marlowe
- Re: What's the state of postgresql on ext4 now? Aidan Van Dyk
- Re: Slow queries / commits, mis-configuration or hardware issues? Greg Smith
- Re: What's the state of postgresql on ext4 now? Greg Smith
- Re: Subquery in a JOIN not getting restricted? Jay Levitt
- Re: Slow queries / commits, mis-configuration or hardware issues? Tomas Vondra
- Re: Slow queries / commits, mis-configuration or hardware issues? Tomas Vondra
- Re: Slow queries / commits, mis-configuration or hardware issues? Cody Caughlan
- Re: Slow queries / commits, mis-configuration or hardware issues? Tomas Vondra
- Performance question 83 GB Table 150 million rows, distinct select Tory M Blue
- Re: Performance question 83 GB Table 150 million rows, distinct select Alan Hodgson
- Re: Performance question 83 GB Table 150 million rows, distinct select Scott Marlowe
- Re: Performance question 83 GB Table 150 million rows, distinct select Samuel Gendler
- Re: Performance question 83 GB Table 150 million rows, distinct select Tomas Vondra
- Re: Performance question 83 GB Table 150 million rows, distinct select Tory M Blue
- Re: Performance question 83 GB Table 150 million rows, distinct select Scott Marlowe
- Re: Performance question 83 GB Table 150 million rows, distinct select Scott Marlowe
- Re: Performance question 83 GB Table 150 million rows, distinct select Andy Colson
- Re: Performance question 83 GB Table 150 million rows, distinct select Tomas Vondra
- Re: Performance question 83 GB Table 150 million rows, distinct select Tory M Blue
- Re: Performance question 83 GB Table 150 million rows, distinct select Scott Marlowe
- Re: Performance question 83 GB Table 150 million rows, distinct select Scott Marlowe
- Re: Performance question 83 GB Table 150 million rows, distinct select Tory M Blue
- Re: Performance question 83 GB Table 150 million rows, distinct select Tomas Vondra
- Re: Performance question 83 GB Table 150 million rows, distinct select Josh Berkus
- Re: Performance question 83 GB Table 150 million rows, distinct select Tory M Blue
- Re: Performance question 83 GB Table 150 million rows, distinct select Tory M Blue
- Re: Performance question 83 GB Table 150 million rows, distinct select Aidan Van Dyk
- Re: Performance question 83 GB Table 150 million rows, distinct select Tomas Vondra
- Re: Performance question 83 GB Table 150 million rows, distinct select Claudio Freire
- external sort performance Jon Nelson
- Re: external sort performance Claudio Freire
- Re: external sort performance Craig James
- Re: external sort performance Tom Lane
- Re: external sort performance Jon Nelson
- Re: external sort performance Jon Nelson
- Re: external sort performance Tom Lane
- Re: external sort performance Josh Berkus
- index usage for min() vs. "order by asc limit 1" Ben Chobot
- Re: index usage for min() vs. "order by asc limit 1" Steve Atkins
- Re: index usage for min() vs. "order by asc limit 1" Ben Chobot
- Re: SSD options, small database, ZFS CSS
- Re: SSD options, small database, ZFS Arjen van der Meijden
- probably cause (and fix) for floating-point assist faults on itanium Greg Matthews
- Benchmarking tools, methods CSS
- Re: SSD options, small database, ZFS Greg Smith
- Re: Benchmarking tools, methods Tomas Vondra
- Re: Benchmarking tools, methods Cédric Villemain
- Re: index usage for min() vs. "order by asc limit 1" MirrorX
- Re: probably cause (and fix) for floating-point assist faults on itanium Claudio Freire
- Re: probably cause (and fix) for floating-point assist faults on itanium Tom Lane
- Re: SSD options, small database, ZFS Scott Marlowe
- Re: SSD options, small database, ZFS Tomas Vondra
- Re: SSD options, small database, ZFS Amitabh Kant
- Re: Benchmarking tools, methods Scott Marlowe
- Re: probably cause (and fix) for floating-point assist faults on itanium Tom Lane
- Re: probably cause (and fix) for floating-point assist faults on itanium Greg Matthews
- Re: Benchmarking tools, methods Greg Smith
- Re: external sort performance Jeremy Harris
- Re: external sort performance Jon Nelson
- Re: external sort performance Jeremy Harris
- Re: Problems with FTS Rauan Maemirov
- SSD endurance calculations Christiaan Willemsen
- Re: SSD options, small database, ZFS Bruce Momjian
- Re: SSD options, small database, ZFS Bruce Momjian
- Autovacuum Issue J Ramesh Kumar
- Re: Autovacuum Issue Raghavendra
- Re: SSD options, small database, ZFS Amitabh Kant
- Re: SSD endurance calculations Greg Smith
- Seq Scan used instead of Index Scan Gary Warner
- Re: Seq Scan used instead of Index Scan Claudio Freire
- Re: Seq Scan used instead of Index Scan Mark Kirkwood
- Re: Seq Scan used instead of Index Scan Tom Lane
- Re: SSD endurance calculations Edgardo Portal
- Some question about lazy subquery/procedures execution in SELECT ... ORDER BY... LIMIT N queries Maxim Boguk
- Re: Some question about lazy subquery/procedures execution in SELECT ... ORDER BY... LIMIT N queries Tom Lane
- query uses index but takes too much time? MirrorX
- Re: query uses index but takes too much time? Aidan Van Dyk
- Re: query uses index but takes too much time? Cédric Villemain
- Re: Some question about lazy subquery/procedures execution in SELECT ... ORDER BY... LIMIT N queries Maxim Boguk
- Re: Some question about lazy subquery/procedures execution in SELECT ... ORDER BY... LIMIT N queries Craig Ringer
- Re: Some question about lazy subquery/procedures execution in SELECT ... ORDER BY... LIMIT N queries Maxim Boguk
- PostgreSQL 9.1 : why is this query slow? Joost Kraaijeveld
- Re: PostgreSQL 9.1 : why is this query slow? Joost Kraaijeveld
- Re: PostgreSQL 9.1 : why is this query slow? Kevin Grittner
- Re: PostgreSQL 9.1 : why is this query slow? Joost Kraaijeveld
- Re: PostgreSQL 9.1 : why is this query slow? Kevin Grittner
- Re: PostgreSQL 9.1 : why is this query slow? Kevin Grittner
- Re: PostgreSQL 9.1 : why is this query slow? Tomas Vondra
- Re: Benchmarking tools, methods CSS
- Re: PostgreSQL 9.1 : why is this query slow? Joost Kraaijeveld
- Re: WAL in RAM Marcus Engene
- vacuum internals and performance affect MirrorX
- Guidance Requested - Bulk Inserting + Queries Benjamin Johnson
- Re: Guidance Requested - Bulk Inserting + Queries Leonardo Francalanci
- Re: Query planner suggestion, for indexes with similar but not exact ordering. Robert Haas
- Re: Problems with FTS Robert Haas
- Re: vacuum internals and performance affect Josh Berkus
- Re: vacuum internals and performance affect MirrorX