• Text Size: Normal / Large
• Donate
• Contact

Section Navigation

• Community
• Contributors
• Mailing Lists
  • Subscribe
  • User lists
    • pgsql-admin
    • pgsql-advocacy
    • pgsql-announce
    • pgsql-bugs
    • pgsql-docs
    • pgsql-general
    • pgsql-jobs
    • pgsql-novice
    • pgsql-performance
    • pgsql-php
    • pgsql-sql
    • pgsql-students
  • Developer lists
  • Regional lists
  • Associations
  • User groups
  • Project lists
  • Inactive lists
• IRC
• Featured Users
• International Sites
• Propaganda
• Resources
• Weekly News
• Community login
  • Profile
  • Lost password

pgsql-performance 2004-09 Chronological Index (2/2)

• Thread Index
• [Prev Page]
• [Next Page]

• 16 September 2004
  • Re: Article about PostgreSQL and RAID in Brazil Steinar H. Gunderson (18:57)
  • Re: Article about PostgreSQL and RAID in Brazil Daniel Ceregatti (18:10)
  • Re: declared cursor uses slow plan Tom Lane (18:07)
  • Article about PostgreSQL and RAID in Brazil Josh Berkus (17:49)
  • Re: Comparing user attributes with bitwise operators Daniel Ceregatti (16:46)
  • Re: Data Warehouse Reevaluation - MySQL vs Postgres -- Joe Conway (15:36)
  • Re: Data Warehouse Reevaluation - MySQL vs Postgres -- Markus Schaber (13:38)
  • Re: Partitioning Mike Rylander (10:58)
  • Re: Data Warehouse Reevaluation - MySQL vs Postgres -- Markus Schaber (10:39)
  • Re: Data Warehouse Reevaluation - MySQL vs Postgres -- Iain (09:08)
  • Re: Comparing user attributes with bitwise operators Greg Stark (08:54)
  • Re: Comparing user attributes with bitwise operators Greg Stark (08:45)
  • Re: Comparing user attributes with bitwise operators Christopher Kings-Lynne (08:08)
  • Comparing user attributes with bitwise operators Patrick Clery (08:00)
  • declared cursor uses slow plan Kevin Neufeld (06:10)
  • Re: Data Warehouse Reevaluation - MySQL vs Postgres -- Joe Conway (05:17)
  • Re: Data Warehouse Reevaluation - MySQL vs Postgres -- Iain (05:08)
  • Re: Data Warehouse Reevaluation - MySQL vs Postgres -- Christopher Kings-Lynne (04:26)
  • Re: Data Warehouse Reevaluation - MySQL vs Postgres -- Steve Atkins (04:09)
  • Re: Data Warehouse Reevaluation - MySQL vs Postgres -- Joe Conway (04:07)
  • Re: Partitioning Greg Stark (03:55)
• 15 September 2004
  • Partitioning J. Andrew Rogers (21:09)
  • Re: Data Warehouse Reevaluation - MySQL vs Postgres -- Joe Conway (20:56)
  • Re: Data Warehouse Reevaluation - MySQL vs Postgres -- Simon Riggs (20:42)
  • Re: Data Warehouse Reevaluation - MySQL vs Postgres -- merge tables? Simon Riggs (20:37)
  • Re: [GENERAL] disk performance benchmarks Ron St-Pierre (17:54)
  • Re: Data Warehouse Reevaluation - MySQL vs Postgres -- Joe Conway (17:34)
  • Re: Data Warehouse Reevaluation - MySQL vs Postgres -- Josh Berkus (17:27)
  • Re: Data Warehouse Reevaluation - MySQL vs Postgres -- Joe Conway (15:15)
  • Re: Data Warehouse Reevaluation - MySQL vs Postgres -- Markus Schaber (09:17)
  • Re: Re: Data Warehouse Reevaluation - MySQL vs Postgres -- simon (09:12)
  • Re: Data Warehouse Reevaluation - MySQL vs Postgres -- Christopher Browne (07:07)
  • Re: Data Warehouse Reevaluation - MySQL vs Postgres -- Leeuw van der, Tim (06:51)
  • Re: Data Warehouse Reevaluation - MySQL vs Postgres -- merge tables Steve Atkins (05:02)
  • Re: Data Warehouse Reevaluation - MySQL vs Postgres -- Iain (04:54)
  • Re: Data Warehouse Reevaluation - MySQL vs Postgres -- Joe Conway (04:30)
  • Re: Data Warehouse Reevaluation - MySQL vs Postgres -- merge tables Chris Browne (03:37)
  • Re: Data Warehouse Reevaluation - MySQL vs Postgres -- merge tables Christopher Browne (03:37)
  • Re: Data Warehouse Reevaluation - MySQL vs Postgres -- merge tables Michael Glaesemann (01:02)
