How to increase postgresql performance

From: fida aljounaidi <fida(dot)aljounaidi(at)gmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: How to increase postgresql performance
Date: 2010-02-02 10:51:57
Message-ID: ece0a951002020251j4010acfh673a902929c39b5f@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi

I have an sql query which takes 20 seconds to be executed.

this sql query contain more than 870 id under the select where in ()
condition.

So , it is not a large row result but a big list of conditions to be
crossed.

I'm using postgresql 8.4.

Thanks for help

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Bret S. Lambert 2010-02-02 10:56:41 Re: How to increase postgresql performance
Previous Message Renato Oliveira 2010-02-02 10:23:19 Re: PITR clarification to certain points