From: Joshua D. Drake <jd@commandprompt.com>
To: Adrian Moisey <adrian@careerjunction.co.za>
Cc: pgsql-performance@postgresql.org
Subject: Re: big database performance
Date: Wed, 09 Jan 2008 00:27:33 -0800
Message-ID: <47848575.8000007@commandprompt.com> (raw)
In-Reply-To: <4784835A.8070604@careerjunction.co.za>
References: <4784835A.8070604@careerjunction.co.za>
Adrian Moisey wrote:
> Hi
>
> We recently converted to postgres (from mssql) and we're having
> performance issues. Not all the issues are related to postgres, but
> we're trying to sort everything out.
>
> The server is running ubuntu Gutsy with the database stored on a IBM
> SAN. It is a Dell box with dual quad core 2.00GHz Xeons and 8GB RAM.
>
>
> The database is about 71GB in size.
>
> I've looked at the postgres config files and we've tweaked as much as
> our knowledge allows.
>
> Can someone shed some light on the settings I should use ?
Umpf that isn't quite enough info :) but assuming you are running 8.2.x:
Start with 1GB shared_buffers (you may be able to go hire), 4MB
work_mem, wal_sync_method = open_sync, checkpoint_segments = 30,
default_statistics_target = 150, effective_cache_size = 6GB .
Restart, VACUUM ANALYZE VERBOSE, post back last 4 lines of output.
Other good items to know:
64bit Gutsy?
How is the SAN connected?
What does mpstat 5 (3 iterations) say?
Even better what does sar -A say over a 24 hour period?
Sincerely,
Joshua D. Drake
>
>
> Thanks in advance
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: jd@commandprompt.com, adrian@careerjunction.co.za
Subject: Re: big database performance
In-Reply-To: <47848575.8000007@commandprompt.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