Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: Optimzing Postgresql
- 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: Mon, 26 May 2008 08:44:26 -0600
- Message-id: <dcc563d10805260744v4b2536e1ufa6f8fd7453590ce(at)mail(dot)gmail(dot)com>
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.
- References:
- Optimzing Postgresql
- From: Ram Ravichandran
- Optimzing Postgresql
- Prev by Date: Re: editing functions/triggers etc..
- Next by Date: PostgreSQL full text vs. MySQL
- Previous by thread: Re: Optimzing Postgresql
- Next by thread: Copying data from a table to another database
- Indexes: