How to increase postgresql performance - Mailing list pgsql-admin

From fida aljounaidi
Subject How to increase postgresql performance
Date
Msg-id ece0a951002020251j4010acfh673a902929c39b5f@mail.gmail.com
Whole thread Raw
Responses Re: How to increase postgresql performance
Re: How to increase postgresql performance
Re: How to increase postgresql performance
List 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


pgsql-admin by date:

Previous
From: Renato Oliveira
Date:
Subject: Re: PITR clarification to certain points
Next
From: "Bret S. Lambert"
Date:
Subject: Re: How to increase postgresql performance