Mailing lists [pgsql-performance]
- Re: [pgadmin-support] 100% CPU Mark Kirkwood
- Re: FWD: Update touches unrelated indexes? Jaime Casanova
- optimizing LIKE '%2345' queries Gene
- Sort order in sub-select Craig A. James
- Calling a SP from Curosor loop satishchandra999@gmail.com
- Re: optimizing LIKE '%2345' queries Mario Weilguni
- Is postgresql ca do the job for software deployed in ASP ou SaaS mode? David Gagnon
- Re: Is postgresql ca do the job for software deployed in ASP ou SaaS mode? Richard Broersma Jr
- Re: Is postgresql ca do the job for software deployed in ASP ou SaaS mode? Chris Hoover
- Re: Is postgresql ca do the job for software deployed in Craig A. James
- Re: [BUGS] query very slow when enable_seqscan=on Simon Riggs
- Re: Is postgresql ca do the job for software deployed in ASP ou SaaS mode? Guoping Zhang
- Re: Is postgresql ca do the job for software deployed in ASP ou SaaS mode? Mikael Carneholm
- Re: optimizing LIKE '%2345' queries Tarhon-Onu Victor
- Re: Is postgresql ca do the job for software deployed in ASP David Gagnon
- Re: Is postgresql ca do the job for software deployed in ASP ou SaaS mode? Mikael Carneholm
- Re: Is postgresql ca do the job for software deployed in ASP David Gagnon
- how to tune this query. Luckys
- Re: how to tune this query. Nolan Cafferky
- Re: optimizing LIKE '%2345' queries Gene
- Re: optimizing LIKE '%2345' queries Chris
- Problem with bitmap-index-scan plan jkapad@csd.uoc.gr
- Re: Is postgresql ca do the job for software deployed in Markus Schaber
- Re: Is postgresql ca do the job for software deployed in Gregory S. Williamson
- managing database with thousands of tables Eugeny N Dzhurinsky
- Re: managing database with thousands of tables Tom Lane
- Opteron/FreeBSD/PostgreSQL performance poor andy rost
- Re: Opteron/FreeBSD/PostgreSQL performance poor Stephen Frost
- Re: managing database with thousands of tables Eugeny N Dzhurinsky
- Re: Opteron/FreeBSD/PostgreSQL performance poor Vivek Khera
- Re: Opteron/FreeBSD/PostgreSQL performance poor andy rost
- Re: Is postgresql ca do the job for software deployed in Markus Schaber
- Re: Opteron/FreeBSD/PostgreSQL performance poor Mark Kirkwood
- suggested RAID controller for FreeBSD 6.1 + PostgreSQL 8.1 Kenji Morishige
- Re: managing database with thousands of tables Chris
- Re: suggested RAID controller for FreeBSD 6.1 + PostgreSQL Mark Kirkwood
- getting better performance Eugeny N Dzhurinsky
- Re: getting better performance A. Kretschmer
- Re: unsubscribe Chethana, Rao (IE10)
- Re: getting better performance Ivan Zolotukhin
- unsubscribe Monique.Lu@alcatel.fr
- unsubscribe Vipul.Gupta@trilogy.com
- Re: getting better performance Scott Marlowe
- Re: Opteron/FreeBSD/PostgreSQL performance poor Merlin Moncure
- Re: getting better performance Eugeny N Dzhurinsky
- Re: getting better performance Merlin Moncure
- Re: getting better performance Scott Marlowe
- unsubscribe Lorenzo Pasquinelli
- victory! Merlin Moncure
- Re: victory! A.M.
- Re: suggested RAID controller for FreeBSD 6.1 + PostgreSQL 8.1 Kenji Morishige
- Re: suggested RAID controller for FreeBSD 6.1 + Scott Marlowe
- Re: suggested RAID controller for FreeBSD 6.1 +PostgreSQL 8.1 Paul Khavkine
- Re: suggested RAID controller for FreeBSD 6.1 + PostgreSQL Mark Kirkwood
- Query plan issue when upgrading to postgres 8.14 (from postgres 8.12 or 7.4) Ioana Danes
- Re: Query plan issue when upgrading to postgres 8.14 (from Chris
- need vacuum after insert/truncate/insert? Craig A. James
- Re: suggested RAID controller for FreeBSD 6.1 +PostgreSQL Michael Loftis
- Query plan issue when upgrading to postgres 8.14 (from postgres 8.12 or 7.4) Ioana Danes
- Update INSERT RULE while running for Partitioning Gene
- Re: getting better performance Markus Schaber
- Re: need vacuum after insert/truncate/insert? Markus Schaber
- Re: Update INSERT RULE while running for Partitioning Markus Schaber
- longest prefix match querries Hripchenko Sergey
- Re: Calling a SP from Curosor loop Merlin Moncure
- Re: suggested RAID controller for FreeBSD 6.1 + Ron Peacetree
- Re: Update INSERT RULE while running for Partitioning Dave Chapeskie
- Re: how to tune this query. Merlin Moncure
- Re: Opteron/FreeBSD/PostgreSQL performance poor andy rost
- Re: Opteron/FreeBSD/PostgreSQL performance poor andy rost
- Delete is very slow; PG not using existing index to check foreign keys K-Bob body
- Re: Opteron/FreeBSD/PostgreSQL performance poor Jeff Frost
- VACUUM vs. REINDEX William Scott Jordan
- Re: VACUUM vs. REINDEX Richard Broersma Jr
- Re: VACUUM vs. REINDEX Jeff Frost
- Re: VACUUM vs. REINDEX William Scott Jordan
- Re: VACUUM vs. REINDEX Jeff Frost
- Re: VACUUM vs. REINDEX William Scott Jordan
- Re: VACUUM vs. REINDEX Joshua D. Drake
- Re: VACUUM vs. REINDEX Chris Hoover
- Re: VACUUM vs. REINDEX Joshua D. Drake
- Re: VACUUM vs. REINDEX Steinar H. Gunderson
- Re: VACUUM vs. REINDEX Stefan Kaltenbrunner
- Re: Opteron/FreeBSD/PostgreSQL performance poor Merlin Moncure
- High CPU Usage - PostgreSQL 7.3 Neil Hepworth
- Re: High CPU Usage - PostgreSQL 7.3 Jeff Frost
- Re: High CPU Usage - PostgreSQL 7.3 Neil Hepworth
- Re: High CPU Usage - PostgreSQL 7.3 Neil Hepworth
- Re: suggested RAID controller for FreeBSD 6.1 + PostgreSQL 8.1 Vivek Khera
- Re: High CPU Usage - PostgreSQL 7.3 Jeff Frost
- Re: High CPU Usage - PostgreSQL 7.3 Scott Marlowe
- Kill a session Craig A. James
- Re: Kill a session Tino Wildenhain
- Re: Kill a session Magnus Hagander
- Unsubscribe Jghaffou
- Re: High CPU Usage - PostgreSQL 7.3 Bruno Wolff III
- Re: High CPU Usage - PostgreSQL 7.3 Neil Hepworth
- Re: High CPU Usage - PostgreSQL 7.3 Jeff Frost
- Re: High CPU Usage - PostgreSQL 7.3 Jeff Frost
- Re: High CPU Usage - PostgreSQL 7.3 Neil Hepworth
- Out of Memory Problem. nicky
- Performance Problem between Ora 10g and Psql Thomas Radnetter
- Re: Performance Problem between Ora 10g and Psql Guillaume Smet
- Re: Performance Problem between Ora 10g and Psql Joshua D. Drake
- Re: High CPU Usage - PostgreSQL 7.3 Jeff Frost
- Re: Kill a session Craig A. James
- Commit slower on faster PC Koth, Christian (DWBI)
- Re: Kill a session Steinar H. Gunderson
- Re: Commit slower on faster PC Mark Lewis
- Re: Commit slower on faster PC D'Arcy J.M. Cain
- Re: Kill a session Magnus Hagander
- size of pg_dump files containing bytea values Steve McWilliams
- Re: Commit slower on faster PC Joshua D. Drake
- [Fwd: Delivery Status Notification (Failure)] Craig A. James
- Re: Kill a session Stefan Kaltenbrunner
- Re: [Fwd: Delivery Status Notification (Failure)] Michael Glaesemann
- Re: Commit slower on faster PC Bruno Wolff III
- Re: High CPU Usage - PostgreSQL 7.3 Jeff Frost
- hyper slow after upgrade to 8.1.4 Medora Schauer
- Re: [Fwd: Delivery Status Notification (Failure)] Richard Broersma Jr
- Re: hyper slow after upgrade to 8.1.4 Joshua D. Drake
- Re: [Fwd: Delivery Status Notification (Failure)] Craig A. James
- Re: [Fwd: Delivery Status Notification (Failure)] Richard Broersma Jr
- Re: hyper slow after upgrade to 8.1.4 Bruno Wolff III
- Re: size of pg_dump files containing bytea values Tom Lane
- Re: [Fwd: Delivery Status Notification (Failure)] Tom Lane
- Re: Commit slower on faster PC Koth, Christian (DWBI)
- Re: Sun Donated a Sun Fire T2000 to the PostgreSQL Tatsuo Ishii
- Re: hyper slow after upgrade to 8.1.4 Medora Schauer
- Re: Sun Donated a Sun Fire T2000 to the PostgreSQL Tom Lane
- Re: hyper slow after upgrade to 8.1.4 Michael Fuhr
- Re: size of pg_dump files containing bytea values Greg Stark
- Re: hyper slow after upgrade to 8.1.4 Tom Lane
- Re: size of pg_dump files containing bytea values Tom Lane
- Re: hyper slow after upgrade to 8.1.4 Medora Schauer
- Re: Problem with bitmap-index-scan plan Tom Lane
- Re: Kill a session Mark Kirkwood
- Re: Kill a session Craig A. James
- Re: Kill a session Craig A. James
- Re: Kill a session Tom Lane
- Re: size of pg_dump files containing bytea values Florian Weimer
- Re: Kill a session Markus Schaber
- Re: Kill a session Craig A. James
- Re: Kill a session Tom Lane
- Self-join query and index usage worky.workerson@gmail.com
- Re: Self-join query and index usage Tom Lane
- Big differences in plans between 8.0 and 8.1 Gabriele Turchi
- increment Rows in an SQL Result Set postgresql Hassan Adekoya
- Re: increment Rows in an SQL Result Set postgresql Craig A. James
- Re: increment Rows in an SQL Result Set postgresql Hassan
- Re: Big differences in plans between 8.0 and 8.1 Michael Fuhr
- Re: Big differences in plans between 8.0 and 8.1 Gabriele Turchi
- Re: Big differences in plans between 8.0 and 8.1 Joe Conway
- Re: Big differences in plans between 8.0 and 8.1 Gabriele Turchi
- Re: increment Rows in an SQL Result Set postgresql Peter Eisentraut
- Re: Big differences in plans between 8.0 and 8.1 Joe Conway
- RAID stripe size question Mikael Carneholm
- Re: RAID stripe size question Steinar H. Gunderson
- Re: RAID stripe size question Michael Stone
- Re: RAID stripe size question Alex Turner
- Re: RAID stripe size question Mikael Carneholm
- Re: RAID stripe size question Markus Schaber
- Re: RAID stripe size question Mikael Carneholm
- Re: RAID stripe size question Markus Schaber
- Re: RAID stripe size question Mikael Carneholm
- Re: RAID stripe size question Ron Peacetree
- Re: RAID stripe size question Steinar H. Gunderson
- Re: RAID stripe size question Alex Turner
- Re: Big differences in plans between 8.0 and 8.1 Chris Hoover
- Re: RAID stripe size question Mikael Carneholm
- Re: RAID stripe size question Mark Kirkwood
- Re: RAID stripe size question Ron Peacetree
- Re: RAID stripe size question Alex Turner
- Re: Problem with bitmap-index-scan plan Kapadaidakis Yannis
- Re: Big differences in plans between 8.0 and 8.1 Gabriele Turchi
- Re: Temporary table retains old contents on update eventually causing slow temp file usage. Rusty Conover
- Temporary table retains old contents on update eventually causing slow temp file usage. Rusty Conover
- Re: Temporary table retains old contents on update eventually Gavin Sherry
- Re: RAID stripe size question Ron Peacetree
- Re: RAID stripe size question Mikael Carneholm
- Re: Temporary table retains old contents on update eventually causing slow temp file usage. Rusty Conover
- Re: RAID stripe size question Luke Lonergan
- Re: RAID stripe size question Alex Turner
- Re: RAID stripe size question Scott Marlowe
- Re: RAID stripe size question Ron Peacetree
- Re: RAID stripe size question Scott Marlowe
- Re: RAID stripe size question Milen Kulev
- Re: Query plan issue when upgrading to postgres 8.14 (from Ioana Danes
- Performance penalty for remote access of postgresql (8.1.3)? any experiance? Guoping Zhang
- Re: Performance penalty for remote access of postgresql (8.1.3)? any experiance? Florian Weimer
- Re: Performance penalty for remote access of postgresql (8.1.3)? any experiance? Guoping Zhang
- Re: Performance penalty for remote access of postgresql (8.1.3)? any experiance? Florian Weimer
- Re: Performance penalty for remote access of postgresql (8.1.3)? any experiance? Stephen Frost
- Re: Performance penalty for remote access of postgresql (8.1.3)? any experiance? Florian Weimer
- Re: Performance penalty for remote access of postgresql (8.1.3)? any experiance? Stephen Frost
- Re: Performance penalty for remote access of postgresql Bill Moran
- Re: Performance penalty for remote access of postgresql Joe Conway
- Re: Performance penalty for remote access of postgresql (8.1.3)? any experiance? Guoping Zhang
- Re: Performance penalty for remote access of postgresql David Boreham
- Re: Sun Donated a Sun Fire T2000 to the PostgreSQL Tom Lane
- Re: Sun Donated a Sun Fire T2000 to the PostgreSQL Robert Lor
- Forcing using index instead of sequential scan?
- Re: Forcing using index instead of sequential scan?
- Re: Forcing using index instead of sequential scan?
- Re: Forcing using index instead of sequential scan? Peter Eisentraut
- postgres benchmarks Petronenko D.S.
- Re: Sun Donated a Sun Fire T2000 to the PostgreSQL Tom Lane
- Re: [HACKERS] Sun Donated a Sun Fire T2000 to the PostgreSQL Jim C. Nasby
- Re: [HACKERS] Sun Donated a Sun Fire T2000 to the PostgreSQL Sven Geisler
- Re: Sun Donated a Sun Fire T2000 to the PostgreSQL Robert Lor
- Re: BUG #2543: Performance delay acrros the same day Bruno Wolff III
- Bad Planner Statistics for Uneven distribution. Kevin McArthur
- Partitioned tables in queries Kevin Keith
- Re: Partitioned tables in queries Steve Atkins
- Re: Partitioned tables in queries Kevin Keith
- Re: Bad Planner Statistics for Uneven distribution. Tom Lane
- Re: Bad Planner Statistics for Uneven distribution. Guillaume Smet
- Re: Sun Donated a Sun Fire T2000 to the PostgreSQL Robert Lor
- Re: Forcing using index instead of sequential scan? Tom Lane
- Re: Bad Planner Statistics for Uneven distribution. Tom Lane
- Re: Forcing using index instead of sequential scan? Craig A. James
- Re: Forcing using index instead of sequential scan? Gregory Stark
- Re: Forcing using index instead of sequential scan? Mark Kirkwood
- Re: Forcing using index instead of sequential scan? Mark Kirkwood
- Re: Forcing using index instead of sequential scan? Michael Stone
- Re: Forcing using index instead of sequential scan? Craig A. James
- Re: Sun Donated a Sun Fire T2000 to the PostgreSQL Tom Lane
- Re: postgres benchmarks Denis Lussier
- Re: Sun Donated a Sun Fire T2000 to the PostgreSQL Tom Lane
- Re: Sun Donated a Sun Fire T2000 to the PostgreSQL Robert Lor
- Re: Sun Donated a Sun Fire T2000 to the PostgreSQL Tom Lane
- Re: Sun Donated a Sun Fire T2000 to the PostgreSQL Robert Lor
- Re: BUG #2543: Performance delay acrros the same day Markus Schaber
- Re: Partitioned tables in queries Andrew Hammond
- loading increase into huge table with 50.000.000 records nuggets72@free.fr
- Re: loading increase into huge table with 50.000.000 records Sven Geisler
- Re: loading increase into huge table with 50.000.000 records Markus Schaber
- Re: loading increase into huge table with 50.000.000 records Merlin Moncure
- Is it possible to speed this query up? Arnau
- Re: Is it possible to speed this query up? Tom Lane
- performance issue with a specific query Eliott
- Re: performance issue with a specific query Scott Marlowe
- Re: performance issue with a specific query Merlin Moncure
- Re: performance issue with a specific query Joshua D. Drake
- Re: performance issue with a specific query Alvaro Herrera
- Savepoint performance Mark Lewis
- Re: Query plan issue when upgrading to postgres 8.14 (from Ioana Danes
- Re: Savepoint performance Alvaro Herrera
- Re: performance issue with a specific query Tom Lane
- Re: Query plan issue when upgrading to postgres 8.14 (from Tom Lane
- Re: Savepoint performance Jaime Casanova
- Re: Savepoint performance Denis Lussier
- Disk writes carlosreimer
- Re: Savepoint performance Tom Lane
- Re: Savepoint performance Denis Lussier
- Re: Disk writes Florian Weimer
- Performance with 2 AMD/Opteron 2.6Ghz and 8gig DDR PC3200 Kjell Tore Fossbakk
- Re: Performance with 2 AMD/Opteron 2.6Ghz and 8gig Luke Lonergan
- Re: Performance with 2 AMD/Opteron 2.6Ghz and 8gig Mikael Carneholm
- Re: Performance with 2 AMD/Opteron 2.6Ghz and 8gig Luke Lonergan
- Re: Performance with 2 AMD/Opteron 2.6Ghz and 8gig Luke Lonergan
- Re: Performance with 2 AMD/Opteron 2.6Ghz and 8gig Mikael Carneholm
- Re: performance issue with a specific query Eliott
- Re: Performance with 2 AMD/Opteron 2.6Ghz and 8gig Kjell Tore Fossbakk
- Re: Performance with 2 AMD/Opteron 2.6Ghz and 8gig DDR PC3200 Claus Guttesen
- Re: Disk writes Scott Marlowe
- Re: Performance with 2 AMD/Opteron 2.6Ghz and 8gig Jeff Trout
- Re: Performance with 2 AMD/Opteron 2.6Ghz and 8gig Leigh Dyer
- Re: Performance with 2 AMD/Opteron 2.6Ghz and 8gig Mark Lewis
- index usage Ben
- Re: index usage Daniel Caune
- Re: Performance with 2 AMD/Opteron 2.6Ghz and 8gig Luke Lonergan
- Re: index usage Ben
- Re: index usage Mark Lewis
- Re: index usage Tom Lane
- Re: Performance with 2 AMD/Opteron 2.6Ghz and 8gig Charles Sprickman
- Re: Performance with 2 AMD/Opteron 2.6Ghz and 8gig Luke Lonergan
- PostgreSQL scalability on Sun UltraSparc T1 Jochem van Dieten
- Re: PostgreSQL scalability on Sun UltraSparc T1 Joshua D. Drake
- Re: PostgreSQL scalability on Sun UltraSparc T1 Arjen van der Meijden
- Re: PostgreSQL scalability on Sun UltraSparc T1 Arjen van der Meijden
- Re: PostgreSQL scalability on Sun UltraSparc T1 Joshua D. Drake
- Re: PostgreSQL scalability on Sun UltraSparc T1 Arjen van der Meijden
- Re: Performance with 2 AMD/Opteron 2.6Ghz and 8gig Denis Lussier
- Re: Performance with 2 AMD/Opteron 2.6Ghz and 8gig Luke Lonergan
- Re: PostgreSQL scalability on Sun UltraSparc T1 Luke Lonergan
- Re: Performance with 2 AMD/Opteron 2.6Ghz and 8gig Denis Lussier
- Re: Performance with 2 AMD/Opteron 2.6Ghz and 8gig DDR PC3200 Kjell Tore Fossbakk
- Re: Performance with 2 AMD/Opteron 2.6Ghz and 8gig Luke Lonergan
- Re: Performance with 2 AMD/Opteron 2.6Ghz and 8gig DDR PC3200 Kjell Tore Fossbakk
- sub select performance due to seq scans H Hale
- How to increase performance? Hristo Markov
- Query 200x slower on server [PART 2] NbForYou
- Strange behaviour Richard Rowell
- Re: PostgreSQL scalability on Sun UltraSparc T1 Jignesh Shah
- Re: PostgreSQL scalability on Sun UltraSparc T1 Arjen van der Meijden
- Re: sub select performance due to seq scans Richard Huxton
- Re: How to increase performance? Richard Huxton
- Re: Query 200x slower on server [PART 2] Richard Huxton
- directory tree query with big planner variation Axel Rau
- Re: directory tree query with big planner variation Michael Stone
- Re: directory tree query with big planner variation Axel Rau
- Partitioning / constrain exlusion not working with %-operator Martin Lesser
- Re: sub select performance due to seq scans Rod Taylor
- Re: Partitioning / constrain exlusion not working with %-operator Tom Lane
- Performances with new Intel Core* processors Jonathan Ballet
- Re: sub select performance due to seq scans Tom Lane
- Re: directory tree query with big planner variation Michael Stone
- Re: directory tree query with big planner variation Mark Lewis
- Re: sub select performance due to seq scans H Hale
- Re: sub select performance due to seq scans Tom Lane
- Re: directory tree query with big planner variation Axel Rau
- Re: directory tree query with big planner variation Michael Stone
- Re: Performances with new Intel Core* processors Merlin Moncure
- Re: directory tree query with big planner variation Axel Rau
- Re: PostgreSQL scalability on Sun UltraSparc T1 Merlin Moncure
- Re: sub select performance due to seq scans H Hale
- Re: directory tree query with big planner variation Axel Rau
- Re: directory tree query with big planner variation Axel Rau
- Re: Performances with new Intel Core* processors Arjen van der Meijden
- Re: directory tree query with big planner variation Michael Stone
- Re: directory tree query with big planner variation Axel Rau
- Re: Performances with new Intel Core* processors Bruce Momjian
- Re: Performances with new Intel Core* processors Scott Marlowe
- Re: Performances with new Intel Core* processors Vivek Khera