From: Jim C. Nasby <jimn@enterprisedb.com>
To: Francisco Reyes <lists@stringsutils.com>
Cc: Pgsql performance <pgsql-performance@postgresql.org>
Subject: Re: Vacuums on large busy databases
Date: Mon, 18 Sep 2006 17:40:30 -0500
Message-ID: <20060918224030.GM47167@enterprisedb.com> (raw)
In-Reply-To: <cone.1158247381.60704.30981.1000@zoraida.natserv.net>
References: <cone.1158247381.60704.30981.1000@zoraida.natserv.net>
On Thu, Sep 14, 2006 at 11:23:01AM -0400, Francisco Reyes wrote:
> My setup:
> Freebsd 6.1
> Postgresql 8.1.4
> Memory: 8GB
> SATA Disks
>
> Raid 1 10 spindles (2 as hot spares)
> 500GB disks (16MB buffer), 7200 rpm
> Raid 10
>
> Raid 2 4 spindles
> 150GB 10K rpm disks
> Raid 10
>
> shared_buffers = 10000
> temp_buffers = 1500
> work_mem = 32768 # 32MB
> maintenance_work_mem = 524288 # 512MB
>
> checkpoint_segments = 64
> Just increased to 64 today.. after reading this may help. Was 5 before.
>
> pg_xlog on second raid (which sees very little activity)
BTW, on some good raid controllers (with battery backup and
write-caching), putting pg_xlog on a seperate partition doesn't really
help, so you might want to try combining everything.
Even if you stay with 2 partitions, I'd cut pg_xlog back to just a
simple mirror.
--
Jim Nasby jimn@enterprisedb.com
EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)
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: jimn@enterprisedb.com, lists@stringsutils.com
Subject: Re: Vacuums on large busy databases
In-Reply-To: <20060918224030.GM47167@enterprisedb.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