On Monday 26 June 2006 00:36, MG wrote: > Hello, > > we are using PostgreSQL 8.0.3 together with RAID on OpenServer 6.
I'm sorry. > > 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. Or your database structure, a badly written query, lack of statistics, too many dead rows, lack of vacuuming, bad postgresql.conf settings, or using an aggregate without a where clause over millions of rows. > > Has anyone some experience with RAID + PostgreSQL? Lots... What type of raid? How many drives? > > Where does PostgreSQL saves his temporary files? Perhaps these are the > reason for the bad performance. I would suggest looking at the above half a dozen possibilities as well. Sincerely, Joshua D. Drake > > Greetings > > Michaela ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
