Mailing lists [pgsql-performance]
- Re: Table UPDATE is too slow Tom Lane
 - Changing the column length Michael Ryan S. Puncia
 - Fw: Query performance issue with 8.0.0beta1 Stefano Bonnin
 - Re: Changing the column length gnari
 - Re: Query performance issue with 8.0.0beta1 Stefano Bonnin
 - slower every day G u i d o B a r o s i o
 - Re: slower every day Shridhar Daithankar
 - Re: [ADMIN] slower every day G u i d o B a r o s i o
 - Re: [ADMIN] slower every day G u i d o B a r o s i o
 - Re: [ADMIN] slower every day Richard Huxton
 - Re: Why does a simple query not use an obvious index? Mr Pink
 - Re: [ADMIN] slower every day Michael Paesold
 - Re: [ADMIN] slower every day G u i d o B a r o s i o
 - Re: seqscan instead of index scan Chester Kustarz
 - Re: Changing the column length Josh Berkus
 - Re: seqscan instead of index scan Merlin Moncure
 
- Multiple Uniques Markus Schaber
 - Re: Multiple Uniques Tom Lane
 - Re: Multiple Uniques Greg Stark
 
- restoring to wrong encoding db Vivek Khera
 - Re: fsync vs open_sync Merlin Moncure
 - Re: fsync vs open_sync Pierre-Frédéric Caillaud
 - Re: fsync vs open_sync Gaetano Mendola
 
- Re: fsync vs open_sync Cott Lang
 - Re: fsync vs open_sync Christopher Browne
 - Dump/Restore performance improvement Adi Alurkar
 - Re: fsync vs open_sync Steve Bergman
 - Re: fsync vs open_sync Geoffrey
 - Re: Dump/Restore performance improvement Tom Lane
 - Re: fsync vs open_sync Pierre-Frédéric Caillaud
 - Re: fsync vs open_sync Pierre-Frédéric Caillaud
 
- Re: Table UPDATE is too slow Marinos J. Yannikos
 - Re: Table UPDATE is too slow Kevin Barnard
 - Tanking a server with shared memory Martin Foster
 - Re: Tanking a server with shared memory Tom Lane
 - The usual sequential scan, but with LIMIT ! Pierre-Frédéric Caillaud
 - Re: The usual sequential scan, but with LIMIT ! Pierre-Frédéric Caillaud
 - Re: The usual sequential scan, but with LIMIT ! Dennis Bjorklund
 - Re: Multiple Uniques Markus Schaber
 - Re: The usual sequential scan, but with LIMIT ! Tom Lane
 
- Re: The usual sequential scan, but with LIMIT ! Pierre-Frédéric Caillaud
 - TOAST tables, cannot truncate G u i d o B a r o s i o
 - Re: [ADMIN] TOAST tables, cannot truncate G u i d o B a r o s i o
 - Re: The usual sequential scan, but with LIMIT ! Tom Lane
 - Re: [ADMIN] TOAST tables, cannot truncate Tom Lane
 - Re: The usual sequential scan, but with LIMIT ! Pierre-Frédéric Caillaud
 - Re: The usual sequential scan, but with LIMIT ! Gaetano Mendola
 
- Problem with large query Marc Cousin
 - Re: Problem with large query Tom Lane
 - Re: Problem with large query Marc Cousin
 - Re: Problem with large query Tom Lane
 - Re: Problem with large query Marc Cousin
 
- Re: [GENERAL] Text Search vs MYSQL vs Lucene Shridhar Daithankar
 - Re: TSearch2 and optimisation ... Hervé Piedvache
 - Re: fsync vs open_sync Mark Wong
 - Costly "Sort Key" on indexed timestamp column
 
- Re: Multiple Uniques Neil Conway
 - Re: Multiple Uniques Tom Lane
 - Re: Costly "Sort Key" on indexed timestamp column Tom Lane
 - Re: Multiple Uniques Greg Stark
 - Question on Byte Sizes Pierre-Frédéric Caillaud
 - Interesting performance behaviour Joey Smith
 - Re: Interesting performance behaviour Josh Berkus
 - effective_cache_size in 7.3.4?
 - Re: Interesting performance behaviour Joey Smith
 - Fwd: Interesting performance behaviour Joey Smith
 - Re: effective_cache_size in 7.3.4? Josh Berkus
 - Re: Interesting performance behaviour Tom Lane
 
