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