• 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 Thread Index (2/2)

• Main Index
• [Prev Page]
• [Next Page]

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

---

• Main Index
• [Prev Page]
• [Next Page]

---

Mail converted by MHonArc