-----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@xxxxxxxxxxx> 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@xxxxxxxxxxxxxx) 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@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
