From: | Steve Kecskes <steve(at)outtalimits(dot)com(dot)au> |
---|---|
To: | pgsql-admin(at)postgresql(dot)org |
Subject: | Recourse Usage |
Date: | 2008-07-03 23:28:05 |
Message-ID: | aaac5b98d66b210979ba99862accdfc0@outtalimits.com.au |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
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(at)outtalimits(dot)com(dot)au
From | Date | Subject | |
---|---|---|---|
Next Message | Scott Marlowe | 2008-07-04 00:38:14 | Re: Recourse Usage |
Previous Message | Kevin Grittner | 2008-07-03 22:04:11 | Re: Who's attached to the database? |