Re: [PERFORM] disk I/O problems and Solutions

2009-10-09 Thread Scott Carey
> >> any thoughts here?  recommendations on what to do with a tight budget? >>  It could be the answer is that I just have to go back to the bean >> counters and tell them we have no choice but to start spending some >> real money.  But on what?  And how do I prove that this is the only >> choice

Re: [PERFORM] disk I/O problems and Solutions

2009-10-09 Thread David Rees
On Fri, Oct 9, 2009 at 9:45 AM, Alan McKay wrote: > We've just discovered thanks to a new Munin plugin > http://blogs.amd.co.at/robe/2008/12/graphing-linux-disk-io-statistics-with-munin.html > that our production DB is completely maxing out in I/O for about a 3 > hour stretch from 6am til 9am > Th

Re: [PERFORM] disk I/O problems and Solutions

2009-10-09 Thread Scott Marlowe
On Fri, Oct 9, 2009 at 10:45 AM, Alan McKay wrote: > Hey folks, > > CentOS / PostgreSQL shop over here. > > I'm hitting 3 of my favorite lists with this, so here's hoping that > the BCC trick is the right way to do it :-) I added pgsql-performance back in in my reply so we can share with the rest

Re: [PERFORM] disk I/O problems and Solutions

2009-10-09 Thread Flavio Henrique Araque Gurgel
- "Alan McKay" escreveu: > CentOS / PostgreSQL shop over here. > > Our system > IBM 3650 - quad 2Ghz e5405 Xeon > 8K SAS RAID Controller > 6 x 300G 15K/RPM SAS Drives > /dev/sda - 2 drives configured as a RAID 1 for 300G for the OS > /dev/sdb - 3 drives configured as RAID5 for 600G for the DB

[PERFORM] disk I/O problems and Solutions

2009-10-09 Thread Alan McKay
Hey folks, CentOS / PostgreSQL shop over here. I'm hitting 3 of my favorite lists with this, so here's hoping that the BCC trick is the right way to do it :-) We've just discovered thanks to a new Munin plugin http://blogs.amd.co.at/robe/2008/12/graphing-linux-disk-io-statistics-with-munin.html