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: F9262929-D8A9-4110-B52E-DA4875241427@blighty.com (view raw or flat)
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.

http://www.westnet.com/~gsmith/content/postgresql/pg-5minute.htm is a  
five minute tuning overview.

http://www.powerpostgresql.com/PerfList/ 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.

Cheers,
   Steve


In response to

Responses

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-2014 The PostgreSQL Global Development Group