• 14 September 2004
  • Re: Data Warehouse Reevaluation - MySQL vs Postgres -- merge tables Mischa Sandberg (23:37)
  • Re: Data Warehouse Reevaluation - MySQL vs Postgres -- merge tables Simon Riggs (23:14)
  • Re: Data Warehouse Reevaluation - MySQL vs Postgres -- Mischa Sandberg (23:07)
  • Re: Data Warehouse Reevaluation - MySQL vs Postgres -- merge tables Jim C. Nasby (22:33)
  • Re: Data Warehouse Reevaluation - MySQL vs Postgres -- Simon Riggs (20:21)
  • Re: Data Warehouse Reevaluation - MySQL vs Postgres -- merge tables aaron werman (19:32)
  • Re: Large # of rows in query extremely slow, not using Pierre-Frédéric Caillaud (19:26)
  • Re: Data Warehouse Reevaluation - MySQL vs Postgres -- merge tables Vivek Khera (18:27)
  • Re: Determine optimal fdatasync/fsync, O_SYNC/O_DSYNC options Vivek Khera (18:19)
  • Re: Large # of rows in query extremely slow, not using Markus Schaber (16:44)
  • Re: Data Warehouse Reevaluation - MySQL vs Postgres -- merge tables Harald Lau (Sector-X) (15:17)
  • Re: Data Warehouse Reevaluation - MySQL vs Postgres -- Stephen Frost (14:32)
  • Re: Data Warehouse Reevaluation - MySQL vs Postgres -- Michael Kleiser (14:24)
  • Re: Data Warehouse Reevaluation - MySQL vs Postgres -- Harald Fuchs (14:20)
  • Re: Data Warehouse Reevaluation - MySQL vs Postgres -- Leeuw van der, Tim (14:01)
  • Re: Data Warehouse Reevaluation - MySQL vs Postgres -- Steinar H. Gunderson (13:33)
  • Re: Data Warehouse Reevaluation - MySQL vs Postgres -- merge tables Aaron Werman (13:28)
  • Re: Data Warehouse Reevaluation - MySQL vs Postgres -- Leeuw van der, Tim (12:43)
  • Re: Data Warehouse Reevaluation - MySQL vs Postgres -- Markus Schaber (12:15)
  • Re: Data Warehouse Reevaluation - MySQL vs Postgres -- merge tables Pierre-Frédéric Caillaud (09:06)
  • Re: Data Warehouse Reevaluation - MySQL vs Postgres -- merge tables Mark Cotner (07:39)
  • Re: Large # of rows in query extremely slow, not using index Stephen Crowley (06:04)
  • Re: Four table join with million records - performance improvement? Tom Lane (04:58)
  • Re: tblspaces integrated in new postgresql (version 8.0) Tom Lane (04:52)
  • Re: Determine optimal fdatasync/fsync, O_SYNC/O_DSYNC options Tom Lane (02:01)
  • Re: Large # of rows in query extremely slow, not using index Tom Lane (01:49)
  • Re: Determine optimal fdatasync/fsync, O_SYNC/O_DSYNC options Gaetano Mendola (01:39)
  • Re: Determine optimal fdatasync/fsync, O_SYNC/O_DSYNC options Bruce Momjian (01:28)
  • Re: Large # of rows in query extremely slow, not using index Stephen Crowley (01:22)
  • Re: Large # of rows in query extremely slow, not using index Tom Lane (01:11)
  • Re: Large # of rows in query extremely slow, not using Rod Taylor (01:11)
  • Large # of rows in query extremely slow, not using index Stephen Crowley (00:51)
