| From: | Ron Wills <ron(at)rwsoft(dot)ca> |
|---|---|
| To: | pgsql-performance(at)postgresql(dot)org |
| Subject: | Really bad diskio |
| Date: | 2005-07-15 20:39:36 |
| Message-ID: | 8764vbby7r.wl%ron@rwsoft.ca |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Joshua D. Drake | 2005-07-15 20:45:07 | Re: Really bad diskio |
| Previous Message | PFC | 2005-07-15 17:39:30 | Re: slow joining very large table to smaller ones |