Обсуждение: Waiting for Update

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?

Greetings 

Juergen

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 #