| From: | "Scott Marlowe" <scott(dot)marlowe(at)gmail(dot)com> |
|---|---|
| To: | "Ram Ravichandran" <ramkaka(at)gmail(dot)com> |
| Cc: | "pgsql-general General" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Optimzing Postgresql |
| Date: | 2008-05-26 14:44:26 |
| Message-ID: | dcc563d10805260744v4b2536e1ufa6f8fd7453590ce@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Sat, May 24, 2008 at 12:57 PM, Ram Ravichandran <ramkaka(at)gmail(dot)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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Skip Evans | 2008-05-26 14:53:47 | PostgreSQL full text vs. MySQL |
| Previous Message | johnf | 2008-05-26 14:42:27 | Re: editing functions/triggers etc.. |