- Stuck using Sequential Scan Jeremy M. Guthrie
 - Re: Problem with large query Adam Sah
 - Re: Equivalent praxis to CLUSTERED INDEX? Mischa Sandberg
 - Re: Stuck using Sequential Scan Oliver Elphick
 - Bad performance with hashjoin Vitaly Belman
 - Re: Bad performance with hashjoin Tom Lane
 
- Data Warehouse Reevaluation - MySQL vs Postgres Mark Cotner
 - Re: Data Warehouse Reevaluation - MySQL vs Postgres Dennis Bjorklund
 - Re: Data Warehouse Reevaluation - MySQL vs Postgres Gaetano Mendola
 
- Re: TSearch2 and optimisation ... George Essig
 - Re: Data Warehouse Reevaluation - MySQL vs Postgres -- merge tables Christopher Browne
 - Determine optimal fdatasync/fsync, O_SYNC/O_DSYNC options [email protected]
 - Re: Data Warehouse Reevaluation - MySQL vs Postgres -- merge tables Mark Cotner
 - Re: Data Warehouse Reevaluation - MySQL vs Postgres -- merge tables Christopher Browne
 - Help with extracting large volumes of records across related tables Damien Dougan
 - Re: Help with extracting large volumes of records across related tables Paul Thomas
 - Re: Help with extracting large volumes of records across related tables Pierre-Frédéric Caillaud
 - Re: Help with extracting large volumes of records across related tables Pierre-Frédéric Caillaud
 - Re: Help with extracting large volumes of records across related tables Damien Dougan
 - Re: Help with extracting large volumes of records across related tables Pierre-Frédéric Caillaud
 - Re: Determine optimal fdatasync/fsync, O_SYNC/O_DSYNC options Bruce Momjian
 - Re: Determine optimal fdatasync/fsync, O_SYNC/O_DSYNC options [email protected]
 - Re: Determine optimal fdatasync/fsync, O_SYNC/O_DSYNC options Gaetano Mendola
 - Re: Determine optimal fdatasync/fsync, O_SYNC/O_DSYNC options Josh Berkus
 - Re: Determine optimal fdatasync/fsync, O_SYNC/O_DSYNC options Tom Lane
 - Re: Data Warehouse Reevaluation - MySQL vs Postgres -- merge tables Simon Riggs
 
- Large # of rows in query extremely slow, not using index Stephen Crowley
 - Re: Large # of rows in query extremely slow, not using Rod Taylor
 - Re: Large # of rows in query extremely slow, not using index Tom Lane
 - Re: Large # of rows in query extremely slow, not using index Stephen Crowley
 - Re: Determine optimal fdatasync/fsync, O_SYNC/O_DSYNC options Bruce Momjian
 - Re: Determine optimal fdatasync/fsync, O_SYNC/O_DSYNC options Gaetano Mendola
 - Re: Large # of rows in query extremely slow, not using index Tom Lane
 - Re: Determine optimal fdatasync/fsync, O_SYNC/O_DSYNC options Tom Lane
 - Re: Data Warehouse Reevaluation - MySQL vs Postgres -- merge tables Mischa Sandberg
 - tblspaces integrated in new postgresql (version 8.0) [email protected]
 - Four table join with million records - performance improvement? Vijay Moses
 - tblspace Bill Fefferman
 - Re: Help with extracting large volumes of records across related Mischa Sandberg
 - Re: tblspaces integrated in new postgresql (version 8.0) Tom Lane
 - Re: Four table join with million records - performance improvement? Tom Lane
 - Re: Large # of rows in query extremely slow, not using index Stephen Crowley
 - Re: Data Warehouse Reevaluation - MySQL vs Postgres -- merge tables Mark Cotner
 - Re: Data Warehouse Reevaluation - MySQL vs Postgres -- merge tables Pierre-Frédéric Caillaud
 - Re: Data Warehouse Reevaluation - MySQL vs Postgres -- Markus Schaber
 - Re: Data Warehouse Reevaluation - MySQL vs Postgres -- Leeuw van der, Tim
 - Re: Data Warehouse Reevaluation - MySQL vs Postgres -- merge tables Aaron Werman
 - Re: Data Warehouse Reevaluation - MySQL vs Postgres -- Steinar H. Gunderson
 - Re: Data Warehouse Reevaluation - MySQL vs Postgres -- Leeuw van der, Tim
 - Re: Data Warehouse Reevaluation - MySQL vs Postgres -- Harald Fuchs
 - Re: Data Warehouse Reevaluation - MySQL vs Postgres -- Michael Kleiser
 - Re: Data Warehouse Reevaluation - MySQL vs Postgres -- Stephen Frost
 - Re: Data Warehouse Reevaluation - MySQL vs Postgres -- merge tables Harald Lau (Sector-X)
 - Re: Large # of rows in query extremely slow, not using Markus Schaber
 - Re: Determine optimal fdatasync/fsync, O_SYNC/O_DSYNC options Vivek Khera
 - Re: Data Warehouse Reevaluation - MySQL vs Postgres -- merge tables Vivek Khera
 - Re: Large # of rows in query extremely slow, not using Pierre-Frédéric Caillaud
 - Re: Data Warehouse Reevaluation - MySQL vs Postgres -- merge tables aaron werman
 - Re: Data Warehouse Reevaluation - MySQL vs Postgres -- Simon Riggs
 - Re: Data Warehouse Reevaluation - MySQL vs Postgres -- merge tables Jim C. Nasby
 
