Received: from yapok.nexcerpt.com ([65.88.171.66]) by postgresql.org (8.11.3/8.11.4) with ESMTP id g0GDa3V88798 for ; Wed, 16 Jan 2002 08:36:03 -0500 (EST) (envelope-from jboes@nexcerpt.com) Received: from takin.private.nexcerpt.com (zorro.nexcerpt.com [65.88.171.65]) by yapok.nexcerpt.com (8.11.6/8.11.6) with SMTP id g0GDa0m02512; Wed, 16 Jan 2002 08:36:01 -0500 Date: Wed, 16 Jan 2002 08:38:28 -0500 From: Jeff Boes To: Stephan Szabo Cc: pgsql-sql@postgresql.org Subject: Re: Long-running DELETE Message-Id: <20020116083828.2b323ec7.jboes@nexcerpt.com> In-Reply-To: <20020115211207.I39844-100000@megazone23.bigpanda.com> References: <20020115211207.I39844-100000@megazone23.bigpanda.com> Organization: Nexcerpt, Inc. X-Mailer: Sylpheed version 0.7.0 (GTK+ 1.2.9; i586-pc-linux-gnu) Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit X-Archive-Number: 200201/178 X-Sequence-Number: 6264 On Tue, 15 Jan 2002 21:13:49 -0800 (PST) Stephan Szabo 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