Skip site navigation (1) Skip section navigation (2)

Heavy inserts load wile querying...

From: Ioannis Anagnostopoulos <ioannis(at)anatec(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: Heavy inserts load wile querying...
Date: 2012-07-24 13:22:34
Message-ID: 500EA19A.4040207@anatec.com (view raw or flat)
Thread:
Lists: pgsql-performance
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?

Kind Regards
Yiannis

In response to

Responses

pgsql-performance by date

Next:From: Greg StarkDate: 2012-07-24 13:33:26
Subject: Re: Checkpointer split has broken things dramatically (was Re: DELETE vs TRUNCATE explanation)
Previous:From: Ivan VorasDate: 2012-07-24 13:18:29
Subject: Re: ZFS vs. UFS

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group