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@Yahoo.com #



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