Re: Waiting for Update - Mailing list pgsql-sql

From Jan Wieck
Subject Re: Waiting for Update
Date
Msg-id 3D2C524E.24277DFC@Yahoo.com
Whole thread Raw
In response to Waiting for Update  (JGM <jgmischke@j-g-m.de>)
List pgsql-sql
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 #


pgsql-sql by date:

Previous
From: Jean-Luc Lachance
Date:
Subject: Re: Error with DISTINCT and AS keywords
Next
From: Jie Liang
Date:
Subject: Re: pg_restore cannot restore index