Message-ID: <548951A7.6090407@mbigroup.it>
Date: Thu, 11 Dec 2014 09:11:19 +0100
From: Maila Fatticcioni <mfatticcioni@mbigroup.it>
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: Patrick Krecker <patrick@judicata.com>
CC: pgsql-performance@postgresql.org
Subject: Re: Tuning the configuration
References: <548823F8.4070003@mbigroup.it>
 <CAK2mJFMGJBBytN6KR-AQ1_SqDxNoXK3RUaCMqZ=c6YU374tRRw@mail.gmail.com>
In-Reply-To: 
 <CAK2mJFMGJBBytN6KR-AQ1_SqDxNoXK3RUaCMqZ=c6YU374tRRw@mail.gmail.com>
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit
Precedence: bulk
Sender: pgsql-performance-owner@postgresql.org

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On 12/10/2014 06:47 PM, Patrick Krecker wrote:
> On Wed, Dec 10, 2014 at 2:44 AM, Maila Fatticcioni 
> <mfatticcioni@mbigroup.it> wrote: 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
>> 
>> 
>> -- Sent via pgsql-performance mailing list
>> (pgsql-performance@postgresql.org) To make changes to your
>> subscription: 
>> http://www.postgresql.org/mailpref/pgsql-performance
> 
> We used [1] to great effect when setting our server up. We have
> not had to diverge much from the recommendations in that document.
> 
> Generally, the specifics of tuning depend on the workload of your 
> specific instance.
> 
> [1] https://wiki.postgresql.org/wiki/Tuning_Your_PostgreSQL_Server
> 

Hello.
Indeed I followed this document to set up my configuration. I am glad
that you recommend this as well.

Eventually I use this setup:

max_connections = 150
shared_buffers = 8GB
work_mem = 32MB
checkpoint_segments = 128
checkpoint_completion_target = 0.9

Best Regards,
Maila Fatticcioni
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1

iEYEARECAAYFAlSJUaEACgkQi2q3wPb3FcPsuQCeLR5P49d60anErETNiX0iHNLe
Eu4An0QN3nzr/kvlPUTm9Q1A0GkjB/gw
=kdGU
-----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