At Fri, 15 Jul 2005 14:39:36 -0600, Ron Wills wrote: I just wanted to thank everyone for their help. I believe we found a solution that will help with this problem, with the hardware configuration and caching the larger tables into smaller data sets. A valuable lesson learned from this ;)
> Hello all > > I'm running a postgres 7.4.5, on a dual 2.4Ghz Athlon, 1Gig RAM and > an 3Ware SATA raid. Currently the database is only 16G with about 2 > tables with 500000+ row, one table 200000+ row and a few small > tables. The larger tables get updated about every two hours. The > problem I having with this server (which is in production) is the disk > IO. On the larger tables I'm getting disk IO wait averages of > ~70-90%. I've been tweaking the linux kernel as specified in the > PostgreSQL documentations and switched to the deadline > scheduler. Nothing seems to be fixing this. The queries are as > optimized as I can get them. fsync is off in an attempt to help > preformance still nothing. Are there any setting I should be look at > the could improve on this??? > > Thanks for and help in advance. > > Ron > > ---------------------------(end of broadcast)--------------------------- > TIP 1: if posting/reading through Usenet, please send an appropriate > subscribe-nomail command to [EMAIL PROTECTED] so that your > message can get through to the mailing list cleanly ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org