Postgres Pro
Downloads
Home   >   mailing lists

Re: Slow update with simple query - Mailing list pgsql-performance

From Arnaud Lesauvage
Subject Re: Slow update with simple query
Date
Msg-id 45802E98.8050102@freesurf.fr
Whole thread Raw
In response to Re: Slow update with simple query  (asif ali <asif_icrossing@yahoo.com>)
List pgsql-performance
Tree view 
asif ali a écrit :
> Arnaud,
>  Have you run "ANALYZE" on the table after creating index?

Yes, I have !

>  Also make sure that "#effective_cache_size" is set properly. A higher         value makes it more likely to use
indexscans. 

It is set to 50.000. I thought this would be enough, and maybe too much !

Thanks for your advice !

--
Arnaud

pgsql-performance by date:

Previous
From: Tom Lane
Date:
Subject: Re: Slow update with simple query
Next
From: "Rajesh Kumar Mallah"
Date:
Subject: Re: Insertion to temp table deteriorating over time