From: Ioannis Anagnostopoulos <ioannis@anatec.com>
To: pgsql-performance@postgresql.org
Subject: Heavy inserts load wile querying...
Date: Tue, 24 Jul 2012 14:22:34 +0100
Message-ID: <500EA19A.4040207@anatec.com> (raw)
In-Reply-To: <500E9A3B.3070609@shopzeus.com>
References: <500E9A3B.3070609@shopzeus.com>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: ioannis@anatec.com
Subject: Re: Heavy inserts load wile querying...
In-Reply-To: <500EA19A.4040207@anatec.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox