Архив рассылок [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: 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: [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
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: 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
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 ! 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 ! 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
Re: Multiple Uniques Neil Conway
Re: Multiple Uniques 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
Re: Interesting performance behaviour Joey Smith
Fwd: Interesting performance behaviour Joey Smith
Re: effective_cache_size in 7.3.4? Josh Berkus
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 Christopher Browne
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 Pierre-Frédéric Caillaud
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
Large # of rows in query extremely slow, not using index Stephen Crowley
Re: Large # of rows in query extremely slow, not using index Stephen Crowley
Re: Determine optimal fdatasync/fsync, O_SYNC/O_DSYNC options Gaetano Mendola
tblspaces integrated in new postgresql (version 8.0) bill@uchicago.edu
tblspace Bill Fefferman
Re: Help with extracting large volumes of records across related Mischa Sandberg
Re: Large # of rows in query extremely slow, not using index Stephen Crowley
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 -- Steinar H. Gunderson
Re: Data Warehouse Reevaluation - MySQL vs Postgres -- Leeuw van der, Tim
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: Large # of rows in query extremely slow, not using Pierre-Frédéric Caillaud
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 -- Leeuw van der, Tim
Re: Data Warehouse Reevaluation - MySQL vs Postgres -- Christopher Browne
Re: Data Warehouse Reevaluation - MySQL vs Postgres -- Markus Schaber
Re: [GENERAL] disk performance benchmarks Ron St-Pierre
Partitioning J. Andrew Rogers
Re: Partitioning Greg Stark
Re: Data Warehouse Reevaluation - MySQL vs Postgres -- Mischa Sandberg
Re: Data Warehouse Reevaluation - MySQL vs Postgres -- Christopher Kings-Lynne
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: Data Warehouse Reevaluation - MySQL vs Postgres -- Markus Schaber
Re: Partitioning Mike Rylander
Re: Data Warehouse Reevaluation - MySQL vs Postgres -- Markus Schaber
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 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: 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
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 Steinar H. Gunderson
Re: Comparing user attributes with bitwise operators Patrick Clery
Re: Tryint to match Solaris-Oracle performance with markir@coretech.co.nz
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: 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 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 index Stephen Crowley
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
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: 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: 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 Tom Lane
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... 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 Richard Huxton
Re: This query is still running after 10 hours... Steven Rosenstein
Re: Interest in perf testing? Shea,Dan [CIS]
stubborn query confuses two different servers SZŰCS Gábor
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: spurious function execution in prepared statements. Stephan Szabo
Web server to Database Taking forever Scott Dunn
Re: spurious function execution in prepared statements. Merlin Moncure
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