• 13 September 2004
  • Re: Data Warehouse Reevaluation - MySQL vs Postgres -- merge tables Simon Riggs (21:50)
  • Re: Determine optimal fdatasync/fsync, O_SYNC/O_DSYNC options Tom Lane (21:18)
  • Re: Determine optimal fdatasync/fsync, O_SYNC/O_DSYNC options Josh Berkus (21:15)
  • Re: Determine optimal fdatasync/fsync, O_SYNC/O_DSYNC options Gaetano Mendola (20:36)
  • Re: Determine optimal fdatasync/fsync, O_SYNC/O_DSYNC options mudfoot (19:32)
  • tblspace Bill Fefferman (16:54)
  • Re: Determine optimal fdatasync/fsync, O_SYNC/O_DSYNC options Bruce Momjian (14:38)
  • Re: Help with extracting large volumes of records across related tables Pierre-Frédéric Caillaud (13:59)
  • Re: Help with extracting large volumes of records across related tables Damien Dougan (13:44)
  • Re: Help with extracting large volumes of records across related Mischa Sandberg (13:06)
  • Re: Help with extracting large volumes of records across related tables Pierre-Frédéric Caillaud (13:04)
  • Re: Help with extracting large volumes of records across related tables Pierre-Frédéric Caillaud (13:00)
  • Re: Help with extracting large volumes of records across related tables Paul Thomas (12:12)
  • Help with extracting large volumes of records across related tables Damien Dougan (11:38)
  • Re: Data Warehouse Reevaluation - MySQL vs Postgres -- merge tables Christopher Browne (10:06)
  • Re: Data Warehouse Reevaluation - MySQL vs Postgres -- merge tables Mark Cotner (07:58)
  • Determine optimal fdatasync/fsync, O_SYNC/O_DSYNC options mudfoot (06:11)
  • Four table join with million records - performance improvement? Vijay Moses (04:30)
  • Re: Data Warehouse Reevaluation - MySQL vs Postgres -- merge tables Christopher Browne (03:06)
  • Re: TSearch2 and optimisation ... George Essig (03:04)
  • tblspaces integrated in new postgresql (version 8.0) bill (01:35)
• 12 September 2004
  • Re: Data Warehouse Reevaluation - MySQL vs Postgres -- merge tables Mischa Sandberg (21:06)
  • Re: Data Warehouse Reevaluation - MySQL vs Postgres Gaetano Mendola (09:36)
  • Re: Data Warehouse Reevaluation - MySQL vs Postgres Dennis Bjorklund (05:23)
  • Data Warehouse Reevaluation - MySQL vs Postgres Mark Cotner (04:24)
• 11 September 2004
  • Re: Bad performance with hashjoin Tom Lane (15:28)
  • Bad performance with hashjoin Vitaly Belman (12:45)
  • Re: Stuck using Sequential Scan Oliver Elphick (06:07)
• 10 September 2004
  • Re: Interesting performance behaviour Tom Lane (22:10)
  • Re: effective_cache_size in 7.3.4? Josh Berkus (22:03)
  • Fwd: Interesting performance behaviour Joey Smith (22:02)
  • Re: Interesting performance behaviour Joey Smith (22:01)
  • effective_cache_size in 7.3.4? ogjunk-pgjedan (22:00)
  • Re: Interesting performance behaviour Josh Berkus (21:45)
  • Interesting performance behaviour Joey Smith (21:02)
  • Question on Byte Sizes Pierre-Frédéric Caillaud (13:22)
  • Re: Multiple Uniques Greg Stark (06:34)
  • Re: Costly "Sort Key" on indexed timestamp column Tom Lane (04:17)
  • Re: Multiple Uniques Tom Lane (03:07)
• 09 September 2004
  • Re: Multiple Uniques Neil Conway (23:06)
  • Costly "Sort Key" on indexed timestamp column ogjunk-pgjedan (22:51)
  • Re: fsync vs open_sync Mark Wong (17:13)
  • Re: TSearch2 and optimisation ... Hervé Piedvache (14:56)
  • Re: [GENERAL] Text Search vs MYSQL vs Lucene Shridhar Daithankar (13:39)
