Received: from makus.postgresql.org (makus.postgresql.org [98.129.198.125]) by mail.postgresql.org (Postfix) with ESMTP id 53C105F9CED for ; Tue, 24 Jul 2012 10:22:59 -0300 (ADT) Received: from mail.anatec.com ([87.84.168.242]) by makus.postgresql.org with smtp (Exim 4.72) (envelope-from ) id 1Stf4i-0008HV-Ne for pgsql-performance@postgresql.org; Tue, 24 Jul 2012 13:22:58 +0000 Received: from [192.168.10.57] ([192.168.10.57]) by mail.anatec.com over TLS secured channel with Microsoft SMTPSVC(6.0.3790.4675); Tue, 24 Jul 2012 14:22:36 +0100 Message-ID: <500EA19A.4040207@anatec.com> Date: Tue, 24 Jul 2012 14:22:34 +0100 From: Ioannis Anagnostopoulos User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:14.0) Gecko/20120713 Thunderbird/14.0 MIME-Version: 1.0 To: pgsql-performance@postgresql.org Subject: Heavy inserts load wile querying... References: <500E9A3B.3070609@shopzeus.com> In-Reply-To: <500E9A3B.3070609@shopzeus.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-OriginalArrivalTime: 24 Jul 2012 13:22:36.0825 (UTC) FILETIME=[645E9890:01CD699F] X-Pg-Spam-Score: -1.9 (-) X-Archive-Number: 201207/296 X-Sequence-Number: 47477 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