From: Ogden <lists@darkstatic.com>
To: pgsql-performance@postgresql.org
Subject: Tuning Tips for a new Server
Date: Tue, 16 Aug 2011 20:35:03 -0500
Message-ID: <959BD2FA-0312-458B-BD5F-ED358D2C47ED@darkstatic.com> (raw)
Hope all is well. I have received tremendous help from this list prior and therefore wanted some more advice.
I bought some new servers and instead of RAID 5 (which I think greatly hindered our writing performance), I configured 6 SCSI 15K drives with RAID 10. This is dedicated to /var/lib/pgsql. The main OS has 2 SCSI 15K drives on a different virtual disk and also Raid 10, a total of 146Gb. I was thinking of putting Postgres' xlog directory on the OS virtual drive. Does this even make sense to do?
The system memory is 64GB and the CPUs are dual Intel E5645 chips (they are 6-core each).
It is a dedicated PostgreSQL box and needs to support heavy read and moderately heavy writes.
Currently, I have this for the current system which as 16Gb Ram:
max_connections = 350
work_mem = 32MB
maintenance_work_mem = 512MB
wal_buffers = 640kB
# This is what I was helped with before and made reporting queries blaze by
seq_page_cost = 1.0
random_page_cost = 3.0
cpu_tuple_cost = 0.5
effective_cache_size = 8192MB
Any help and input is greatly appreciated.
Thank you
Ogden
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 from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-performance@postgresql.org
Cc: lists@darkstatic.com
Subject: Re: Tuning Tips for a new Server
In-Reply-To: <959BD2FA-0312-458B-BD5F-ED358D2C47ED@darkstatic.com>
References: <959BD2FA-0312-458B-BD5F-ED358D2C47ED@darkstatic.com>
* 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