Re: Slow update with simple query

From: Arnaud Lesauvage <thewild(at)freesurf(dot)fr>
To: asif ali <asif_icrossing(at)yahoo(dot)com>
Cc: Ragnar <gnari(at)hive(dot)is>, Jens Schipkowski <jens(dot)schipkowski(at)apus(dot)co(dot)at>, pgsql-performance(at)postgresql(dot)org
Subject: Re: Slow update with simple query
Date: 2006-12-13 16:47:20
Message-ID: 45802E98.8050102@freesurf.fr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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 index scans.

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

Thanks for your advice !

--
Arnaud

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Rajesh Kumar Mallah 2006-12-13 17:14:10 Re: Insertion to temp table deteriorating over time
Previous Message Tom Lane 2006-12-13 16:46:25 Re: Slow update with simple query