On Tue, Jul 24, 2012 at 6:22 AM, Ioannis Anagnostopoulos <ioan...@anatec.com > wrote:
> Hello, > The Postres 9.0 database we use gets about 20K inserts per minute. As long > as you don't query at the same time the database is copying fine. However > long running queries seems to delay so much the db that the application > server buffers the incoming data as it cannot insert them fast enough. The > server has 4 HD. One is used for archive, past static tables, the second is > the index of the current live tables and the third is the current data. The > fourth is the OS. > > The serve specs are: > Intel(R) Xeon(R) CPU W3520 @ 2.67GHz > 4 cores > 18GB Ram > > Do you think that this work load is high that requires an upgrade to > cluster or RAID 10 to cope with it? > You need to learn more about what exactly is your bottleneck ... memory, CPU, or I/O. That said, I suspect you'd be way better off with this hardware if you built a single software RAID 10 array and put everything on it. Right now, the backup disk and the OS disk are sitting idle most of the time. With a RAID10 array, you'd at least double, maybe quadruple your I/O. And if you added a battery-backed RAID controller, you'd have a pretty fast system. Craig > > Kind Regards > Yiannis > > -- > Sent via pgsql-performance mailing list (pgsql-performance@postgresql.** > org <pgsql-performance@postgresql.org>) > To make changes to your subscription: > http://www.postgresql.org/**mailpref/pgsql-performance<http://www.postgresql.org/mailpref/pgsql-performance> >
