Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1Xyekf-0004Q1-DW for pgsql-performance@arkaria.postgresql.org; Wed, 10 Dec 2014 10:44:13 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1Xyeke-0003Gt-Q3 for pgsql-performance@arkaria.postgresql.org; Wed, 10 Dec 2014 10:44:12 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:DHE_RSA_AES_256_CBC_SHA256:256) (Exim 4.80) (envelope-from ) id 1Xyekd-0003Gm-Vz for pgsql-performance@postgresql.org; Wed, 10 Dec 2014 10:44:12 +0000 Received: from ms.mbigroup.it ([84.233.239.90]) by magus.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1Xyekb-0007bn-DQ for pgsql-performance@postgresql.org; Wed, 10 Dec 2014 10:44:10 +0000 Received: from localhost (localhost [127.0.0.1]) by ms.mbigroup.it (Postfix) with ESMTP id C5B7F1C093C for ; Wed, 10 Dec 2014 11:44:08 +0100 (CET) X-Virus-Scanned: Debian amavisd-new at ms.mbigroup.it Received: from ms.mbigroup.it ([127.0.0.1]) by localhost (ms.mbigroup.it [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id TQx6eXxvN6X4 for ; Wed, 10 Dec 2014 11:44:08 +0100 (CET) Received: from mailserver0.bo.mbigroup.it (mailserver1.bo.mbigroup.it [192.168.10.31]) by ms.mbigroup.it (Postfix) with ESMTPS id 3822F1C0909 for ; Wed, 10 Dec 2014 11:44:08 +0100 (CET) Received: from localhost (localhost [127.0.0.1]) by mailserver0.bo.mbigroup.it (Postfix) with ESMTP id 854732C11FA for ; Wed, 10 Dec 2014 11:44:08 +0100 (CET) X-Virus-Scanned: Debian amavisd-new at mbigroup.it Received: from mailserver0.bo.mbigroup.it ([127.0.0.1]) by localhost (mailserver1.bo.mbigroup.it [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id kO7i1PULrVQ9 for ; Wed, 10 Dec 2014 11:44:08 +0100 (CET) Received: from [192.168.27.201] (unknown [192.168.27.201]) by mailserver0.bo.mbigroup.it (Postfix) with ESMTP id 12A5C2C11F9 for ; Wed, 10 Dec 2014 11:44:08 +0100 (CET) Message-ID: <548823F8.4070003@mbigroup.it> Date: Wed, 10 Dec 2014 11:44:08 +0100 From: Maila Fatticcioni Reply-To: mfatticcioni@mbigroup.it Organization: MBI S.r.l. User-Agent: Mozilla/5.0 (X11; Linux i686; rv:31.0) Gecko/20100101 Thunderbird/31.3.0 MIME-Version: 1.0 To: pgsql-performance@postgresql.org Subject: Tuning the configuration Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-Pg-Spam-Score: -1.1 (-) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-performance Precedence: bulk Sender: pgsql-performance-owner@postgresql.org -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Hello. I need to tune a postgres installation I've just made to get a better performance. I use two identical servers with a hot replication configuration. The two servers have the following hardware: Dual Processor Intel Xeon E5-2640V2 20Mb cache 2.00Ghz, Ram Mem. 32Gb DDR-3 Ecc Registered, Controller MegaRaid 8-ports 1Gb cache, 4 Enterprise Hdd NL Sas 600 4Tb Sata, 2 Samsung SSD 840 Pro Series 512Gb, 2 Hdd 500 Gb I made a software raid with the last two hard disks with ext4 and I installed Ubuntu 14.04.1 LTS (I have to use this SO) on it. I made a hardware raid with the four SAS hard disks and I mount the partition on it with ext4 without journaling and I put the database on it. Now I have two more steps to do. 1- could you please help tuning the configuration? What are the best value I should use for wal_buffers and shared_buffers? 2- I would like to use the two SDD to store the wal file. Do you think it is useful or how should I use them? Thank you for your answers. Best Regards, Maila Fatticcioni -----BEGIN PGP SIGNATURE----- Version: GnuPG v1 iEYEARECAAYFAlSII/gACgkQi2q3wPb3FcPUuACgg2m2o9dQWavLrN2EmmmCpGEv YnMAoN0R/gejcKwnxf0qFPKXtaGaIG1A =oLxU -----END PGP SIGNATURE----- -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance