Received: from smtp012.mail.yahoo.com (smtp012.mail.yahoo.com
 [216.136.173.32])
	by postgresql.org (Postfix) with SMTP id 76C824758E6
	for <pgsql-sql@postgresql.org>; Wed, 10 Jul 2002 11:27:07 -0400 (EDT)
Received: from psc.progress.com (HELO Yahoo.com) (janwieck@192.233.92.200 with
	plain)
	by smtp.mail.vip.sc5.yahoo.com with SMTP; 10 Jul 2002 15:27:12 -0000
Message-ID: <3D2C524E.24277DFC@Yahoo.com>
Date: Wed, 10 Jul 2002 11:27:10 -0400
From: Jan Wieck <JanWieck@Yahoo.com>
X-Mailer: Mozilla 4.79 [en] (X11; U; Linux 2.2.14-6.1.1smp i686)
X-Accept-Language: en
MIME-Version: 1.0
To: JGM <jgmischke@j-g-m.de>
Cc: pgsql-sql@postgresql.org
Subject: Re: Waiting for Update
References: <age1u4$1cl6$1@news.hub.org>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
X-Archive-Number: 200207/141
X-Sequence-Number: 8520

JGM wrote:
> 
> Could it be true??
> 
> I've a table with < 46000 rows. And a little Update like
> 
> UPDATE foo set xxx = 'X';
> 
> needs about 15 seconds???
> 
> What's wrong?

How long since you vacuumed that table? How big are the rows? Are there
triggers, constraints, anything fancy? How many indexes does foo have?


Jan

-- 

#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me.                                  #
#================================================== JanWieck@Yahoo.com #