Re: Long-running DELETE

On Tue, 15 Jan 2002 21:13:49 -0800 (PST)
Stephan Szabo <sszabo@megazone23.bigpanda.com> wrote:

> 
> On 15 Jan 2002, Jeff Boes wrote:
> 
> > update pg_triggers set tgenabled=false;
> 
> I don't think tgenabled works.  You'll probably need to set reltriggers to
> 0 on the pg_class row for the table (and then reset it to the correct
> value afterwards).
> 

I can't confirm that one, but I did find that things got a lot faster
when I also did
 update pg_trigger  set tgenabled=false,   tgdeferrable=true,   tginitdeferred=true

for each of the associated triggers.

-- 
Jeff Boes                                             vox 616.226.9550
Database Engineer                                     fax 616.349.9076
Nexcerpt, Inc.                                      jboes@nexcerpt.com