Re: [PERFORM] Really bad diskio

2005-07-16 Thread Ron Wills
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

Re: [PERFORM] Really bad diskio

2005-07-15 Thread Ron Wills
At Fri, 15 Jul 2005 14:53:26 -0700, Jeffrey W. Baker wrote: > > On Fri, 2005-07-15 at 15:29 -0600, Ron Wills wrote: > > Here's a bit of a dump of the system that should be useful. > > > > Processors x2: > > > > vendor_id : AuthenticAMD > &

Re: [PERFORM] Really bad diskio

2005-07-15 Thread Ron Wills
At Fri, 15 Jul 2005 14:17:34 -0700, Jeffrey W. Baker wrote: > > On Fri, 2005-07-15 at 15:04 -0600, Ron Wills wrote: > > At Fri, 15 Jul 2005 13:45:07 -0700, > > Joshua D. Drake wrote: > > > > > > Ron Wills wrote: > > > > Hello all > > > &g

Re: [PERFORM] Really bad diskio

2005-07-15 Thread Ron Wills
At Fri, 15 Jul 2005 14:00:07 -0700, Jeffrey W. Baker wrote: > > On Fri, 2005-07-15 at 14:39 -0600, Ron Wills wrote: > > 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 on

Re: [PERFORM] Really bad diskio

2005-07-15 Thread Ron Wills
At Fri, 15 Jul 2005 13:45:07 -0700, Joshua D. Drake wrote: > > Ron Wills wrote: > > Hello all > > > > I'm running a postgres 7.4.5, on a dual 2.4Ghz Athlon, 1Gig RAM and > > an 3Ware SATA raid. > > 2 drives? > 4 drives? > 8 drives? 3 dri

[PERFORM] Really bad diskio

2005-07-15 Thread Ron Wills
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 50+ row, one table 20+ row and a few small tables. The larger tables get updated about every two hours. The problem I having with