- Re: Data Warehouse Reevaluation - MySQL vs Postgres -- merge tables Simon Riggs
 - Re: Data Warehouse Reevaluation - MySQL vs Postgres -- merge tables Michael Glaesemann
 - Re: Data Warehouse Reevaluation - MySQL vs Postgres -- merge tables Christopher Browne
 - Re: Data Warehouse Reevaluation - MySQL vs Postgres -- merge tables Chris Browne
 - Re: Data Warehouse Reevaluation - MySQL vs Postgres -- Joe Conway
 - Re: Data Warehouse Reevaluation - MySQL vs Postgres -- Iain
 - Re: Data Warehouse Reevaluation - MySQL vs Postgres -- merge tables Steve Atkins
 - Re: Data Warehouse Reevaluation - MySQL vs Postgres -- Leeuw van der, Tim
 - Re: Data Warehouse Reevaluation - MySQL vs Postgres -- Christopher Browne
 - Re: Re: Data Warehouse Reevaluation - MySQL vs Postgres --
 - Re: Data Warehouse Reevaluation - MySQL vs Postgres -- Markus Schaber
 - Re: Data Warehouse Reevaluation - MySQL vs Postgres -- Joe Conway
 - Re: Data Warehouse Reevaluation - MySQL vs Postgres -- Josh Berkus
 - Re: Data Warehouse Reevaluation - MySQL vs Postgres -- Joe Conway
 - Re: [GENERAL] disk performance benchmarks Ron St-Pierre
 - Re: Data Warehouse Reevaluation - MySQL vs Postgres -- merge tables? Simon Riggs
 - Re: Data Warehouse Reevaluation - MySQL vs Postgres -- Simon Riggs
 - Re: Data Warehouse Reevaluation - MySQL vs Postgres -- Joe Conway
 - Partitioning J. Andrew Rogers
 
