Mailing lists [pgsql-performance]
- Speeding up Gist Index creations mallah@trade-india.com
- Re: Speeding up Gist Index creations Josh Berkus
- Re: [PATCHES] [HACKERS] ARC Memory Usage analysis Gaetano Mendola
- Re: Thanks Chariot Solutions D'Arcy J.M. Cain
- Re: psql large RSS (1.6GB) Gavin Sherry
- Re: psql large RSS (1.6GB) Bruce Momjian
- Re: psql large RSS (1.6GB) Tom Lane
- shared_buffers and Shared Memory Segments Anjan Dave
- Re: psql large RSS (1.6GB) Josh Berkus
- Performance difference when using views Alvaro Nunes Melo
- Re: [PATCHES] [HACKERS] ARC Memory Usage analysis Simon Riggs
- Re: Performance difference when using views Tom Lane
- Re: Performance difference when using views Simon Riggs
- Re: Speeding up Gist Index creations Neil Conway
- Re: Speeding up Gist Index creations Josh Berkus
- Restricting Postgres Martin Foster
- Re: Restricting Postgres Andrew Sullivan
- preloading indexes
- Re: preloading indexes Matt Clark
- vacuum analyze slows sql query patrick ~
- Re: preloading indexes
- Re: vacuum analyze slows sql query Doug Y
- Re: Restricting Postgres Simon Riggs
- Re: preloading indexes Andrew Sullivan
- Re: preloading indexes Pierre-Frédéric Caillaud
- Re: preloading indexes Tom Lane
- Re: vacuum analyze slows sql query Tom Lane
- Re: preloading indexes
- Re: preloading indexes Tom Lane
- Re: preloading indexes Andrew Sullivan
- Re: preloading indexes
- Re: Restricting Postgres Martin Foster
- Re: vacuum analyze slows sql query patrick ~
- Re: Restricting Postgres John A Meinel
- Re: Restricting Postgres Martin Foster
- Re: preloading indexes Mike Benoit
- index not used if using IN or OR Mario Ivankovits
- Re: Restricting Postgres Matt Clark
- Re: index not used if using IN or OR Richard Huxton
- Re: Anything to be gained from a 'Postgres Filesystem'? Markus Schaber
- Re: Restricting Postgres Simon Riggs
- Re: Anything to be gained from a 'Postgres Filesystem'? Pierre-Frédéric Caillaud
- Re: Restricting Postgres Martin Foster
- Re: Restricting Postgres Martin Foster
- Re: preloading indexes Andrew Sullivan
- Re: index not used if using IN or OR Tom Lane
- Re: Restricting Postgres Martin Foster
- Re: Anything to be gained from a 'Postgres Filesystem'? Chris Browne
- Re: Restricting Postgres Matt Clark
- Re: Restricting Postgres Matt Clark
- Re: Restricting Postgres Pierre-Frédéric Caillaud
- Re: Restricting Postgres Martin Foster
- Re: Restricting Postgres Martin Foster
- Re: Restricting Postgres Matt Clark
- Re: Anything to be gained from a 'Postgres Filesystem'? Simon Riggs
- Re: Anything to be gained from a 'Postgres Filesystem'? Steinar H. Gunderson
- Re: Anything to be gained from a 'Postgres Filesystem'? Tom Lane
- Re: Restricting Postgres Pierre-Frédéric Caillaud
- Re: Restricting Postgres Martin Foster
- Re: Anything to be gained from a 'Postgres Filesystem'? Simon Riggs
- Re: Anything to be gained from a 'Postgres Filesystem'? Tom Lane
- Re: Restricting Postgres Steinar H. Gunderson
- Re: Restricting Postgres Matt Clark
- Re: Restricting Postgres Matt Clark
- Better Hardware, worst Results Alvaro Nunes Melo
- Re: Better Hardware, worst Results Rod Taylor
- Re: Better Hardware, worst Results Tom Lane
- Re: Restricting Postgres Pierre-Frédéric Caillaud
- appropriate indexing T E Schmitz
- Re: Restricting Postgres Matt Clark
- Re: appropriate indexing Matt Clark
- Re: Better Hardware, worst Results al_nunes@atua.com.br
- Re: Better Hardware, worst Results Matt Clark
- Re: Better Hardware, worst Results Rod Taylor
- Re: Restricting Postgres Bruno Wolff III
- Re: Better Hardware, worst Results Matt Clark
- Re: Restricting Postgres Matt Clark
- Re: Restricting Postgres Pierre-Frédéric Caillaud
- Re: Restricting Postgres Matt Clark
- Re: Restricting Postgres Matt Clark
- Re: Anything to be gained from a 'Postgres Filesystem'? Christopher Browne
- Re: Restricting Postgres Martin Foster
- Re: Anything to be gained from a 'Postgres Filesystem'? Christopher Browne
- Re: Anything to be gained from a 'Postgres Filesystem'? Neil Conway
- Re: Anything to be gained from a 'Postgres Filesystem'? Neil Conway
- Re: Anything to be gained from a 'Postgres Filesystem'? Neil Conway
- Re: Restricting Postgres Bruno Wolff III
- Checking = with timestamp field is slow Antony Paul
- Re: Checking = with timestamp field is slow Michael Glaesemann
- Re: Checking = with timestamp field is slow Michael Glaesemann
- Re: Checking = with timestamp field is slow Michael Fuhr
- Re: Restricting Postgres Leeuw van der, Tim
- Re: Checking = with timestamp field is slow Andrew McMillan
- Re: Checking = with timestamp field is slow Michael Fuhr
- Re: Checking = with timestamp field is slow Christopher Browne
- Strange (?) Index behavior? Allen Landsidel
- Re: Strange (?) Index behavior? Matt Clark
- Re: Strange (?) Index behavior? Rod Taylor
- Re: Strange (?) Index behavior? Allen Landsidel
- postgresql amd-64 Merlin Moncure
- Re: Strange (?) Index behavior? Allen Landsidel
- Re: Strange (?) Index behavior? Bruno Wolff III
- Re: Checking = with timestamp field is slow Michael Fuhr
- Re: Strange (?) Index behavior? Allen Landsidel
- What is the difference between these? Matt Nuzum
- Re: postgresql amd-64 Daniel Ceregatti
- Re: vacuum analyze slows sql query patrick ~
- Re: Strange (?) Index behavior? Matt Clark
- Re: What is the difference between these? Matthew T. O'Connor
- Re: Strange (?) Index behavior? Tom Lane
- Re: What is the difference between these? Tom Lane
- Re: Strange (?) Index behavior? Allen Landsidel
- Question regarding the file system Gabriele Bartolini
- Re: Strange (?) Index behavior? Allen Landsidel
- Re: Strange (?) Index behavior? Tom Lane
- Re: postgresql amd-64 Merlin Moncure
- Re: Strange (?) Index behavior? Allen Landsidel
- ia64 results with dbt2 and 8.0beta4 Mark Wong
- Re: Strange (?) Index behavior? Matt Clark
- Re: vacuum analyze slows sql query patrick ~
- Re: postgresql amd-64 Vishal Kashyap @ [Sai Hertz And Control Systems]
- Re: Strange (?) Index behavior? Tom Lane
- Re: vacuum analyze slows sql query Tom Lane
- Re: vacuum analyze slows sql query patrick ~
- Re: vacuum analyze slows sql query Tom Lane
- Re: Strange (?) Index behavior? Allen Landsidel
- poor performance in migrated database Carlos Lopez
- Re: poor performance in migrated database Troels Arvin
- Re: poor performance in migrated database Simon Riggs
- Re: poor performance in migrated database Scott Marlowe
- DISTINCT and GROUP BY: possible performance enhancement? Ang Chin Han
- Re: postgresql amd-64 Iain
- Re: Restricting Postgres Matthew Nuzum
- Re: poor performance in migrated database Troels Arvin
- Re: postgresql amd-64 Iain
- Postgresql is using seqscan when is should use indexes. Andreas Åkre Solberg
- Re: postgresql amd-64 Radu-Adrian Popescu
- Re: Better Hardware, worst Results Alvaro Nunes Melo
- Re: Postgresql is using seqscan when is should use indexes. Russell Smith
- ext3 journalling type Dawid Kuroczko
- Re: postgresql amd-64 Merlin Moncure
- Re: ext3 journalling type Bruce Momjian
- Re: ext3 journalling type Matt Clark
- Re: ext3 journalling type Mark Wong
- Re: ext3 journalling type Josh Berkus
- Re: Question regarding the file system Josh Berkus
- Re: vacuum analyze slows sql query patrick ~
- Re: vacuum analyze slows sql query John Meinel
- Re: [ADMIN] poor performance in migrated database Carlos Lopez
- Re: vacuum analyze slows sql query patrick ~
- Re: [ADMIN] poor performance in migrated database Tom Lane
- Re: vacuum analyze slows sql query John Meinel
- Re: vacuum analyze slows sql query Pierre-Frédéric Caillaud
- Slow performance with Group By Erik Norvelle
- Re: vacuum analyze slows sql query John Meinel
- Re: Slow performance with Group By Tom Lane
- Re: Question regarding the file system Josh Berkus
- Re: [ADMIN] poor performance in migrated database Carlos Lopez
- Need advice on postgresql.conf settings Shane | SkinnyCorp
- Re: vacuum analyze slows sql query patrick ~
- Re: Need advice on postgresql.conf settings Tom Lane
- Re: Need advice on postgresql.conf settings Sean Chittenden
- seqscan strikes again Jim C. Nasby
- Re: seqscan strikes again Joshua D. Drake
- Re: seqscan strikes again Tom Lane
- simple select-statement takes more than 25 sec Cao Duy
- Re: simple select-statement takes more than 25 sec Steinar H. Gunderson
- Re: simple select-statement takes more than 25 sec gnari
- Re: simple select-statement takes more than 25 sec Cao Duy
- Re: simple select-statement takes more than 25 sec Steinar H. Gunderson
- Re: Need advice on postgresql.conf settings Jeff
- How to speed-up inserts with jdbc Michael Kleiser
- Re: How to speed-up inserts with jdbc Jeff
- Re: How to speed-up inserts with jdbc Dave Cramer
- Re: How to speed-up inserts with jdbc Leeuw van der, Tim
- Re: seqscan strikes again Jim C. Nasby
- Solaris 9 Tuning Tips requested Rod Taylor
- int4 in a GiST index Mike Rylander
- Re: int4 in a GiST index George Essig
- Re: int4 in a GiST index Mike Rylander
- Re: How to speed-up inserts with jdbc Edwin Eyan Moragas
- Re: seqscan strikes again Gaetano Mendola
- Re: How to speed-up inserts with jdbc Steinar H. Gunderson
- Re: vacuum analyze slows sql query Gaetano Mendola
- Re: Strange (?) Index behavior? Allen Landsidel
- Re: Strange (?) Index behavior? Josh Berkus
- Re: Strange (?) Index behavior? Allen Landsidel
- Re: Strange (?) Index behavior? Greg Stark
- Re: How to speed-up inserts with jdbc Edwin Eyan Moragas
- Re: Strange (?) Index behavior? Allen Landsidel
- Re: Strange (?) Index behavior? Tom Lane
- Re: Strange (?) Index behavior? Joshua D. Drake
- Clarification on two bits on VACUUM FULL VERBOSE output Josh Berkus
- Re: Clarification on two bits on VACUUM FULL VERBOSE output Tom Lane
- Re: Strange (?) Index behavior? Allen Landsidel
- Re: Clarification on two bits on VACUUM FULL VERBOSE output Josh Berkus
- Re: Clarification on two bits on VACUUM FULL VERBOSE output Tom Lane
- Re: Strange (?) Index behavior? Tom Lane
- Re: Strange (?) Index behavior? Allen Landsidel
- Insertion puzzles vivek singh
- Re: Insertion puzzles Andreas Åkre Solberg
- Re: Insertion puzzles Dave Cramer
- Re: Insertion puzzles Stephan Szabo
- Some quick Opteron 32-bit/64-bit results William Yu
- Re: Some quick Opteron 32-bit/64-bit results Gustavo Franklin Nóbrega
- Re: Some quick Opteron 32-bit/64-bit results William Yu
- Re: Some quick Opteron 32-bit/64-bit results William Yu
- Re: Insertion puzzles Josh Berkus
- Tuning suggestions wanted Rod Taylor
- Re: Insertion puzzles Dave Cramer
- Re: Some quick Opteron 32-bit/64-bit results Greg Stark
- Re: Some quick Opteron 32-bit/64-bit results William Yu
- Re: Large Database Performance suggestions Andrew Hammond
- Question on pgsql optimisation of SQL and structure (index, etc) Alexandre Leclerc
- Re: Question on pgsql optimisation of SQL and structure (index, etc) Josh Berkus
- Why distinct so slow ? Hervé Piedvache
- Re: Strange (?) Index behavior? Allen Landsidel
- Performance difference: SELECT from VIEW or not? Alexandre Leclerc
- Re: Performance difference: SELECT from VIEW or not? Tom Lane
- Re: Insertion puzzles dentfirst13@earthlink.net
- mis-estimation on data-warehouse aggregate creation Kris Jurka
- Re: mis-estimation on data-warehouse aggregate creation F. Senault
- Tsearch2 really slower than ilike ? Hervé Piedvache
- Re: Tsearch2 really slower than ilike ? Michael Fuhr
- Re: Tsearch2 really slower than ilike ? Hervé Piedvache
- Efficient way to remove OID data James Gunzelman
- Re: Tsearch2 really slower than ilike ? Joshua D. Drake
- Re: Tsearch2 really slower than ilike ? Joshua D. Drake
- Re: Tsearch2 really slower than ilike ? Oleg Bartunov
- Re: Tsearch2 really slower than ilike ? Hervé Piedvache
- Re: Tsearch2 really slower than ilike ? Oleg Bartunov
- Re: Insertion puzzles J. Andrew Rogers
- Re: mis-estimation on data-warehouse aggregate creation Kris Jurka
- nuderstanding 'explain analyse' Alexandre Leclerc
- Re: Tsearch2 really slower than ilike ? Oleg Bartunov
- Re: mis-estimation on data-warehouse aggregate creation Simon Riggs
- query plan question David Parker
- memcached and PostgreSQL Michael Adler
- Re: query plan question Russell Smith
- Table Partitions: To Inherit Or Not To Inherit Don Drake
- Re: memcached and PostgreSQL Josh Berkus
- Re: Table Partitions: To Inherit Or Not To Inherit Josh Berkus
- Re: nuderstanding 'explain analyse' Josh Berkus
- Re: query plan question Joshua D. Drake
- Re: memcached and PostgreSQL Troels Arvin
- Re: memcached and PostgreSQL Greg Stark
- Re: mis-estimation on data-warehouse aggregate creation Kris Jurka
- Re: query plan question David Parker
- Re: query plan question David Parker
- Re: query plan question Jeff
- Re: query plan question David Parker
- Re: query plan question David Parker
- Re: query plan question Tom Lane
- Re: query plan question David Parker
- Analyzer is clueless David Brown
- Re: memcached and PostgreSQL Mike Rylander
- Re: query plan question Matthew T. O'Connor
- Re: memcached and PostgreSQL Darcy Buskermolen
- Re: Tsearch2 really slower than ilike ? Hervé Piedvache
- Re: Tsearch2 really slower than ilike ? Oleg Bartunov
- Re: query plan question Matthew T. O'Connor
- Re: Analyzer is clueless Josh Berkus
- Re: memcached and PostgreSQL Michael Adler
- Re: Analyzer is clueless Joshua D. Drake
- Re: memcached and PostgreSQL Josh Berkus
- sort_mem affect on inserts? David Parker
- Re: sort_mem affect on inserts? Josh Berkus
- postgres eating CPU silviapg@tiscali.it
- Re: postgres eating CPU Josh Berkus
- Re: Analyzer is clueless Simon Riggs
- Re: postgres eating CPU silviapg@tiscali.it
- Re: postgres eating CPU Josh Berkus
- Re: postgres eating CPU Tom Lane
- Re: Analyzer is clueless Jim C. Nasby
- Re: Analyzer is clueless Josh Berkus
- Re: Analyzer is clueless Tom Lane
- Re: postgres eating CPU Joshua D. Drake
- Re: Tsearch2 really slower than ilike ? Hervé Piedvache
- Re: Tsearch2 really slower than ilike ? Oleg Bartunov
- Re: Tsearch2 really slower than ilike ? Hervé Piedvache
- Re: Tsearch2 really slower than ilike ? Oleg Bartunov
- Re: Tsearch2 really slower than ilike ? Leeuw van der, Tim
- Query Performance and IOWait Andrew Janian
- Re: Query Performance and IOWait Richard_D_Levine@raytheon.com
- Re: Query Performance and IOWait Andrew Janian
- Re: Query Performance and IOWait Woody Woodring
- Re: Query Performance and IOWait Tom Lane
- Re: Query Performance and IOWait Andrew Janian
- Re: query plan question David Parker
- Re: Query Performance and IOWait Joshua D. Drake
- Interaction between Free Space Map an alternate location for a database Dave Cramer
- Re: Query Performance and IOWait Dave Cramer
- Re: Interaction between Free Space Map an alternate location for a database Josh Berkus
- Re: Query Performance and IOWait Josh Berkus
- Re: Interaction between Free Space Map an alternate location for a database Tom Lane
- Re: Interaction between Free Space Map an alternate location Dave Cramer
- Re: Query Performance and IOWait Woody Woodring
- Re: Interaction between Free Space Map an alternate location Dave Cramer
- Re: memcached and PostgreSQL Sean Chittenden
- When to bump up statistics? Dawid Kuroczko
- Re: sort_mem affect on inserts? Jan Wieck
- index use Arshavir Grigorian
- Re: index use Steinar H. Gunderson
- Re: When to bump up statistics? Josh Berkus
- Re: index use Josh Berkus
- Re: index use Arshavir Grigorian
- help needed -- sequential scan problem sarlav kumar
- Re: Query Performance and IOWait Frank Wiles
- Re: sort_mem affect on inserts? Josh Berkus
- Re: index use Stephan Szabo
- Re: index use Tom Lane
- tablespace + RAM disk? David Parker
- Re: When to bump up statistics? Chris Browne
- Re: Query Performance and IOWait Andrew Janian
- Re: tablespace + RAM disk? Josh Berkus
- Re: tablespace + RAM disk? David Parker
- Re: tablespace + RAM disk? David Parker
- Re: help needed -- sequential scan problem Tom Lane
- Re: tablespace + RAM disk? Dawid Kuroczko
- Index usage for sorted query Markus Schaber
- Re: Index usage for sorted query Pierre-Frédéric Caillaud
- Re: Index usage for sorted query Tom Lane
- Re: tablespace + RAM disk? Josh Berkus
- Re: index use Josh Berkus
- Re: tablespace + RAM disk? Neil Conway
- Re: sort_mem affect on inserts? Neil Conway
- Re: memcached and PostgreSQL Bruce Momjian
- Re: memcached and PostgreSQL Josh Berkus
- Re: memcached and PostgreSQL Sean Chittenden
- Re: memcached and PostgreSQL Patrick B Kelly
- Re: memcached and PostgreSQL Pierre-Frédéric Caillaud
- Re: Index usage for sorted query Markus Schaber
- Re: Query Performance and IOWait Anjan Dave
- Re: help needed -- sequential scan problem sarlav kumar
- Re: help needed -- sequential scan problem Josh Berkus
- Re: help needed -- sequential scan problem sarlav kumar
- Re: help needed -- sequential scan problem gnari
- Data type to use for primary key Alexandre Leclerc
- Slow execution time when querying view with WHERE clause Mike Mascari
- Re: Slow execution time when querying view with WHERE clause Mike Mascari
- scalability issues on win32 Merlin Moncure
- Re: Data type to use for primary key Pierre-Frédéric Caillaud
- Re: scalability issues on win32 Pierre-Frédéric Caillaud
- Re: Data type to use for primary key Alexandre Leclerc
- Re: Data type to use for primary key Josh Berkus
- Re: Data type to use for primary key Rod Taylor
- Re: memcached and PostgreSQL Bruce Momjian
- Re: [pgsql-hackers-win32] scalability issues on win32 Bruce Momjian
- Re: Data type to use for primary key Josh Berkus
- Re: Data type to use for primary key Pierre-Frédéric Caillaud
- Re: [pgsql-hackers-win32] scalability issues on win32 Merlin Moncure
- Re: Data type to use for primary key Peter Darley
- Re: [pgsql-hackers-win32] scalability issues on win32 Bruce Momjian
- Re: [pgsql-hackers-win32] scalability issues on win32 Magnus Hagander
- Re: Data type to use for primary key Alexandre Leclerc
- Re: Data type to use for primary key Pierre-Frédéric Caillaud
- Re: [pgsql-hackers-win32] scalability issues on win32 Merlin Moncure
- Re: Some quick Opteron 32-bit/64-bit results Cott Lang
- Re: Slow execution time when querying view with WHERE clause Tom Lane
- Re: memcached and PostgreSQL Sean Chittenden
- Re: Slow execution time when querying view with WHERE clause Mike Mascari
- Re: [pgsql-hackers-win32] scalability issues on win32 Bruce Momjian
- Re: Slow execution time when querying view with WHERE clause Jaime Casanova
- Re: Slow execution time when querying view with WHERE clause Tom Lane
- Re: Slow execution time when querying view with WHERE clause Tom Lane
- FW: Index usage BBI Edwin Punzalan
- Re: Data type to use for primary key Greg Stark
- Re: Data type to use for primary key Tom Lane
- Re: FW: Index usage Leeuw van der, Tim
- FW: FW: Index usage BBI Edwin Punzalan
- Re: Data type to use for primary key Greg Stark
- Re: FW: Index usage gnari
- Unsubscribe songtebo
- Re: FW: Index usage BBI Edwin Punzalan
- Re: FW: FW: Index usage Richard Huxton
- Re: FW: FW: Index usage BBI Edwin Punzalan
- Re: FW: FW: Index usage Richard Huxton
- Postgres vs. MySQL Evilio del Rio
- Re: Postgres vs. MySQL Steinar H. Gunderson
- Re: Postgres vs. MySQL Richard Huxton
- Re: Postgres vs. MySQL Christian Fowler
- Re: Data type to use for primary key Alexandre Leclerc
- Re: Postgres vs. MySQL Joshua D. Drake
- Re: memcached and PostgreSQL Jim C. Nasby
- Re: Postgres vs. MySQL Steinar H. Gunderson
- Re: [PERFORMANCE] Big number of schemas (3500) into a single database Jaime Casanova
- "Group By " index usage sdfasdfas sdfasdfs
- Re: "Group By " index usage Tom Lane
- Re: FW: Index usage gnari
- Re: Slow execution time when querying view with WHERE clause Mike Mascari
- Re: Postgres vs. MySQL Steinar H. Gunderson
- Re: [pgsql-hackers-win32] scalability issues on win32 Dave Page
- Hardware purchase question Bo Stewart
- Re: [pgsql-hackers-win32] scalability issues on win32 Reini Urban
- Re: [pgsql-hackers-win32] scalability issues on win32 Dave Page
- HELP speed up my Postgres JM
- Re: HELP speed up my Postgres Vishal Kashyap @ [SaiHertz]
- Re: HELP speed up my Postgres JM
- Re: HELP speed up my Postgres Tom Lane
- Re: HELP speed up my Postgres Klint Gore
- Re: HELP speed up my Postgres Christopher Kings-Lynne
- Re: Postgres vs. MySQL Dave Cramer
- Postgres backend using huge amounts of ram Gary Doades
- Re: Postgres vs. DSpam Andrew McMillan
- Re: Postgres vs. DSpam Neil Conway
- Re: [GENERAL] HELP speed up my Postgres Jerome Macaranas
- Re: Postgres backend using huge amounts of ram Richard Huxton
- time to stop tuning? David Parker
- Re: time to stop tuning? Tom Lane
- Re: time to stop tuning? David Parker
- Re: Postgres backend using huge amounts of ram Tom Lane
- Re: Postgres backend using huge amounts of ram Gary Doades
- Re: time to stop tuning? Rod Taylor
- Re: [dspam-users] Postgres vs. MySQL Clifton Royston
- Re: time to stop tuning? Rod Taylor
- Re: [dspam-users] Postgres vs. MySQL Casey Allen Shobe
- Re: [dspam-users] Postgres vs. MySQL Lionel Bouton
- Re: [dspam-users] Postgres vs. MySQL Christopher Browne
- Re: Postgres vs. DSpam Jim C. Nasby
- VACUUM ANALYZE downgrades performance Dmitry Karasik
- Re: VACUUM ANALYZE downgrades performance Mike Rylander
- Re: VACUUM ANALYZE downgrades performance Thomas Swan
- Re: "Group By " index usage Alban Medici (NetCentrex)