Mailing lists [pgsql-performance]
- Re: Table UPDATE is too slow Ron St-Pierre
- 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 mudfoot@rawbw.com
- 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 mudfoot@rawbw.com
- 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) bill@uchicago.edu
- 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 mudfoot@rawbw.com
- 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? mudfoot@rawbw.com
- 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 markir@coretech.co.nz
- 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