Mailing lists [pgsql-performance]
- Re: Hardware for PostgreSQL Ericson Smith
- Re: Hardware for PostgreSQL Ow Mun Heng
- Re: Hardware for PostgreSQL Magnus Hagander
- Re: Hardware for PostgreSQL Magnus Hagander
- Re: hardware and For PostgreSQL Magnus Hagander
- Re: Hardware for PostgreSQL Ow Mun Heng
- Re: Hardware for PostgreSQL Magnus Hagander
- Re: hardware and For PostgreSQL Joe Uhl
- Re: Hardware for PostgreSQL Adam Tauno Williams
- select max(field) from table much faster with a group by clause? Palle Girgensohn
- Re: [Fwd: Re: Outer joins and Seq scans] Tom Lane
- Re: select max(field) from table much faster with a group by clause? Tom Lane
- Re: select max(field) from table much faster with a group by clause? Palle Girgensohn
- Re: [Fwd: Re: Outer joins and Seq scans] Sami Dalouche
- Re: select max(field) from table much faster with a group by clause? Palle Girgensohn
- Re: select max(field) from table much faster with a group by clause? Tom Lane
- Re: select max(field) from table much faster with a group by clause? Palle Girgensohn
- Re: select max(field) from table much faster with a group by clause? Scott Marlowe
- Re: select max(field) from table much faster with a group by clause? Tom Lane
- Re: select max(field) from table much faster with a group by clause? Gregory Stark
- Re: Hardware for PostgreSQL Steve Crawford
- Re: Hardware for PostgreSQL Steve Crawford
- How to avoid hashjoin and mergejoin Carlo Stonebanks
- Re: How to avoid hashjoin and mergejoin Scott Marlowe
- Re: How to avoid hashjoin and mergejoin Tom Lane
- Re: Hardware for PostgreSQL Ow Mun Heng
- hardware for PostgreSQL Mark Floyd
- Re: hardware for PostgreSQL Scott Marlowe
- Re: How to avoid hashjoin and mergejoin Carlo Stonebanks
- Re: select max(field) from table much faster with a group by clause? hubert depesz lubaczewski
- Unfortunate expansion of composite types in union Jens-Wolfhard Schicke
- Re: Unfortunate expansion of composite types in union Pavel Stehule
- Re: select max(field) from table much faster with a group by clause? Palle Girgensohn
- Re: Hardware for PostgreSQL Jurgen Haan
- Mark F
- Re: Hardware for PostgreSQL (RAID configurations) Mark F
- Re: [Fwd: Re: Outer joins and Seq scans] Alvaro Herrera
- Union within View vs.Union of Views Jeff Larsen
- Re: Union within View vs.Union of Views Mark Mielke
- Re: Union within View vs.Union of Views Heikki Linnakangas
- "MixedCase sensitive quoted" names Whatever Deep
- Re: Union within View vs.Union of Views Tom Lane
- Re: "MixedCase sensitive quoted" names Tom Lane
- Re: Union within View vs.Union of Views Jeff Larsen
- Re: Union within View vs.Union of Views Jeff Larsen
- Postgresql.conf Settings smiley2211
- Re: Unfortunate expansion of composite types in union Jens-Wolfhard Schicke
- Re: Postgresql.conf Settings Scott Marlowe
- Re: Postgresql.conf Settings smiley2211
- Re: Postgresql.conf Settings Heikki Linnakangas
- Migrating to 8.3 - checkpoints and background writer Greg Smith
- Re: Migrating to 8.3 - checkpoints and background writer Steinar H. Gunderson
- Re: Migrating to 8.3 - checkpoints and background writer Greg Smith
- Re: partitioned table and ORDER BY indexed_field DESC LIMIT 1 Mark Kirkwood
- Re: partitioned table and ORDER BY indexed_field DESC LIMIT 1 Gregory Stark
- hp ciss on freebsd Claus Guttesen
- Database connections and stored procs (functions) Radhika S
- Re: hp ciss on freebsd Jeff Trout
- Re: hp ciss on freebsd Greg Smith
- index stat Campbell, Lance
- Training Recommendations Campbell, Lance
- Re: Migrating to 8.3 - checkpoints and background writer Erik Jones
- Which index methodology is better?- Chris Hoover
- Re: Which index methodology is better?- Tom Lane
- Re: Which index methodology is better?- Heikki Linnakangas
- Re: Database connections and stored procs (functions) Merlin Moncure
- Is ANALYZE transactional? Craig James
- Re: Is ANALYZE transactional? Tom Lane
- dell versus hp Tore Halset
- Re: dell versus hp Claus Guttesen
- Re: dell versus hp Dimitri Fontaine
- Re: dell versus hp Stephen Frost
- Re: dell versus hp Tore Halset
- Re: dell versus hp Tore Halset
- Re: dell versus hp Dimitri Fontaine
- Re: dell versus hp Greg Smith
- Subpar Execution Plan Jens-Wolfhard Schicke
- Estimation problem with a LIKE clause containing a / Guillaume Smet
- Re: Estimation problem with a LIKE clause containing a / Alexander Staubo
- Re: Estimation problem with a LIKE clause containing a / Guillaume Smet
- Re: index stat Kevin Grittner
- Re: Estimation problem with a LIKE clause containing a / Tom Lane
- Re: Estimation problem with a LIKE clause containing a / Guillaume Smet
- Re: Estimation problem with a LIKE clause containing a / Tom Lane
- Re: Estimation problem with a LIKE clause containing a / Tom Lane
- Re: Estimation problem with a LIKE clause containing a / Guillaume Smet
- Re: Estimation problem with a LIKE clause containing a / Guillaume Smet
- Re: partitioned table and ORDER BY indexed_field DESC LIMIT 1 Mark Kirkwood
- Re: partitioned table and ORDER BY indexed_field DESC LIMIT 1 Luke Lonergan
- Re: partitioned table and ORDER BY indexed_field DESC LIMIT 1 Gregory Stark
- Re: partitioned table and ORDER BY indexed_field DESC LIMIT 1 Mark Kirkwood
- Re: Estimation problem with a LIKE clause containing a / Guillaume Smet
- Need to run CLUSTER to keep performance Rafael Martinez
- Re: Need to run CLUSTER to keep performance Heikki Linnakangas
- Re: Need to run CLUSTER to keep performance Tomáš Vondra
- Re: Need to run CLUSTER to keep performance Rafael Martinez
- Re: Need to run CLUSTER to keep performance Alvaro Herrera
- Re: Estimation problem with a LIKE clause containing a / Tom Lane
- Re: Need to run CLUSTER to keep performance Heikki Linnakangas
- Re: Need to run CLUSTER to keep performance Rafael Martinez
- Re: Need to run CLUSTER to keep performance Bill Moran
- Re: Need to run CLUSTER to keep performance Rafael Martinez
- Re: Estimation problem with a LIKE clause containing a / Guillaume Smet
- Re: Need to run CLUSTER to keep performance Tom Lane
- Re: hp ciss on freebsd Vivek Khera
- Re: dell versus hp Vivek Khera
- Re: Need to run CLUSTER to keep performance Chris Browne
- Re: dell versus hp Vivek Khera
- Re: Estimation problem with a LIKE clause containing a / Tom Lane
- Re: dell versus hp Scott Marlowe
- Re: dell versus hp Dimitri Fontaine
- Re: dell versus hp Kevin Grittner
- Re: dell versus hp Alan Hodgson
- Re: dell versus hp Vivek Khera
- Join performance Pepe Barbe
- Re: Join performance Steinar H. Gunderson
- Re: Estimation problem with a LIKE clause containing a / Gregory Stark
- Re: dell versus hp Scott Marlowe
- Re: Join performance Tom Lane
- Re: Join performance Tom Lane
- Re: Join performance Tom Lane
- Re: Join performance Tom Lane
- Re: Estimation problem with a LIKE clause containing a / Tom Lane
- Re: Join performance Tom Lane
- Re: [HACKERS] Estimation problem with a LIKE clause containing a / Tom Lane
- Re: Hardware for PostgreSQL Robert Treat
- Re: How to avoid hashjoin and mergejoin Carlo Stonebanks
- Help understanding stat numbers Chris Hoover
- Re: Help understanding stat numbers Tom Lane
- Re: [HACKERS] Estimation problem with a LIKE clause containing a / Guillaume Smet
- Re: [HACKERS] Estimation problem with a LIKE clause containing a / Gregory Stark
- Re: dell versus hp Florian Weimer
- PostgreSQL vs MySQL, and FreeBSD Ivan Voras
- Re: PostgreSQL vs MySQL, and FreeBSD Jonah H. Harris
- Re: PostgreSQL vs MySQL, and FreeBSD Sebastian Hennebrueder
- Re: PostgreSQL vs MySQL, and FreeBSD Erik Jones
- Re: PostgreSQL vs MySQL, and FreeBSD Scott Marlowe
- Re: dell versus hp Jurgen Haan
- Re: PostgreSQL vs MySQL, and FreeBSD Greg Smith
- Re: [HACKERS] Estimation problem with a LIKE clause containing a / Tom Lane
- Re: [HACKERS] Estimation problem with a LIKE clause containing a / Guillaume Smet
- Re: dell versus hp Claus Guttesen
- Re: dell versus hp Scott Marlowe
- work_mem and shared_buffers Campbell, Lance
- Re: work_mem and shared_buffers Heikki Linnakangas
- Re: PostgreSQL vs MySQL, and FreeBSD Bill Moran
- Re: dell versus hp Greg Smith
- Re: work_mem and shared_buffers Campbell, Lance
- Re: work_mem and shared_buffers Bill Moran
- Re: work_mem and shared_buffers Campbell, Lance
- Re: dell versus hp Vivek Khera
- Re: work_mem and shared_buffers Scott Marlowe
- Re: work_mem and shared_buffers Campbell, Lance
- Re: work_mem and shared_buffers Scott Marlowe
- Re: PostgreSQL vs MySQL, and FreeBSD Ron Mayer
- Re: work_mem and shared_buffers Erik Jones
- Re: work_mem and shared_buffers Scott Marlowe
- Re: [HACKERS] Estimation problem with a LIKE clause containing a / Guillaume Smet
- Can I Determine if AutoVacuum Does Anything? David Crane
- Re: Can I Determine if AutoVacuum Does Anything? Alvaro Herrera
- Re: Join performance Russell Smith
- Curious about dead rows. Jean-David Beyer
- Re: Curious about dead rows. Tom Lane
- Re: Curious about dead rows. Jean-David Beyer
- Re: Curious about dead rows. Joshua D. Drake
- Re: Curious about dead rows. Jean-David Beyer
- Re: Curious about dead rows. Scott Marlowe
- Re: Curious about dead rows. Jean-David Beyer
- Re: PostgreSQL vs MySQL, and FreeBSD Dimitri
- Re: PostgreSQL vs MySQL, and FreeBSD Joshua D. Drake
- Re: PostgreSQL vs MySQL, and FreeBSD Steinar H. Gunderson
- Re: work_mem and shared_buffers Cédric Villemain
- Re: PostgreSQL vs MySQL, and FreeBSD Shane Ambler
- difference between a unique constraint and a unique index ??? Dave Cramer
- Re: difference between a unique constraint and a unique index ??? Alvaro Herrera
- Re: difference between a unique constraint and a unique index ??? Dave Cramer
- Re: PostgreSQL vs MySQL, and FreeBSD Erik Jones
- Re: Need to run CLUSTER to keep performance Rafael Martinez
- Re: Need to run CLUSTER to keep performance Rafael Martinez
- Re: Need to run CLUSTER to keep performance Heikki Linnakangas
- Re: Curious about dead rows. Andrew Sullivan
- Re: Need to run CLUSTER to keep performance Scott Marlowe
- Re: Need to run CLUSTER to keep performance Bill Moran
- Re: difference between a unique constraint and a unique index ??? Tom Lane
- Re: Need to run CLUSTER to keep performance Heikki Linnakangas
- Re: Need to run CLUSTER to keep performance Scott Marlowe
- Re: Need to run CLUSTER to keep performance Heikki Linnakangas
- Re: difference between a unique constraint and a unique index ??? Dave Cramer
- ERROR: "invalid memory alloc request size" or "unexpected end of data" on large table Stephane Bailliez
- Re: ERROR: "invalid memory alloc request size" or "unexpected end of data" on large table Tom Lane
- Re: Need to run CLUSTER to keep performance Rafael Martinez
- Re: Need to run CLUSTER to keep performance Rafael Martinez
- random_page_cost etc. per tablespace? Jens-Wolfhard Schicke
- Re: ERROR: "invalid memory alloc request size" or "unexpected end of data" on large table Stephane Bailliez
- Re: Curious about dead rows. Andrew Sullivan
- Re: dell versus hp Alan Hodgson
- Re: Curious about dead rows. Jean-David Beyer
- Re: dell versus hp Jeff Frost
- Re: Curious about dead rows. Andrew Sullivan
- Re: Curious about dead rows. Andrew Sullivan
- Re: Curious about dead rows. Jean-David Beyer
- Re: Curious about dead rows. Alvaro Herrera
- Re: Curious about dead rows. Trevor Talbot
- Re: Curious about dead rows. Alvaro Herrera
- Re: Curious about dead rows. Ansgar -59cobalt- Wiechers
- Re: Curious about dead rows. Merlin Moncure
- Re: Curious about dead rows. Jean-David Beyer
- Re: dell versus hp Merlin Moncure
- Re: Curious about dead rows. Merlin Moncure
- Re: Curious about dead rows. Jean-David Beyer
- Re: Curious about dead rows. Alvaro Herrera
- Re: Curious about dead rows. Jean-David Beyer
- Re: Curious about dead rows. Andrew Sullivan
- Re: Curious about dead rows. Jean-David Beyer
- Re: Curious about dead rows. Andrew Sullivan
- Re: Curious about dead rows. Andrew Sullivan
- Re: Curious about dead rows. Jean-David Beyer
- Re: Curious about dead rows. Mario Weilguni
- Re: Curious about dead rows. Jean-David Beyer
- Re: Curious about dead rows. Alvaro Herrera
- Re: Curious about dead rows. Russell Smith
- Re: Curious about dead rows. Jean-David Beyer
- Re: dell versus hp Alan Hodgson
- Re: dell versus hp Jeff Frost
- Re: dell versus hp Alan Hodgson
- Re: Curious about dead rows. Tom Lane
- Re: dell versus hp Merlin Moncure
- Re: dell versus hp Jeff Frost
- Re: Curious about dead rows. Craig James
- Re: Curious about dead rows. Jean-David Beyer
- Re: Curious about dead rows. Jean-David Beyer
- Re: dell versus hp Jeff Trout
- Re: Curious about dead rows. Erik Jones
- Re: dell versus hp Vivek Khera
- Re: [HACKERS] 8.3beta1 testing on Solaris Bruce Momjian
- autovacuum: recommended? Gábor Farkas
- Re: PostgreSQL vs MySQL, and FreeBSD Ow Mun Heng
- Re: autovacuum: recommended? hubert depesz lubaczewski
- Re: autovacuum: recommended? Tobias Brox
- Re: autovacuum: recommended? Csaba Nagy
- Re: autovacuum: recommended? tv@fuzzy.cz
- Re: PostgreSQL vs MySQL, and FreeBSD Dave Dutcher
- Re: Curious about dead rows. Brad Nicholson
- Re: PostgreSQL vs MySQL, and FreeBSD Jonah H. Harris
- Clustered/covering indexes (or lack thereof :-) adrobj
- Re: PostgreSQL vs MySQL, and FreeBSD Ivan Voras
- Re: Clustered/covering indexes (or lack thereof :-) Heikki Linnakangas
- Re: Clustered/covering indexes (or lack thereof :-) Jeff Davis
- Re: Clustered/covering indexes (or lack thereof :-) Bill Moran
- Re: PostgreSQL vs MySQL, and FreeBSD Josh Trutwin
- Re: PostgreSQL vs MySQL, and FreeBSD Jonah H. Harris
- Re: Curious about dead rows. Merlin Moncure
- Re: Curious about dead rows. Kevin Grittner
- Performance problem (outer join + view + non-strict functions) Dean Rasheed
- Re: work_mem and shared_buffers Simon Riggs
- Re: work_mem and shared_buffers Scott Marlowe
- Re: Performance problem (outer join + view + non-strict functions) Tom Lane
- Re: autovacuum: recommended? Tobias Brox
- Re: autovacuum: recommended? gabor
- RE: Performance problem (outer join + view + non-strict functions) Dean Rasheed
- Re: PostgreSQL vs MySQL, and FreeBSD Ow Mun Heng
- Re: autovacuum: recommended? Decibel!
- Re: autovacuum: recommended? Decibel!
- Re: autovacuum: recommended? Decibel!
- Re: autovacuum: recommended? tv@fuzzy.cz
- Re: autovacuum: recommended? Jean-David Beyer
- Re: autovacuum: recommended? Bill Moran
- Re: autovacuum: recommended? Tom Lane
- Re: autovacuum: recommended? Jean-David Beyer
- Re: autovacuum: recommended? Joshua D. Drake
- Re: autovacuum: recommended? Greg Smith
- Postgres ignoring index when using left outer join. Matthew Schumacher
- tuning for TPC-C benchmark giuseppe-r@tiscali.it
- Re: tuning for TPC-C benchmark Bill Moran
- Re: tuning for TPC-C benchmark Jonah H. Harris
- Re: tuning for TPC-C benchmark Kevin Grittner
- Re: tuning for TPC-C benchmark Jonah H. Harris
- Re: tuning for TPC-C benchmark Heikki Linnakangas
- Performance problem with UNION ALL view and domains Dean Rasheed
- Re: Performance problem with UNION ALL view and domains Jeff Larsen
- Re: Performance problem with UNION ALL view and domains Tom Lane
- Problems with PostGreSQL and Windows 2003 claudia.amorim@pcinformatica.com.br
- Re: Problems with PostGreSQL and Windows 2003 Heikki Linnakangas
- Re: Problems with PostGreSQL and Windows 2003 claudia.amorim@pcinformatica.com.br
- Re: Performance problem with UNION ALL view and domains Dean Rasheed
- Re: Problems with PostGreSQL and Windows 2003 claudia.amorim@pcinformatica.com.br
- Re: Problems with PostGreSQL and Windows 2003 Scott Marlowe
- Re: Problems with PostGreSQL and Windows 2003 claudia.amorim@pcinformatica.com.br
- Re: Problems with PostGreSQL and Windows 2003 Scott Marlowe
- Re: Problems with PostGreSQL and Windows 2003 claudia.amorim@pcinformatica.com.br
- doubt with pg_dump and high concurrent used databases Pablo Alcaraz
- Re: doubt with pg_dump and high concurrent used databases Heikki Linnakangas
- Re: doubt with pg_dump and high concurrent used databases Erik Jones
- Re: doubt with pg_dump and high concurrent used databases Peter Childs
- Re: doubt with pg_dump and high concurrent used databases Tom Lane
- Re: doubt with pg_dump and high concurrent used databases Pablo Alcaraz
- Re: Problems with PostGreSQL and Windows 2003 Heikki Linnakangas
- Re: doubt with pg_dump and high concurrent used databases Peter Childs
- TB-sized databases Peter Koczan
- Re: TB-sized databases Joshua D. Drake
- Re: TB-sized databases Oleg Bartunov
- Re: TB-sized databases Pablo Alcaraz
- Re: TB-sized databases Stephen Cook
- Base de Datos Transaccional Fabio Arias
- Re: Base de Datos Transaccional Peter T. Breuer
- Re: Base de Datos Transaccional Pablo Alcaraz
- PostgreSQL performance on various distribution stock kernels Damon Hart
- Re: PostgreSQL performance on various distribution stock kernels Alexander Staubo
- Re: PostgreSQL performance on various distribution stock kernels Scott Marlowe
- Re: PostgreSQL performance on various distribution stock kernels Tom Lane
- Re: PostgreSQL performance on various distribution stock kernels Scott Marlowe
- Re: PostgreSQL performance on various distribution stock kernels Damon Hart
- Re: PostgreSQL performance on various distribution stock kernels Damon Hart
- Re: PostgreSQL performance on various distribution stock kernels Greg Smith
- 8.1 planner problem ? Gianluca Alberici
- Re: 8.1 planner problem ? Heikki Linnakangas
- Query only slow on first run cluster
- Re: Query only slow on first run Andrew Sullivan
- Re: Query only slow on first run Kevin Kempter
- Re: Query only slow on first run Tom Lane
- GiST indexing tuples Matthew
- Re: GiST indexing tuples Steinar H. Gunderson
- Re: Query only slow on first run cluster
- Re: Query only slow on first run Bill Moran
- Re: Query only slow on first run Dave Dutcher
- Re: TB-sized databases Peter Koczan
- Re: TB-sized databases Simon Riggs
- Re: TB-sized databases Pablo Alcaraz
- Re: Query only slow on first run cluster
- Re: Query only slow on first run Steinar H. Gunderson
- Re: Query only slow on first run Dave Dutcher
- Re: Query only slow on first run Tom Lane
- Re: Query only slow on first run Steinar H. Gunderson
- Windows XP selects are very slow Shadkam Islam
- Re: Query only slow on first run tmp
- Re: Windows XP selects are very slow Richard Huxton
- Re: TB-sized databases Matthew
- Re: GiST indexing tuples Matthew
- Re: TB-sized databases Bill Moran
- Re: GiST indexing tuples Gregory Stark
- Re: TB-sized databases Csaba Nagy
- Re: TB-sized databases Bill Moran
- Re: TB-sized databases Gregory Stark
- Re: TB-sized databases david@lang.hm
- Re: TB-sized databases Bill Moran
- Re: TB-sized databases Csaba Nagy
- Re: TB-sized databases Pablo Alcaraz
- Re: TB-sized databases Matthew
- Re: Query only slow on first run Craig James
- Re: TB-sized databases Pablo Alcaraz
- Re: TB-sized databases Alvaro Herrera
- Optimizer regression 8.2.1 -> 8.2.3 on TSEARCH2 queries with ORDER BY and LIMIT Brendan McMahon
- Re: GiST indexing tuples Tom Lane
- Re: Query only slow on first run Dave Dutcher
- Re: GiST indexing tuples Matthew
- Re: Windows XP selects are very slow Usama Munir Dar
- Re: Training Recommendations Usama Munir Dar
- Re: Query only slow on first run Tom Lane
- Re: TB-sized databases Simon Riggs
- Re: TB-sized databases Simon Riggs
- Re: TB-sized databases Matthew
- Re: Query only slow on first run cluster
- Re: Query only slow on first run Steinar H. Gunderson
- Re: TB-sized databases david@lang.hm
- Re: Query only slow on first run cluster
- Re: Query only slow on first run Jean-David Beyer
- Re: Query only slow on first run Tom Lane
- Re: Query only slow on first run Scott Marlowe
- Re: Query only slow on first run cluster
- Re: TB-sized databases Gregory Stark
- 7.4 Checkpoint Question Brad Nicholson
- Re: Query only slow on first run Tom Lane
- Re: TB-sized databases Tom Lane
- Re: 7.4 Checkpoint Question Andrew Sullivan
- Re: 7.4 Checkpoint Question Simon Riggs
- Re: TB-sized databases Simon Riggs
- Re: 7.4 Checkpoint Question Brad Nicholson
- Re: TB-sized databases Stephen Frost
- Re: TB-sized databases Csaba Nagy
- Configuring a Large RAM PostgreSQL Server Alex Hochberger
- Re: Configuring a Large RAM PostgreSQL Server Richard Huxton
- Re: Configuring a Large RAM PostgreSQL Server Alex Hochberger
- Re: Configuring a Large RAM PostgreSQL Server Alvaro Herrera
- Re: GiST indexing tuples Matthew T. O'Connor
- Re: GiST indexing tuples Steinar H. Gunderson
- clear pg_stats Campbell, Lance
- Re: clear pg_stats Heikki Linnakangas
- Re: clear pg_stats Magnus Hagander
- Re: TB-sized databases Mark Kirkwood
- Re: Configuring a Large RAM PostgreSQL Server Josh Berkus
- Re: TB-sized databases Russell Smith
- Re: TB-sized databases Simon Riggs
- Re: Training Recommendations Robert Treat
- Re: TB-sized databases Trevor Talbot
- Re: TB-sized databases Csaba Nagy
- Appending "LIMIT" to query drastically decreases performance cluster
- Re: Appending "LIMIT" to query drastically decreases performance Matthew
- Re: GiST indexing tuples Matthew
- Re: Appending "LIMIT" to query drastically decreases performance Bill Moran
- Re: TB-sized databases Luke Lonergan
- Re: Appending "LIMIT" to query drastically decreases performance cluster