- Re: Partitioning Greg Stark
 - Re: Data Warehouse Reevaluation - MySQL vs Postgres -- Joe Conway
 - Re: Data Warehouse Reevaluation - MySQL vs Postgres -- Steve Atkins
 - Re: Data Warehouse Reevaluation - MySQL vs Postgres -- merge tables Mischa Sandberg
 - Re: Data Warehouse Reevaluation - MySQL vs Postgres -- Mischa Sandberg
 - Re: Data Warehouse Reevaluation - MySQL vs Postgres -- Christopher Kings-Lynne
 - Re: Data Warehouse Reevaluation - MySQL vs Postgres -- Iain
 - Re: Data Warehouse Reevaluation - MySQL vs Postgres -- Joe Conway
 - declared cursor uses slow plan Kevin Neufeld
 - Comparing user attributes with bitwise operators Patrick Clery
 - Re: Comparing user attributes with bitwise operators Christopher Kings-Lynne
 - Re: Comparing user attributes with bitwise operators Greg Stark
 - Re: Comparing user attributes with bitwise operators Greg Stark
 - Re: Data Warehouse Reevaluation - MySQL vs Postgres -- Iain
 - Re: Data Warehouse Reevaluation - MySQL vs Postgres -- Markus Schaber
 - Re: Partitioning Mike Rylander
 - Re: Data Warehouse Reevaluation - MySQL vs Postgres -- Markus Schaber
 - Re: Data Warehouse Reevaluation - MySQL vs Postgres -- Joe Conway
 - Re: Comparing user attributes with bitwise operators Daniel Ceregatti
 - Article about PostgreSQL and RAID in Brazil Josh Berkus
 - Re: declared cursor uses slow plan Tom Lane
 - Re: Article about PostgreSQL and RAID in Brazil Daniel Ceregatti
 - Re: Article about PostgreSQL and RAID in Brazil Steinar H. Gunderson
 - Re: Article about PostgreSQL and RAID in Brazil Josh Berkus
 - Re: Article about PostgreSQL and RAID in Brazil Daniel Ceregatti
 - Re: Partitioning Jim C. Nasby
 - Re: Article about PostgreSQL and RAID in Brazil Qing Zhao
 - Re: Article about PostgreSQL and RAID in Brazil Jim C. Nasby
 - Re: Question about PG on OSX Josh Berkus
 - Re: Article about PostgreSQL and RAID in Brazil Josh Berkus
 - indexes make other queries slow! Qing Zhao
 - Re: indexes make other queries slow! Josh Berkus
 - Re: indexes make other queries slow! Jason Coene
 - Re: Partitioning J. Andrew Rogers
 - Re: Article about PostgreSQL and RAID in Brazil Jim C. Nasby
 
- Re: Article about PostgreSQL and RAID in Brazil [email protected]
 - Re: Large # of rows in query extremely slow, not using Stephen Crowley
 - Re: Large # of rows in query extremely slow, not using Joshua D. Drake
 - Re: Data Warehouse Reevaluation - MySQL vs Postgres -- Simon Riggs
 - Re: Large # of rows in query extremely slow, not using Manfred Koizar
 
- Re: Tryint to match Solaris-Oracle performance with directio? Gaetano Mendola
 - Re: Large # of rows in query extremely slow, not using Stephen Crowley
 - Re: Tryint to match Solaris-Oracle performance with directio? [email protected]
 - CPU maximized out! Qing Zhao
 - Tryint to match Solaris-Oracle performance with directio? Mischa Sandberg
 - Re: Tryint to match Solaris-Oracle performance with directio? Tom Lane
 - Planner having way wrong estimate for group aggregate Steinar H. Gunderson
 - Re: Tryint to match Solaris-Oracle performance with directio? Shachar Shemesh
 - Re: Planner having way wrong estimate for group aggregate Tom Lane
 - Re: Planner having way wrong estimate for group aggregate Steinar H. Gunderson
 
- Re: Comparing user attributes with bitwise operators Patrick Clery
 - Re: Comparing user attributes with bitwise operators Greg Stark
 - Re: Tryint to match Solaris-Oracle performance with [email protected]
 - Re: Large # of rows in query extremely slow, not using Josh Berkus
 
- Re: Large # of rows in query extremely slow, not using Manfred Koizar
 - O_DIRECT setting Guy Thornley
 
- vacuum full & max_fsm_pages question Patrick Hatcher
 - Re: vacuum full & max_fsm_pages question Robert Treat
 - Hyper threading? Mariusz Czułada
 - Re: vacuum full & max_fsm_pages question Patrick Hatcher
 - Re: vacuum full & max_fsm_pages question Josh Berkus
 - Re: vacuum full & max_fsm_pages question Patrick Hatcher
 - 7.4 vs 7.3 ( hash join issue ) Gaetano Mendola
 
