On Sat, May 24, 2008 at 12:57 PM, Ram Ravichandran <ramkaka@xxxxxxxxx> 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.
