Архив рассылок [pgsql-performance]
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
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
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: Tuning Mischa Sandberg
index scan through a subquery Bill Howe
Re: index scan through a subquery Tom Lane
Re: Tuning Harald Armin Massa
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? Bruno Wolff III
Re: How long should it take to insert 200,000 records? Merlin Moncure
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? Mark Kirkwood
stats collector process high CPU utilization Benjamin Minshall
Re: Speed up this query Mark Stosberg
Disk saturation Carlos H. Reimer
Re: stats collector process high CPU utilization Benjamin Minshall
Re: stats collector process high CPU utilization Benjamin Minshall
Re: stats collector process high CPU utilization Benjamin Minshall
Re: stats collector process high CPU utilization Benjamin Minshall
Re: stats collector process high CPU utilization minshall@intellicon.biz
Re: stats collector process high CPU utilization Alvaro Herrera
Re: stats collector process high CPU utilization Benjamin Minshall
Recreate big table Gábriel Ákos
Re: stats collector process high CPU utilization Benjamin Minshall
Re: Recreate big table Daniel Cristian Cruz
Is there an equivalent for Oracle's user_tables.num_rows Virag Saksena
Re: limit + order by is slow if no rows in result set Heikki Linnakangas
many instances or many databases or many users? ismo.tuononen@solenovo.fi
Re: many instances or many databases or many users? Heikki Linnakangas
Question about Bitmap Heap Scan/BitmapAnd Guillaume Smet
Proximity query with GIST and row estimation Guillaume Smet
Re: Question about Bitmap Heap Scan/BitmapAnd Guillaume Smet
CPU Usage Campbell, Lance
Re: CPU Usage Alan Hodgson
Re: JOIN to a VIEW makes a real slow query Merlin Moncure
quad or dual core Intel CPUs Kenji Morishige
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
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: 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: 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: 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
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? Matthew T. O'Connor
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
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 Steinar H. Gunderson
Re: long checkpoint_timeout Jim C. Nasby
Re: long checkpoint_timeout Jeff Davis
Re: long checkpoint_timeout Jim C. Nasby
Re: pg_trgm performance Guillaume Smet
Re: pg_trgm performance Steinar H. Gunderson
Re: pg_trgm performance Guillaume Smet
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
Writting a "search engine" for a pgsql DB Madison Kelly
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: Writting a "search engine" for a pgsql DB Mark Stosberg
Re: Writting a "search engine" for a pgsql DB Joshua D. Drake
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 Charles Sprickman
Re: Two hard drives --- what to do with them? Peter Kovacs
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: Opinions on Raid Stefan Kaltenbrunner
Re: Opinions on Raid mark@mark.mielke.cc
Re: Opinions on Raid Scott Marlowe
Re: Postgres performance Linux vs FreeBSD Andrew - Supernews
Re: Two hard drives --- what to do with them? Shane Ambler
Re: Opinions on Raid Scott Marlowe
Re: Two hard drives --- what to do with them? Scott Marlowe
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 Steinar H. Gunderson
Re: Writting a "search engine" for a pgsql DB Oleg Bartunov
Upgraded to 8.2.3 --- still having performance issues Carlos Moreno
Re: Upgraded to 8.2.3 --- still having performance issues Rodrigo Gonzalez
Re: Two hard drives --- what to do with them? Bruno Wolff III
Re: Two hard drives --- what to do with them? Bruno Wolff III
Re: Two hard drives --- what to do with them? Bruno Wolff III