- Re: 7.4 vs 7.3 ( hash join issue ) Dennis Bjorklund
 - Re: 7.4 vs 7.3 ( hash join issue ) Gaetano Mendola
 - Re: 7.4 vs 7.3 ( hash join issue ) Dennis Bjorklund
 - Re: 7.4 vs 7.3 ( hash join issue ) Gaetano Mendola
 - Re: 7.4 vs 7.3 ( hash join issue ) Greg Stark
 - Re: 7.4 vs 7.3 ( hash join issue ) Dennis Bjorklund
 - Re: 7.4 vs 7.3 ( hash join issue ) Greg Stark
 - Re: 7.4 vs 7.3 ( hash join issue ) Tom Lane
 - Re: 7.4 vs 7.3 ( hash join issue ) Greg Stark
 - Re: 7.4 vs 7.3 ( hash join issue ) Tom Lane
 - Caching of Queries Scott Kirkwood
 - Re: Caching of Queries Tom Lane
 - Infinite CPU loop due to field ::type casting Steven Rosenstein
 - Re: NAS, SAN or any alternate solution ? Andrew Hammond
 - Fw: Infinite CPU loop due to field ::type casting, Take II :-) Steven Rosenstein
 - Re: NAS, SAN or any alternate solution ? Rod Taylor
 - SAN performance Anjan Dave
 - Re: Fw: Infinite CPU loop due to field ::type casting, Take II :-) Tom Lane
 
- Re: Caching of Queries Neil Conway
 - Re: NAS, SAN or any alternate solution ? Greg Stark
 - Re: O_DIRECT setting Neil Conway
 - Re: Caching of Queries Gary Doades
 - Re: Caching of Queries Gaetano Mendola
 - Re: O_DIRECT setting Bruce Momjian
 - Re: Caching of Queries Harald Fuchs
 - Re: 7.4 vs 7.3 ( hash join issue ) Gaetano Mendola
 - Re: O_DIRECT setting Tom Lane
 - Re: Caching of Queries Mr Pink
 - Re: SAN performance Mr Pink
 - Re: vacuum full & max_fsm_pages question Patrick Hatcher
 - Re: Caching of Queries Jason Coene
 - Re: Caching of Queries Tom Lane
 - Re: Caching of Queries Gaetano Mendola
 - Re: Caching of Queries
 - Re: Caching of Queries Jason Coene
 - Re: Caching of Queries Greg Stark
 - Re: Caching of Queries Tom Lane
 - Re: Caching of Queries Matt Clark
 - Re: Caching of Queries Gaetano Mendola
 - Re: Caching of Queries Markus Schaber
 - Re: SAN performance Anjan Dave
 - Re: Caching of Queries Josh Berkus
 - Re: Hyper threading? Greg Copeland
 - Re: Caching of Queries Tom Lane
 - Re: Caching of Queries Jason Coene
 - Re: Caching of Queries Jason Coene
 - Cleaning up indexes Martin Foster
 
- Re: Cleaning up indexes Gregory S. Williamson
 - Re: Large # of rows in query extremely slow, not using Kris Jurka
 - Re: Large # of rows in query extremely slow, not using index Stephen Crowley
 - Re: Large # of rows in query extremely slow, not using Kris Jurka
 - Re: Caching of Queries Josh Berkus
 - Re: Caching of Queries Joshua D. Drake
 - Re: Caching of Queries (now with pgpool) Jason Coene
 - Re: Caching of Queries (now with pgpool) Michael Adler
 - Re: O_DIRECT setting Mark Wong
 - performance of PostgreSQL on 64 bit MAC OS X G5! Qing Zhao
 
- Getting rid of nested loop Rod Taylor
 - Re: Caching of Queries Gaetano Mendola
 - Re: Caching of Queries (now with pgpool) Gaetano Mendola
 
- Re: Cleaning up indexes Bruce Momjian
 - Re: Caching of Queries Aaron Werman
 - Re: SAN performance Andrew Hammond
 
