Received: from localhost (maia-3.hub.org [200.46.204.184])
	by postgresql.org (Postfix) with ESMTP id 3BFE39FA248
	for <pgsql-performance-postgresql.org@postgresql.org>;
	Wed, 13 Dec 2006 12:47:33 -0400 (AST)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.184]) (amavisd-new, port 10024)
	with ESMTP id 18446-07 for
	<pgsql-performance-postgresql.org@postgresql.org>;
	Wed, 13 Dec 2006 12:47:28 -0400 (AST)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.4
Received: from serveurmail01.codata.be (125.123.146.82.ipv4.evonet.be
	[82.146.123.125])
	by postgresql.org (Postfix) with ESMTP id 08B219F9F46
	for <pgsql-performance@postgresql.org>;
	Wed, 13 Dec 2006 12:47:28 -0400 (AST)
Received: from localhost (localhost.localdomain [127.0.0.1])
	by serveurmail01.codata.be (Postfix) with ESMTP id 900CD183877B;
	Wed, 13 Dec 2006 17:47:24 +0100 (CET)
X-DSPAM-Result: Innocent
X-DSPAM-Processed: Wed Dec 13 17:47:20 2006
X-DSPAM-Confidence: 0.6768
X-DSPAM-Probability: 0.0000
X-DSPAM-Signature: 45802e9812161516121994
X-DSPAM-Factors: 27,
X-Virus-Scanned: amavisd-new at 
Received: from serveurmail01.codata.be ([127.0.0.1])
	by localhost (serveurmail01.codata.be [127.0.0.1]) (amavisd-new,
	port 10024)
	with ESMTP id 60PKUpqSyZGR; Wed, 13 Dec 2006 17:47:20 +0100 (CET)
Received: from [127.0.0.1] (38-179-112-217.fix.adsl.belcenter.be
	[217.112.179.38])
	by serveurmail01.codata.be (Postfix) with ESMTP id 084861838778;
	Wed, 13 Dec 2006 17:47:19 +0100 (CET)
Message-ID: <45802E98.8050102@freesurf.fr>
Date: Wed, 13 Dec 2006 17:47:20 +0100
From: Arnaud Lesauvage <thewild@freesurf.fr>
User-Agent: Thunderbird 1.5.0.8 (Windows/20061025)
MIME-Version: 1.0
To: asif ali <asif_icrossing@yahoo.com>
CC: Ragnar <gnari@hive.is>, Jens Schipkowski <jens.schipkowski@apus.co.at>,
	pgsql-performance@postgresql.org
Subject: Re: Slow update with simple query
References: <192027.84308.qm@web58405.mail.re3.yahoo.com>
In-Reply-To: <192027.84308.qm@web58405.mail.re3.yahoo.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 8bit
X-Antivirus: avast! (VPS 0658-0, 13/12/2006), Outbound message
X-Antivirus-Status: Clean
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200612/326
X-Sequence-Number: 22382

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