Mailing lists [pgsql-performance]
- Re: Help w/speeding up range queries? Tom Lane
- Re: Help w/speeding up range queries? Luke Lonergan
- Re: pg_trgm indexes giving bad estimations? Ben
- Re: Help w/speeding up range queries? Tom Lane
- Re: pg_trgm indexes giving bad estimations? Tom Lane
- big transaction slows down over time - but disk seems almost unused Ben
- Re: big transaction slows down over time - but disk seems Heikki Linnakangas
- Re: big transaction slows down over time - but disk seems almost unused Ben
- Re: big transaction slows down over time - but disk Andreas Kostyrka
- Re: MVCC & indexes? Ivan Voras
- Re: big transaction slows down over time - but disk seems Richard Huxton
- Re: big transaction slows down over time - but disk seems almost unused Ben
- Re: big transaction slows down over time - but disk seems Ben
- Re: big transaction slows down over time - but disk seems Richard Huxton
- Database-wide vacuum can take a long time, during which tables are not being analyzed Steven Flatt
- Re: Database-wide vacuum can take a long time, during which Matthew O'Connor
- Re: Database-wide vacuum can take a long time, duringwhich tables are not being analyzed Simon Riggs
- Re: Help w/speeding up range queries? Marcin Mank
- Re: Help w/speeding up range queries? Simon Riggs
- Query plan for "heavy" SELECT with "lite" sub-SELECTs Nikolay Samokhvalov
- Re: Query plan for "heavy" SELECT with "lite" sub-SELECTs Richard Huxton
- Locking vs. Exceptions Robins
- Re: Query plan for "heavy" SELECT with "lite" sub-SELECTs Dave Dutcher
- Setting "nice" values Madison Kelly
- Re: Database-wide vacuum can take a long time, duringwhich tables are not being analyzed Steven Flatt
- Re: Setting "nice" values Scott Marlowe
- Re: Setting "nice" values Madison Kelly
- Re: Setting "nice" values Scott Marlowe
- Re: Database-wide vacuum can take a long time, duringwhich tables are not being analyzed Alvaro Herrera
- Re: Setting "nice" values Tobias Brox
- Re: Query plan for "heavy" SELECT with "lite" sub-SELECTs Alvaro Herrera
- Re: VACUUMs take twice as long across all nodes Vivek Khera
- Re: Locking vs. Exceptions Benjamin Minshall
- Re: Query plan for "heavy" SELECT with "lite" sub-SELECTs Arjen van der Meijden
- profiling PL/pgSQL? Drew Wilson
- Re: profiling PL/pgSQL? A. Kretschmer
- Re: profiling PL/pgSQL? Richard Huxton
- Context switch storm creimer@brturbo.com.br
- Re: Context switch storm Gregory S. Williamson
- Re: Context switch storm Richard Huxton
- Re: Context switch storm Richard Huxton
- Re: Setting "nice" values Andreas Kostyrka
- Re: Context switch storm Andreas Kostyrka
- Re: Context switch storm Richard Troy
- Re: Context switch storm Richard Huxton
- Re: Context switch storm Cosimo Streppone
- Re: Context switch storm creimer@brturbo.com.br
- Re: Context switch storm Richard Huxton
- Re: Query plan for "heavy" SELECT with "lite" sub-SELECTs Tom Lane
- Re: profiling PL/pgSQL? Jonah H. Harris
- Re: Context switch storm Tom Lane
- Re: Context switch storm Andreas Kostyrka
- EXISTS optimization Kevin Grittner
- Re: Slow functional indexes? Stuart Bishop
- Re: Slow functional indexes? Tom Lane
- Re: Slow functional indexes? Gene
- Re: Setting "nice" values Jim Nasby
- Re: Setting "nice" values Madison Kelly
- Re: Setting "nice" values Madison Kelly
- Re: Setting "nice" values Madison Kelly
- Re: Setting "nice" values Tobias Brox
- Re: Setting "nice" values Madison Kelly
- Yet another question on LIMIT performance :/ Hannes Dorbath
- Re: Setting "nice" values Tobias Brox
- Re: Yet another question on LIMIT performance :/ Heikki Linnakangas
- Re: Yet another question on LIMIT performance :/ Hannes Dorbath
- Re: Setting "nice" values Madison Kelly
- Re: Yet another question on LIMIT performance :/ Tom Lane
- Context switching Carlos H. Reimer
- Re: profiling PL/pgSQL?
- RES: Context switching Carlos H. Reimer
- Easy read-heavy benchmark kicking around? Brian Hurt
- Re: Easy read-heavy benchmark kicking around? Luke Lonergan
- Re: Easy read-heavy benchmark kicking around? Merlin Moncure
- Re: Easy read-heavy benchmark kicking around? Scott Marlowe
- Re: Context switch storm Cosimo Streppone
- Re: Help w/speeding up range queries? Jim Nasby
- Re: Easy read-heavy benchmark kicking around? Mark Kirkwood
- Re: Easy read-heavy benchmark kicking around? Dimitri Fontaine
- Re: Context switching Josh Berkus
- Re: Easy read-heavy benchmark kicking around? Markus Schaber
- Re: Easy read-heavy benchmark kicking around? Merlin Moncure
- Re: Easy read-heavy benchmark kicking around? Cosimo Streppone
- Re: Which OS provides the _fastest_ PostgreSQL performance? Ron Mayer
- Re: Easy read-heavy benchmark kicking around? Luke Lonergan
- Keeping processes open for re-use Hilary Forbes
- Re: Keeping processes open for re-use Csaba Nagy
- Re: Easy read-heavy benchmark kicking around? Merlin Moncure
- Re: Keeping processes open for re-use imad
- Re: Keeping processes open for re-use Shane Ambler
- Re: Keeping processes open for re-use Joshua D. Drake
- 10x rowcount mis-estimation favouring merge over nestloop Abhijit Menon-Sen
- Re: 10x rowcount mis-estimation favouring merge over nestloop Tom Lane
- Re: 10x rowcount mis-estimation favouring merge over nestloop Abhijit Menon-Sen
- Lying drives [Was: Re: Which OS provides the _fastest_ PostgreSQL performance?] Ron Mayer
- Re: [BUGS] BUG #2737: hash indexing large table fails, while btree of same index works Tom Lane
- Re: Context switch storm Cosimo Streppone
- Re: Context switch storm Andreas Kostyrka
- Re: Context switch storm Merlin Moncure
- Re: Context switch storm Jim C. Nasby
- Re: Context switch storm Bucky Jordan
- Re: Context switch storm Merlin Moncure
- Re: Context switch storm Cosimo Streppone
- Re: Context switch storm Simon Riggs
- Slow SELECT on three or more clients AMIR FRANCO D. JOVEN
- Re: Slow SELECT on three or more clients Andreas Kostyrka
- Re: Slow SELECT on three or more clients Russell Smith
- Re: Slow SELECT on three or more clients Gregory S. Williamson
- Re: Slow SELECT on three or more clients Merlin Moncure
- Re: Slow SELECT on three or more clients Markus Schaber
- Hundreds of database and FSM Craig A. James
- Re: Hundreds of database and FSM Alvaro Herrera
- Re: Hundreds of database and FSM Steinar H. Gunderson
- Postgres server crash Craig A. James
- Re: Postgres server crash Russell Smith
- Re: Slow SELECT on three or more clients AMIR FRANCO D. JOVEN
- Re: Postgres server crash Richard Huxton
- Re: Postgres server crash Craig A. James
- Re: Postgres server crash Richard Huxton
- Re: Postgres server crash Craig A. James
- Re: Postgres server crash Richard Huxton
- Re: Keeping processes open for re-use Jean-Max Reymond
- Re: Postgres server crash Tom Lane
- Re: Postgres server crash Tom Lane
- Re: Postgres server crash Richard Huxton
- Re: Postgres server crash Merlin Moncure
- Re: Postgres server crash Ben
- Re: Context switch storm Jim Nasby
- Re: [BUGS] BUG #2737: hash indexing large table fails,while btree of same index works Tom Lane
- Re: [BUGS] BUG #2737: hash indexing large tablefails,while btree of same index works Simon Riggs
- Re: Keeping processes open for re-use Richard Huxton
- Re: [BUGS] BUG #2737: hash indexing largetablefails,while btree of same index works Simon Riggs
- Re: [BUGS] BUG #2737: hash indexing large tablefails,while btree of same index works Tom Lane
- Re: [BUGS] BUG #2737: hash indexing large tablefails,while Julius.Stroffek
- availability of SATA vendors Jeff Frost
- Re: Optimicing Postgres for SunSolaris10 on V240 Josh Berkus
- shared_buffers > 284263 on OS X Brian Wipf
- Re: availability of SATA vendors Arjen van der Meijden
- Re: availability of SATA vendors Ron
- Re: availability of SATA vendors Steve Atkins
- Re: availability of SATA vendors Luke Lonergan
- start up cost estimate rakesh kumar
- Re: Optimicing Postgres for SunSolaris10 on V240 Marc Cousin
- Re: start up cost estimate Joshua Marsh
- Re: shared_buffers > 284263 on OS X Dave Cramer
- Re: start up cost estimate Tom Lane
- Re: shared_buffers > 284263 on OS X Tom Lane
- Re: shared_buffers > 284263 on OS X lists@event-s.net (Guido Neitzer)
- Re: shared_buffers > 284263 on OS X Guido Neitzer
- Re: Postgres server crash Richard Troy
- Re: shared_buffers > 284263 on OS X Brian Wipf
- Fwd: start up cost estimate rakesh kumar
- Re: Postgres server crash Craig A. James
- Re: Postgres server crash Tom Lane
- Re: shared_buffers > 284263 on OS X Guido Neitzer
- Re: Postgres server crash Ron Mayer
- Re: Postgres server crash Ron Mayer
- Re: Postgres server crash Michael Stone
- Re: Postgres server crash Richard Broersma Jr
- Re: Postgres server crash Michael Stone
- Re: Postgres server crash Craig A. James
- PostgreSQL with 64 bit was: Re: shared_buffers > 284263 on OS X Guido Neitzer
- Re: Postgres server crash Michael Stone
- Re: Postgres server crash Craig A. James
- Re: Postgres server crash Bruno Wolff III
- Re: Postgres server crash Craig A. James
- Re: Postgres server crash Mattias Kregert
- Re: Postgres server crash Markus Schaber
- BitMapScan performance degradation Jérôme BENOIS
- RES: Context switching Carlos H. Reimer
- Re: BitMapScan performance degradation Tom Lane
- Re: BitMapScan performance degradation db@zigo.dhs.org
- Re: BitMapScan performance degradation Jérôme BENOIS
- Slow Query Joe Lester
- Re: Slow Query Joe Lester
- Re: availability of SATA vendors Jeff Frost
- Priority to a mission critical transaction Carlos H. Reimer
- Re: availability of SATA vendors Joshua D. Drake
- Re: availability of SATA vendors Jeff Frost
- Re: availability of SATA vendors Joshua D. Drake
- PostgreSQL underestimates sorting Markus Schaber
- Re: PostgreSQL underestimates sorting Steinar H. Gunderson
- Re: availability of SATA vendors Bucky Jordan
- Re: PostgreSQL underestimates sorting Markus Schaber
- Re: availability of SATA vendors Jeff Frost
- Re: PostgreSQL underestimates sorting Markus Schaber
- Re: availability of SATA vendors Joshua D. Drake
- Re: availability of SATA vendors Jeff Frost
- Re: availability of SATA vendors Arjen van der Meijden
- Re: availability of SATA vendors Joshua D. Drake
- Re: PostgreSQL underestimates sorting Frank Wiles
- Re: availability of SATA vendors Scott Marlowe
- Re: availability of SATA vendors Bucky Jordan
- Re: availability of SATA vendors Luke Lonergan
- Direct I/O issues Greg Smith
- Re: Lying drives [Was: Re: Which OS provides the _fastest_ Greg Smith
- Re: availability of SATA vendors Arjen van der Meijden
- Re: PostgreSQL underestimates sorting Simon Riggs
- Re: Lying drives [Was: Re: Which OS provides the Bruce Momjian
- Re: Direct I/O issues Tom Lane
- Re: Direct I/O issues Greg Smith
- Re: Priority to a mission critical transaction Brad Nicholson
- Postgres scalability and performance on windows Gopal
- Re: Postgres scalability and performance on windows Heikki Linnakangas
- Re: Direct I/O issues Bruce Momjian
- Re: Postgres scalability and performance on windows Guido Neitzer
- Re: Postgres scalability and performance on windows Gopal
- TPC-H Benchmark Felipe Rondon Rocha
- Re: TPC-H Benchmark Luke Lonergan
- Re: Postgres scalability and performance on windows Frank Wiles
- Massive delete of rows, how to proceed? Arnau
- Re: Postgres scalability and performance on windows Tom Lane
- Massive delete of rows, how to proceed? Peter Childs
- Re: Massive delete of rows, how to proceed? andrew@pillette.com
- When to vacuum a table? Joost Kraaijeveld
- Re: When to vacuum a table? Marcelo Costa
- Re: When to vacuum a table? Steinar H. Gunderson
- Re: When to vacuum a table? Marcelo Costa
- Re: When to vacuum a table? Rod Taylor
- Re: When to vacuum a table? Andrew Sullivan
- Re: When to vacuum a table? Craig A. James
- Re: When to vacuum a table? Tom Lane
- Re: When to vacuum a table? Joshua D. Drake
- Re: shared_buffers > 284263 on OS X Jim C. Nasby
- Re: availability of SATA vendors Jim C. Nasby
- Re: availability of SATA vendors Jim C. Nasby
- Re: Postgres server crash Jim C. Nasby
- Re: Priority to a mission critical transaction Jim C. Nasby
- Re: When to vacuum a table? Jim C. Nasby
- Re: shared_buffers > 284263 on OS X Brendan Duddridge
- Re: shared_buffers > 284263 on OS X Tom Lane
- Re: shared_buffers > 284263 on OS X Brian Wipf
- Re: shared_buffers > 284263 on OS X Guido Neitzer
- Re: shared_buffers > 284263 on OS X Guido Neitzer
- Re: shared_buffers > 284263 on OS X Brian Wipf
- Re: shared_buffers > 284263 on OS X Guido Neitzer
- Plattform comparison (lies, damn lies and benchmarks) Guido Neitzer
- Re: Massive delete of rows, how to proceed? Merlin Moncure
- Re: shared_buffers > 284263 on OS X Jim C. Nasby
- Re: Postgres server crash Michael Stone
- Re: shared_buffers > 284263 on OS X AgentM
- Re: shared_buffers > 284263 on OS X Guido Neitzer
- Re: Postgres server crash Florian Weimer
- Re: When to vacuum a table? Kevin Grittner
- Re: BUG #2784: Performance serious degrades over a period of a month Bruno Wolff III
- Re: BUG #2784: Performance serious degrades over a period Bill Moran
- Re: Postgres scalability and performance on windows Gopal
- Re: Postgres scalability and performance on windows Tom Lane
- Re: Postgres scalability and performance on windows J. Andrew Rogers
- RES: Priority to a mission critical transaction Carlos H. Reimer
- Re: RES: Priority to a mission critical transaction Tom Lane
- Re: RES: Priority to a mission critical transaction Andreas Kostyrka
- Re: RES: Priority to a mission critical transaction Josh Berkus
- Re: RES: Priority to a mission critical transaction Ron Mayer
- Re: RES: Priority to a mission critical transaction Bruce Momjian
- Re: RES: Priority to a mission critical transaction Ron Mayer
- Re: RES: Priority to a mission critical transaction Mark Kirkwood
- Re: RES: Priority to a mission critical transaction Mark Kirkwood
- Re: RES: Priority to a mission critical transaction Ron Mayer
- NAMEDATALEN and performance Alessandro Baretta
- Re: RES: Priority to a mission critical transaction Brian Hurt
- Re: RES: Priority to a mission critical transaction Mark Lewis
- Re: RES: Priority to a mission critical transaction Brian Hurt
- Re: NAMEDATALEN and performance Tom Lane
- Re: RES: Priority to a mission critical transaction Ron Mayer
- Re: RES: Priority to a mission critical transaction Brian Hurt
- OT - how to size/match multiple databases/apps for a single server Kevin Kempter
- Re: RES: Priority to a mission critical transaction Ron Mayer
- Fw: [GENERAL] Including unique users in huge data warehouse in Postgresql... Mark Jensen
- Re: Fw: [GENERAL] Including unique users in huge data Luke Lonergan
- Re: RES: Priority to a mission critical transaction Josh Berkus
- Defining performance. Paul Lathrop
- Re: Defining performance. Tobias Brox
- Re: Defining performance. Tom Lane
- Re: Defining performance. Scott Marlowe
- Bad iostat numbers Carlos H. Reimer
- Re: Defining performance. Jeff Davis