- Re: performance of PostgreSQL on 64 bit MAC OS X G5! Christopher Browne
 - Re: Caching of Queries Neil Conway
 - unsubscribe Amol Bhutada
 - Re: Caching of Queries Tom Lane
 - Performance/Functional Analysis Complete Mark Cotner
 - Re: Caching of Queries Greg Stark
 - Re: Caching of Queries Scott Kirkwood
 - Re: Caching of Queries Mitch Pirtle
 - Re: Caching of Queries Bruce Momjian
 - Re: Caching of Queries Harald Fuchs
 - Re: Caching of Queries Aaron Werman
 - Re: Caching of Queries Matt Clark
 - Re: Caching of Queries Rod Taylor
 - best statistic target for boolean columns Gaetano Mendola
 - Re: Caching of Queries Jeff
 - Re: best statistic target for boolean columns Josh Berkus
 - Re: Caching of Queries Mitch Pirtle
 - Re: best statistic target for boolean columns Gregory Stark
 - Re: Caching of Queries Jim C. Nasby
 - Re: best statistic target for boolean columns Tom Lane
 - Re: Caching of Queries Matt Clark
 - Re: Caching of Queries Matt Clark
 - Re: Caching of Queries Rod Taylor
 - Re: best statistic target for boolean columns Gaetano Mendola
 - Re: Caching of Queries Steve Atkins
 - Re: Caching of Queries Matt Clark
 - Re: Caching of Queries Matt Clark
 - Re: best statistic target for boolean columns Gaetano Mendola
 
- Re: best statistic target for boolean columns Neil Conway
 - Re: best statistic target for boolean columns Gaetano Mendola
 - Re: Caching of Queries Iain
 - Re: Caching of Queries Tom Lane
 - Re: Caching of Queries Iain
 - Re: Caching of Queries Aaron Werman
 - Re: Caching of Queries Tom Lane
 - This query is still running after 10 hours... Robert Creager
 - Re: This query is still running after 10 hours... Kevin Barnard
 - Re: Caching of Queries Aaron Werman
 - Re: This query is still running after 10 hours... Tom Lane
 - Re: This query is still running after 10 hours... Gaetano Mendola
 - Interest in perf testing? Josh Berkus
 
- Re: Caching of Queries Matthew Nuzum
 - Re: This query is still running after 10 hours... Robert Creager
 - Re: This query is still running after 10 hours... Robert Creager
 - Re: This query is still running after 10 hours... Kevin Barnard
 - Re: This query is still running after 10 hours... Robert Creager
 - Re: This query is still running after 10 hours... Robert Creager
 - Re: [pgsql-hackers-win32] Poor Performance for large queries in functions John Meinel
 - Re: [pgsql-hackers-win32] Poor Performance for large queries Richard Huxton
 - Re: This query is still running after 10 hours... Steven Rosenstein
 - Re: Interest in perf testing? Shea,Dan [CIS]
 - Re: [pgsql-hackers-win32] Poor Performance for large queries John Meinel
 - why does explain analyze differ so much from estimated explain? Dirk Lutzebäck
 - Re: [pgsql-hackers-win32] Poor Performance for large queries in functions Tom Lane
 - Re: [pgsql-hackers-win32] Poor Performance for large queries John Meinel
 - stubborn query confuses two different servers SZŰCS Gábor
 - index not used when using function Shiar
 - Re: Interest in perf testing? Gaetano Mendola
 
- Re: O_DIRECT setting Mark Wong
 - Re: O_DIRECT setting Tom Lane
 - Re: O_DIRECT setting Guy Thornley
 - spurious function execution in prepared statements. Merlin Moncure
 - Re: [HACKERS] spurious function execution in prepared statements. Michael Adler
 - Re: [HACKERS] spurious function execution in prepared statements. Merlin Moncure
 - Re: spurious function execution in prepared statements. Stephan Szabo
 - Web server to Database Taking forever Scott Dunn
 - Re: [HACKERS] spurious function execution in prepared statements. Tom Lane
 - Re: spurious function execution in prepared statements. Merlin Moncure
 - Re: spurious function execution in prepared statements. Tom Lane
 - Re: O_DIRECT setting Mark Wong
 - Re: Web server to Database Taking forever Josh Berkus
 - Re: Web server to Database Taking forever Scott Dunn
 - Re: Web server to Database Taking forever Edwin Eyan Moragas
 - Re: Web server to Database Taking forever Scott Marlowe
 - Re: Caching of Queries Jim C. Nasby