Mailing lists [pgsql-performance]
- Re: Very slow queries Chad Wagner
- Re: Slow update Tomas Vondra
- Using statement_timeout as a performance tool? Mark Stosberg
- Subselect query enhancement Michael Artz
- Re: Subselect query enhancement Richard Huxton
- Re: Subselect query enhancement Ted Allen
- Re: Subselect query enhancement Michael Artz
- Re: Subselect query enhancement Frank Wiles
- Re: Subselect query enhancement Michael Artz
- Re: Subselect query enhancement Richard Huxton
- Re: Subselect query enhancement Michael Artz
- Re: int4 vs varchar to store ip addr Michael Artz
- Re: Subselect query enhancement Andrew Lazarus
- drive configuration for a new server Ben
- Re: Subselect query enhancement Richard Huxton
- trouble with a join on OS X Kirk Wythers
- Re: trouble with a join on OS X Steinar H. Gunderson
- Re: trouble with a join on OS X Richard Huxton
- Re: trouble with a join on OS X Gábriel Ákos
- Re: trouble with a join on OS X Tom Lane
- Re: trouble with a join on OS X Kirk Wythers
- Re: trouble with a join on OS X Kirk Wythers
- Re: trouble with a join on OS X Steinar H. Gunderson
- Re: trouble with a join on OS X Tom Lane
- Re: trouble with a join on OS X Kirk Wythers
- Re: trouble with a join on OS X Tom Lane
- Re: trouble with a join on OS X Kirk Wythers
- Re: trouble with a join on OS X Kirk Wythers
- Re: drive configuration for a new server Jeff Frost
- Re: drive configuration for a new server Ben
- OT: Mac OS X disk buffer cache Kevin Murphy
- Re: trouble with a join on OS X Tom Lane
- Re: trouble with a join on OS X Luke Lonergan
- Re: trouble with a join on OS X Joshua D. Drake
- Re: trouble with a join on OS X Luke Lonergan
- Re: trouble with a join on OS X Kirk Wythers
- Re: trouble with a join on OS X Joshua D. Drake
- Re: trouble with a join on OS X Kirk Wythers
- Re: trouble with a join on OS X Geoffrey
- Re: trouble with a join on OS X Joshua D. Drake
- Re: trouble with a join on OS X Tom Lane
- Re: trouble with a join on OS X Kirk Wythers
- Re: trouble with a join on OS X Joshua D. Drake
- Re: trouble with a join on OS X Tom Lane
- Re: trouble with a join on OS X Shane Ambler
- optimizing a geo_distance() proximity query Mark Stosberg
- Re: optimizing a geo_distance() proximity query Oleg Bartunov
- Re: optimizing a geo_distance() proximity query Bruno Wolff III
- Re: trouble with a join on OS X Kirk Wythers
- Re: trouble with a join on OS X Shane Ambler
- Re: optimizing a geo_distance() proximity query Mark Stosberg
- Re: optimizing a geo_distance() proximity query Merlin Moncure
- Re: optimizing a geo_distance() proximity query Bruno Wolff III
- Re: optimizing a geo_distance() proximity query (example and benchmark) Mark Stosberg
- Re: Tuning Mischa Sandberg
- index scan through a subquery Bill Howe
- How long should it take to insert 200,000 records? Karen Hill
- Re: How long should it take to insert 200,000 records? Tom Lane
- Re: optimizing a geo_distance() proximity query (example and benchmark) Bruno Wolff III
- Re: index scan through a subquery Tom Lane
- Re: How long should it take to insert 200,000 records? Csaba Nagy
- Re: Tuning Harald Armin Massa
- Re: optimizing a geo_distance() proximity query (example and benchmark) Merlin Moncure
- Re: explain analyze output for review (was: optimizing a geo_distance()...) Mark Stosberg
- Re: explain analyze output for review (was: optimizing a geo_distance()...) Adam Rich
- Re: explain analyze output: vacuuming made a big difference. Mark Stosberg
- Re: explain analyze output for review (was: optimizing a geo_distance()...) Bruno Wolff III
- Re: How long should it take to insert 200,000 records? Scott Marlowe
- Re: How long should it take to insert 200,000 records? Merlin Moncure
- Re: How long should it take to insert 200,000 records? Scott Marlowe
- Re: How long should it take to insert 200,000 records? Merlin Moncure
- Re: How long should it take to insert 200,000 records? Mark Lewis
- Re: How long should it take to insert 200,000 records? Bruno Wolff III
- Re: How long should it take to insert 200,000 records? Merlin Moncure
- Re: How long should it take to insert 200,000 records? Mark Lewis
- Re: index scan through a subquery Bill Howe
- Re: explain analyze output for review (was: optimizing a geo_distance()...) Hiltibidal, Robert
- Re: explain analyze output for review (was: optimizing a geo_distance()...) Hiltibidal, Robert
- Re: How long should it take to insert 200,000 records? Hiltibidal, Robert
- Re: How long should it take to insert 200,000 records? Karen Hill
- Re: How long should it take to insert 200,000 records? Karen Hill
- Re: How long should it take to insert 200,000 records? Mark Kirkwood
- Re: How long should it take to insert 200,000 records? Tom Lane
- Help Needed Muruganantham M
- Re: Help Needed Richard Huxton
- tip: faster sorting for proximity queries by using cube_distance() Mark Stosberg
- stats collector process high CPU utilization Benjamin Minshall
- Re: Speed up this query Mark Stosberg
- Re: stats collector process high CPU utilization Tom Lane
- Disk saturation Carlos H. Reimer
- Re: stats collector process high CPU utilization Benjamin Minshall
- Re: stats collector process high CPU utilization Tom Lane
- Re: stats collector process high CPU utilization Benjamin Minshall
- Re: stats collector process high CPU utilization Tom Lane
- Re: stats collector process high CPU utilization Benjamin Minshall
- Re: stats collector process high CPU utilization Tom Lane
- Re: stats collector process high CPU utilization Benjamin Minshall
- Re: stats collector process high CPU utilization Tom Lane
- Re: stats collector process high CPU utilization minshall@intellicon.biz
- Re: stats collector process high CPU utilization Tom Lane
- Re: stats collector process high CPU utilization Alvaro Herrera
- Re: stats collector process high CPU utilization Tom Lane
- Re: stats collector process high CPU utilization Tom Lane
- Re: stats collector process high CPU utilization Benjamin Minshall
- Re: stats collector process high CPU utilization Tom Lane
- Recreate big table Gábriel Ákos
- Re: stats collector process high CPU utilization Benjamin Minshall
- Re: Recreate big table Daniel Cristian Cruz
- cube operations slower than geo_distance() on production server Mark Stosberg
- Re: Can anyone make this code tighter? Too slow, Please help! Mark Stosberg
- Is there an equivalent for Oracle's user_tables.num_rows Virag Saksena
- Re: Is there an equivalent for Oracle's user_tables.num_rows Tom Lane
- Re: Is there an equivalent for Oracle's user_tables.num_rows Virag Saksena
- Re: Is there an equivalent for Oracle'suser_tables.num_rows Simon Riggs
- Re: cube operations slower than geo_distance() on production server Merlin Moncure
- Re: cube operations slower than geo_distance() on production server Mark Stosberg
- Re: cube operations slower than geo_distance() on production server Merlin Moncure
- Re: cube operations slower than geo_distance() on production server Merlin Moncure
- Re: cube operations slower than geo_distance() on production server Mark Stosberg
- limit + order by is slow if no rows in result set Brian Cox
- Re: limit + order by is slow if no rows in result set Heikki Linnakangas
- Re: limit + order by is slow if no rows in result set Brian Cox
- Re: limit + order by is slow if no rows in result set Tom Lane
- many instances or many databases or many users? ismo.tuononen@solenovo.fi
- Re: many instances or many databases or many users? Heikki Linnakangas
- Re: cube operations slower than geo_distance() on production server Merlin Moncure
- Re: cube operations slower than geo_distance() on production server Merlin Moncure
- Question about Bitmap Heap Scan/BitmapAnd Guillaume Smet
- Re: Question about Bitmap Heap Scan/BitmapAnd Tom Lane
- Proximity query with GIST and row estimation Guillaume Smet
- Re: Question about Bitmap Heap Scan/BitmapAnd Guillaume Smet
- Re: Question about Bitmap Heap Scan/BitmapAnd Tom Lane
- CPU Usage Campbell, Lance
- Re: CPU Usage Alan Hodgson
- JOIN to a VIEW makes a real slow query Chuck D.
- Re: JOIN to a VIEW makes a real slow query Merlin Moncure
- quad or dual core Intel CPUs Kenji Morishige
- Re: JOIN to a VIEW makes a real slow query Chuck D.
- Re: JOIN to a VIEW makes a real slow query Tom Lane
- Re: cube operations slower than geo_distance() on production server Mark Stosberg
- Re: quad or dual core Intel CPUs Arjen van der Meijden
- Re: quad or dual core Intel CPUs Mark Kirkwood
- Re: quad or dual core Intel CPUs Dan Harris
- Re: quad or dual core Intel CPUs Guillaume Smet
- Re: quad or dual core Intel CPUs Heikki Linnakangas
- Re: cube operations slower than geo_distance() on production server Tom Lane
- An unwanted seqscan Brian Herlihy
- Re: An unwanted seqscan Tom Lane
- Re: quad or dual core Intel CPUs Claus Guttesen
- Benchmarking PGSQL? Krishna Kumar
- Re: Benchmarking PGSQL? Shoaib Mir
- Re: cube operations slower than geo_distance() on production server Merlin Moncure
- Re: Benchmarking PGSQL? Luke Lonergan
- Re: Benchmarking PGSQL? Merlin Moncure
- reindex vs 'analyze' (was: Re: cube operations slower than geo_distance() on production server) Mark Stosberg
- Re: quad or dual core Intel CPUs Kenji Morishige
- Re: reindex vs 'analyze' (was: Re: cube operations slower than geo_distance() on production server) Tom Lane
- Re: Proximity query with GIST and row estimation Guillaume Smet
- Re: Benchmarking PGSQL? Luke Lonergan
- Re: quad or dual core Intel CPUs Claus Guttesen
- Re: reindex vs 'analyze' Mark Stosberg
- Re: JOIN to a VIEW makes a real slow query Chuck D.
- Re: How long should it take to insert 200,000 records? Lou O'Quin
- Re: Proximity query with GIST and row estimation Paul Ramsey
- Re: Benchmarking PGSQL? Josh Berkus
- Re: An unwanted seqscan Brian Herlihy
- Problem with joining queries. Konstantinos Krikellas
- Re: Benchmarking PGSQL? Merlin Moncure
- Re: Problem with joining queries. Richard Huxton
- Re: Problem with joining queries. Konstantinos Krikellas
- Slow query with 'or' clause philippe
- Re: Slow query with 'or' clause Richard Huxton
- Re: Question about Bitmap Heap Scan/BitmapAnd Guillaume Smet
- Re: Proximity query with GIST and row estimation Guillaume Smet
- Re: Question about Bitmap Heap Scan/BitmapAnd Alvaro Herrera
- Re: Question about Bitmap Heap Scan/BitmapAnd Tom Lane
- Re: Slow query with 'or' clause philippe
- strange issue for certain queries Mike Gargano
- Re: Question about Bitmap Heap Scan/BitmapAnd Guillaume Smet
- Re: Question about Bitmap Heap Scan/BitmapAnd Guillaume Smet
- Re: Benchmarking PGSQL? Krishna Kumar
- Not Picking Index Gauri Kanekar
- Re: Not Picking Index Michael Fuhr
- Re: Not Picking Index Gauri Kanekar
- Re: Not Picking Index Alvaro Herrera
- Re: Not Picking Index Tom Lane
- Fwd: Not Picking Index Mike Gargano
- Re: Not Picking Index Brad Nicholson
- Re: Proximity query with GIST and row estimation Guillaume Smet
- Re: Not Picking Index Steinar H. Gunderson
- Re: Not Picking Index George Pavlov
- Re: reindex vs 'analyze' Mark Stosberg
- Re: Not Picking Index Tom Lane
- How to debug performance problems Andreas Tille
- Query Optimization Reinhard Vicinus
- Re: How to debug performance problems Craig A. James
- Re: How to debug performance problems Jeff Davis
- Re: How to debug performance problems Scott Marlowe
- Re: Query Optimization Tom Lane
- slow subselects Marko Niinimaki
- Re: slow subselects ismo.tuononen@solenovo.fi
- Re: slow subselects Tom Lane
- Re: Query Optimization Jim C. Nasby
- SELECT performance problem Glenn Sullivan
- Re: SELECT performance problem Jeff Frost
- Re: SELECT performance problem Dave Dutcher
- Re: slow subselects Marko Niinimaki
- Postgres performance Linux vs FreeBSD Jacek Zaręba
- Re: Postgres performance Linux vs FreeBSD Merlin Moncure
- Re: Postgres performance Linux vs FreeBSD Bill Moran
- Re: How to debug performance problems Ray Stell
- Re: How to debug performance problems Craig A. James
- Re: How to debug performance problems Ray Stell
- Re: How to debug performance problems Mark Stosberg
- How to avoid vacuuming a huge logging table Mark Stosberg
- General advice on user functions Dan Harris
- Auto-Vacuum in 8.1 was ineffective for me. 8.2 may work better? Mark Stosberg
- Re: Auto-Vacuum in 8.1 was ineffective for me. 8.2 may work better? Alvaro Herrera
- Re: How to avoid vacuuming a huge logging table Greg Sabino Mullane
- Re: Postgres performance Linux vs FreeBSD Dimitri Fontaine
- Re: General advice on user functions Merlin Moncure
- Re: General advice on user functions Albert Cervera Areny
- Re: Auto-Vacuum in 8.1 was ineffective for me. 8.2 may work better? Mark Stosberg
- Re: Auto-Vacuum in 8.1 was ineffective for me. 8.2 may work better? Matthew T. O'Connor
- Re: Auto-Vacuum in 8.1 was ineffective for me. 8.2 may work better? Alvaro Herrera
- Re: Postgres performance Linux vs FreeBSD Mark Kirkwood
- Re: General advice on user functions Dan Harris
- Re: How to avoid vacuuming a huge logging table Greg Sabino Mullane
- Re: How to avoid vacuuming a huge logging table D'Arcy J.M. Cain
- Disable result buffering to frontend clients Konstantinos Krikellas
- Re: Disable result buffering to frontend clients Richard Huxton
- slow update on 1M rows (worse with indexes) Gabriel Biberian
- Re: slow update on 1M rows (worse with indexes) Steinar H. Gunderson
- Re: slow update on 1M rows (worse with indexes) Joshua D. Drake
- Vacuum full very slow due to nonremovable dead rows...What makes the dead rows non-removable? Barbara Cosentino
- Re: Vacuum full very slow due to nonremovable dead rows...What makes the dead rows non-removable? Steinar H. Gunderson
- Using the 8.2 autovacuum values with 8.1 Mark Stosberg
- Re: slow update on 1M rows (worse with indexes) ismo.tuononen@solenovo.fi
- Re: Using the 8.2 autovacuum values with 8.1 Csaba Nagy
- Very slow bytea data extraction msmbarabino@virgilio.it
- Re: Very slow bytea data extraction Richard Huxton
- R: Very slow bytea data extraction msmbarabino@virgilio.it
- Re: R: Very slow bytea data extraction Richard Huxton
- Recommended Initial Settings Campbell, Lance
- Re: Recommended Initial Settings Richard Huxton
- Re: R: Very slow bytea data extraction Merlin Moncure
- Re: Recommended Initial Settings Campbell, Lance
- Re: Recommended Initial Settings Richard Huxton
- Re: Using the 8.2 autovacuum values with 8.1 Jim C. Nasby
- Re: Recommended Initial Settings Jim C. Nasby
- Re: Very slow bytea data extraction msmbarabino@virgilio.it
- Re: Very slow bytea data extraction msmbarabino@virgilio.it
- Re: Recommended Initial Settings Bill Moran
- long checkpoint_timeout Jeff Davis
- which Xeon processors don't have the context switching problem Geoffrey
- Re: which Xeon processors don't have the context switching problem Claus Guttesen
- Re: which Xeon processors don't have the context switching problem Steinar H. Gunderson
- Re: which Xeon processors don't have the context switching problem Alvaro Herrera
- Re: which Xeon processors don't have the context switching problem Steinar H. Gunderson
- Re: long checkpoint_timeout Jim C. Nasby
- Re: long checkpoint_timeout Jeff Davis
- Re: which Xeon processors don't have the context switching problem Josh Berkus
- Re: which Xeon processors don't have the context switching problem Geoffrey
- Re: which Xeon processors don't have the context switching problem Joshua D. Drake
- Re: which Xeon processors don't have the context switching problem Geoffrey
- Re: which Xeon processors don't have the context switching problem Guillaume Smet
- Re: which Xeon processors don't have the context switching problem Guillaume Smet
- Re: long checkpoint_timeout Jim C. Nasby
- Re: pg_trgm performance Guillaume Smet
- Re: pg_trgm performance Steinar H. Gunderson
- Re: which Xeon processors don't have the context switching problem Magnus Hagander
- Re: pg_trgm performance Guillaume Smet
- Re: which Xeon processors don't have the context switching problem Geoffrey
- Re: pg_trgm performance Steinar H. Gunderson
- Re: which Xeon processors don't have the context switching problem Joshua D. Drake
- Two hard drives --- what to do with them? Carlos Moreno
- Re: Two hard drives --- what to do with them? Tom Lane
- Re: Two hard drives --- what to do with them? Alexander Staubo
- Re: Two hard drives --- what to do with them? Peter Kovacs
- invalid page header in block 428 of relation "pg_attribute" ashok@kalculate.com
- Re: Very slow bytea data extraction Richard Huxton
- Query Planner Gauri Kanekar
- Re: Query Planner Steinar H. Gunderson
- Re: pg_trgm performance Guillaume Smet
- Re: pg_trgm performance Oleg Bartunov
- Re: pg_trgm performance Guillaume Smet
- Re: pg_trgm performance Oleg Bartunov
- Server Startup Error Gauri Kanekar
- Re: Server Startup Error Rodrigo Gonzalez
- Re: Server Startup Error Gauri Kanekar
- Re: Server Startup Error Richard Huxton
- Re: Server Startup Error Rodrigo Gonzalez
- Re: Server Startup Error Richard Huxton
- Vacuumdb - Max_FSM_Pages Problem. Pallav Kalva
- Re: Vacuumdb - Max_FSM_Pages Problem. Peter Childs
- does prepareThreshold work? forced to use old driver Gene
- Writting a "search engine" for a pgsql DB Madison Kelly
- Re: [JDBC] does prepareThreshold work? forced to use old driver Kris Jurka
- low memory usage reported by 'top' indicates poor tuning? Mark Stosberg
- Re: Writting a "search engine" for a pgsql DB Joshua D. Drake
- Re: low memory usage reported by 'top' indicates poor tuning? Joshua D. Drake
- Re: low memory usage reported by 'top' indicates poor tuning? Mark Stosberg
- Re: [JDBC] does prepareThreshold work? forced to use old driver Dave Cramer
- Re: Writting a "search engine" for a pgsql DB Mark Stosberg
- Re: Writting a "search engine" for a pgsql DB Joshua D. Drake
- Re: [JDBC] does prepareThreshold work? forced to use old driver Gene
- Re: Writting a "search engine" for a pgsql DB Madison Kelly
- Re: Writting a "search engine" for a pgsql DB Magnus Hagander
- Re: Writting a "search engine" for a pgsql DB Mark Stosberg
- Re: Writting a "search engine" for a pgsql DB Madison Kelly
- Re: Writting a "search engine" for a pgsql DB Mark Stosberg
- Re: Writting a "search engine" for a pgsql DB Jeff Davis
- Re: Vacuumdb - Max_FSM_Pages Problem. Ron
- Re: Writting a "search engine" for a pgsql DB Charles Sprickman
- Re: Two hard drives --- what to do with them? Jeff Davis
- Re: Two hard drives --- what to do with them? Peter Kovacs
- Re: Two hard drives --- what to do with them? Jeff Davis
- Re: Two hard drives --- what to do with them? Shane Ambler
- Re: Two hard drives --- what to do with them? Peter Kovacs
- Re: Writting a "search engine" for a pgsql DB Magnus Hagander
- Opinions on Raid Joe Uhl
- Re: Writting a "search engine" for a pgsql DB Dave Page
- Re: Opinions on Raid Stefan Kaltenbrunner
- Re: Two hard drives --- what to do with them? Ben
- Re: Opinions on Raid Ron
- Re: Opinions on Raid mark@mark.mielke.cc
- Re: Opinions on Raid Scott Marlowe
- Re: Postgres performance Linux vs FreeBSD Andrew - Supernews
- [kris@obsecurity.org: Progress on scaling of FreeBSD on 8 CPU systems] Jim C. Nasby
- [kris@obsecurity.org: Anyone interested in improving postgresql scaling?] Jim C. Nasby
- Re: Two hard drives --- what to do with them? Shane Ambler
- Re: [kris@obsecurity.org: Anyone interested in improving postgresql scaling?] Tom Lane
- Re: Opinions on Raid Scott Marlowe
- Re: Two hard drives --- what to do with them? Jeff Davis
- Re: Two hard drives --- what to do with them? Scott Marlowe
- Re: Writting a "search engine" for a pgsql DB Chris
- Re: Writting a "search engine" for a pgsql DB Charles Sprickman
- Re: Opinions on Raid Geoff Tolley
- Re: Writting a "search engine" for a pgsql DB Magnus Hagander
- Re: Writting a "search engine" for a pgsql DB Dave Page
- Re: Writting a "search engine" for a pgsql DB Steinar H. Gunderson
- Re: Writting a "search engine" for a pgsql DB Dave Page
- Re: Writting a "search engine" for a pgsql DB Oleg Bartunov
- Re: Writting a "search engine" for a pgsql DB Dave Page
- Upgraded to 8.2.3 --- still having performance issues Carlos Moreno
- Re: Upgraded to 8.2.3 --- still having performance issues Tom Lane
- Re: Upgraded to 8.2.3 --- still having performance issues Carlos Moreno
- Re: Upgraded to 8.2.3 --- still having performance issues Rodrigo Gonzalez
- Re: Upgraded to 8.2.3 --- still having performance issues Carlos Moreno
- Re: Upgraded to 8.2.3 --- still having performance issues Carlos Moreno