Re: Optimzing Postgresql

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