Re: Really slow UPDATE and DELETE

Nicholas Piper wrote:
>
> But no change! The simple UPDATE
> UPDATE products SET title = 'I D THE FIRM' WHERE id = '6';
> still takes over 10 seconds.
>
> Why does this use FK columns at all ? I'm not changing the id, which
> is the pkey for this table.

Either there's something broken or it should do as you
expected. There are special checks in the FK triggers that
suppress the scans if the referenced key doesn't change.

> I'm going to turn up debugging in case that will allow me to see all
> the work PG is putting into my title UPDATE.

Are there any custom triggers or rules?

Jan

--

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

_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com