Re: update query taking too long

[Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>]

Chris <dmagick(at)gmail(dot)com> writes:
> I'm trying to do an update of a reasonably large table and it's taking 
> way too long so I'm trying to work out why and if I need to tweak any 
> settings to speed it up.

Any foreign keys leading to or from that table?

3.5 million row updates are not exactly gonna be instantaneous anyway,
but only FK checks or really slow user-written triggers would make it
take upwards of an hour ...

			regards, tom lane