> 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
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
No comments:
Post a Comment