• 08 September 2004
  • Re: Equivalent praxis to CLUSTERED INDEX? Mischa Sandberg (16:06)
  • Re: Problem with large query Marc Cousin (15:17)
  • Re: Problem with large query Tom Lane (14:56)
  • Re: Problem with large query Marc Cousin (14:50)
  • Re: Problem with large query Adam Sah (14:47)
  • Re: Problem with large query Tom Lane (14:40)
  • Problem with large query Marc Cousin (13:50)
  • Stuck using Sequential Scan Jeremy M. Guthrie (00:49)
• 07 September 2004
  • Re: The usual sequential scan, but with LIMIT ! Gaetano Mendola (17:05)
  • Re: The usual sequential scan, but with LIMIT ! Pierre-Frédéric Caillaud (14:30)
  • Re: [ADMIN] TOAST tables, cannot truncate Tom Lane (14:16)
  • Re: The usual sequential scan, but with LIMIT ! Tom Lane (13:47)
  • Re: [ADMIN] TOAST tables, cannot truncate G u i d o B a r o s i o (11:13)
  • TOAST tables, cannot truncate G u i d o B a r o s i o (10:41)
  • Re: The usual sequential scan, but with LIMIT ! Pierre-Frédéric Caillaud (06:51)
• 06 September 2004
  • Re: The usual sequential scan, but with LIMIT ! Tom Lane (16:40)
  • Re: Multiple Uniques Markus Schaber (15:56)
  • Re: The usual sequential scan, but with LIMIT ! Dennis Bjorklund (12:45)
  • Re: The usual sequential scan, but with LIMIT ! Pierre-Frédéric Caillaud (12:26)
  • The usual sequential scan, but with LIMIT ! Pierre-Frédéric Caillaud (12:15)
  • Re: Tanking a server with shared memory Tom Lane (02:18)
  • Tanking a server with shared memory Martin Foster (01:34)
  • Re: Table UPDATE is too slow Kevin Barnard (01:19)
• 05 September 2004
  • Re: Table UPDATE is too slow Marinos J. Yannikos (23:28)
  • Re: fsync vs open_sync Pierre-Frédéric Caillaud (18:02)
  • Re: fsync vs open_sync Pierre-Frédéric Caillaud (18:01)
  • Re: Dump/Restore performance improvement Tom Lane (17:07)
  • Re: fsync vs open_sync Geoffrey (16:52)
  • Re: fsync vs open_sync Steve Bergman (05:16)
  • Dump/Restore performance improvement Adi Alurkar (04:07)
  • Re: fsync vs open_sync Christopher Browne (04:04)
  • Re: fsync vs open_sync Cott Lang (02:46)
• 04 September 2004
  • Re: fsync vs open_sync Gaetano Mendola (13:07)
  • Re: fsync vs open_sync Pierre-Frédéric Caillaud (04:02)
  • Re: fsync vs open_sync Merlin Moncure (03:57)
  • restoring to wrong encoding db Vivek Khera (03:40)
• 02 September 2004
  • Re: Multiple Uniques Greg Stark (19:33)
  • Re: Multiple Uniques Tom Lane (14:22)
  • Multiple Uniques Markus Schaber (13:43)
• 01 September 2004
  • Re: seqscan instead of index scan Merlin Moncure (17:53)
  • Re: Changing the column length Josh Berkus (16:33)
  • Re: seqscan instead of index scan Chester Kustarz (15:47)
  • Re: [ADMIN] slower every day G u i d o B a r o s i o (15:07)
  • Re: [ADMIN] slower every day Michael Paesold (14:28)
  • Re: Why does a simple query not use an obvious index? Mr Pink (12:50)
  • Re: [ADMIN] slower every day Richard Huxton (12:27)
  • Re: [ADMIN] slower every day G u i d o B a r o s i o (11:58)
  • Re: [ADMIN] slower every day G u i d o B a r o s i o (10:57)
  • Re: slower every day Shridhar Daithankar (10:25)
  • slower every day G u i d o B a r o s i o (10:06)
  • Re: Query performance issue with 8.0.0beta1 Stefano Bonnin (09:15)
  • Re: Changing the column length gnari (08:45)
  • Fw: Query performance issue with 8.0.0beta1 Stefano Bonnin (07:53)
  • Changing the column length Michael Ryan S. Puncia (06:46)
  • Re: Table UPDATE is too slow Tom Lane (05:32)

• Thread Index
• [Prev Page]
• [Next Page]