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 Joshua D. Drake
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? RAID 1? 0? 10? 5? Currently the database is only 16G with about 2 tables with 50+ row, one table 20+ row and a few small tables. The

[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

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 drives raid 5. I don't believe it's the raid. I've tested this by

Re: [PERFORM] Really bad diskio

2005-07-15 Thread Dan Harris
On Jul 15, 2005, at 2:39 PM, 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. Operating System? Which file system are you using? I was having a similar problem just a few days ago and learned that ext3 was the

Re: [PERFORM] Really bad diskio

2005-07-15 Thread Alvaro Herrera
On Fri, Jul 15, 2005 at 03:04:35PM -0600, Ron Wills 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. 3 drives raid 5. I don't believe it's the raid. I've tested this by moving the database to the

Re: [PERFORM] Really bad diskio

2005-07-15 Thread Jeffrey W. Baker
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 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

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 only 16G with about 2 tables with 50+ row,

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 I'm running a postgres 7.4.5, on a dual 2.4Ghz Athlon, 1Gig RAM and

Re: [PERFORM] Really bad diskio

2005-07-15 Thread Jeffrey W. Baker
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 cpu family : 6 model : 8 model name : AMD Athlon(tm) MP 2400+ stepping: 1 cpu MHz : 2000.474

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 cpu family : 6 model : 8 model name :