From: Maila Fatticcioni <mfatticcioni@mbigroup.it>
To: Patrick Krecker <patrick@judicata.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: Tuning the configuration
Date: Thu, 11 Dec 2014 09:11:19 +0100
Message-ID: <548951A7.6090407@mbigroup.it> (raw)
In-Reply-To: <CAK2mJFMGJBBytN6KR-AQ1_SqDxNoXK3RUaCMqZ=c6YU374tRRw@mail.gmail.com>
References: <548823F8.4070003@mbigroup.it>
<CAK2mJFMGJBBytN6KR-AQ1_SqDxNoXK3RUaCMqZ=c6YU374tRRw@mail.gmail.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-performance>
-----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
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: mfatticcioni@mbigroup.it, patrick@judicata.com
Subject: Re: Tuning the configuration
In-Reply-To: <548951A7.6090407@mbigroup.it>
* 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