Scott Marlowe wrote: > On Mon, 2006-06-26 at 08:59, Tony Caduto wrote: > >> MG wrote: >> >>> Hello, >>> >>> we are using PostgreSQL 8.0.3 together with RAID on OpenServer 6. >>> >>> When we do a big SELECT-query the whole maschine becomes very very >>> very slowly or stands. >>> The maschine has 3 GB RAM, so we suppose it`s the RAID. >>> >>> Has anyone some experience with RAID + PostgreSQL? >>> >>> Where does PostgreSQL saves his temporary files? Perhaps these are the >>> reason for the bad performance. >>> >>> Greetings >>> >>> Michaela >>> >> What kind of RAID? I know if you have it set up to mirror it becomes >> slow as pond water. >> > > I have to say this has NOT been my experience. With a pair of U320 > drives on an LSI-Megaraid with battery backed cache (256M or 512M, not > sure which it was, it's been a few years) our pg server was noticeable > faster with a mirror set than with a single IDE drive (with cache > disabled) on the same machine. And faster than a single SCSI drive with > no RAID controller as well. > > Hi Scott,
We are just using the compaq hardware SCSI //raid included with the server and it does not have a battery backed cache. Actually my test DB running the same queries on a cheap IDE drive (on a Athlon 2200+ where 50% faster than the compaq running the mirrored SCSI drives. The compaq system was also a Dual 2.4 gzh Xeon with 2.5 GB of memory and the Athlon had 512mb. Some of the performance on the Athlon could be attributed to the CPU, but mostly the IDE drive just blew away the mirrored SCSI drive On the Compaq system setting Fsync to false increased the speed of all select statements, not just complex ones with sorting.
I didn't set up the hardware, so I don't know if the system admin guy screwed anything up in the raid setup.
Later,
-- Tony Caduto AM Software Design http://www.amsoftwaredesign.com Home of PG Lightning Admin for Postgresql Your best bet for Postgresql Administration
---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ?