Re: [GENERAL] Optimzing Postgresql

On Sat, May 24, 2008 at 12:57 PM, Ram Ravichandran <ramkaka@gmail.com> wrote:
> Hi,
>
> I am deciding between MySQL and Postgres. I'm leaning towards Postgres
> mainly due the widely publicized speed when using transactions. However, I
> am not able to find any good books / resources for tuning/ optimizing the
> database. Is there a book like "High Performance MySQL" for Postgres that
> teaches what the different parameters are and how to tune them?
> Or do most techniques covered in the High Performance Mysql apply to
> Postgres too?

Aside from all the really good advice you've received so far, another
vital step is running the latest version of pgsql. 8.3 has a lot of
improvements, and look for 8.4 to be the same way.

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general