From: Steve Kecskes <steve@outtalimits.com.au>
To: pgsql-admin@postgresql.org
Subject: Recourse Usage
Date: Fri, 04 Jul 2008 09:28:05 +1000
Message-ID: <aaac5b98d66b210979ba99862accdfc0@outtalimits.com.au> (raw)
G'day,
I have been tasked to tune our company's Postgres database. From the
research I have done I feel the recourse consumption parameters are set far
to low. I have come up with the following modifications to the
configuration and wanted to run this by the mailing list for any
suggestions. The database is on a semi dedicated box, shared only with
memcached which has been allocated 512MB.
-Dual Xeon 2.33GHz
-4GB RAM
-Twin SAS drives in RAID 1
Shared Buffers
Currently: 8192 pages @ 8 KB each // 64MB
To be set to: (256MB - 32768 pages @ 8 KB each)
Work Mem
Currently: 1024kb
To be set to: 1536kb
Effective Cache Size
Currently: 50000 pages // 390MB
To be set to: 128000 pages // 1000MB
Random Page Cost
Currently: 4.0
To be set to: 3.0
Wal Buffers
Currently: 8 @ 8kb each
To be set to: 32 @ 8kb each
Kind Regards,
--
-------------------------------------------------
Steve Kecskes
steve@outtalimits.com.au
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-admin@postgresql.org
Cc: steve@outtalimits.com.au
Subject: Re: Recourse Usage
In-Reply-To: <aaac5b98d66b210979ba99862accdfc0@outtalimits.com.au>
* 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