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

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: (view raw or whole thread)
Lists: pgsql-admin

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 ()

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

I'm using postgresql 8.4.

Thanks for help


pgsql-admin by date

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

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