Steve Atkins wrote:
> Hang out on the pgsql-performance mailing list and see what other people
> do - "How do I tune a database for X" comes up pretty regularly, and
> gets good answers, so trolling through the mailing list archive can give
> some very good advice.
>
Aside from the hardware and server options that can be adjusted - the
sql you use can make a big difference to performance as well.
That goes from good table design and index usage through to select
statement structure as well.
The mailing lists are often a good place to get help with selects that
perform slowly.
--
Shane Ambler
pgSQL (at) Sheeky (dot) Biz
Get Sheeky @ http://Sheeky.Biz