Skip site navigation (1) Skip section navigation (2)

Re: Optimzing Postgresql

From: Steve Atkins <steve(at)blighty(dot)com>
To: pgsql-general General <pgsql-general(at)postgresql(dot)org>
Subject: Re: Optimzing Postgresql
Date: 2008-05-24 21:59:04
Message-ID: (view raw or whole thread)
Lists: pgsql-general
On May 24, 2008, at 11:57 AM, Ram Ravichandran 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?

The postgresql manual is good. is a  
five minute tuning overview. is a good overview of basic  
tuning, written for 8.0 but still pretty applicable.

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.

> Or do most techniques covered in the High Performance Mysql apply to  
> Postgres too?

Probably not. Mysql has a very different philosophy to postgresql. And  
some approaches that are suggested to work around performance issue on  
mysql may actually harm performance on other databases.


In response to


pgsql-general by date

Next:From: Pierre-Yves StrubDate: 2008-05-25 00:20:05
Subject: Re: [GENERAL] Fragments in tsearch2 headline
Previous:From: Sushant SinhaDate: 2008-05-24 21:18:57
Subject: Re: [GENERAL] Fragments in tsearch2 headline

Privacy Policy | About PostgreSQL
Copyright © 1996-2015 The PostgreSQL Global Development Group