X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 2A0319FA3B3 for ; Mon, 15 May 2006 12:13:01 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 91124-10 for ; Mon, 15 May 2006 12:12:52 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from noel.decibel.org (noel.decibel.org [67.100.216.10]) by postgresql.org (Postfix) with ESMTP id CCEE69FA226 for ; Mon, 15 May 2006 12:12:51 -0300 (ADT) Received: by noel.decibel.org (Postfix, from userid 1001) id DEF9856423; Mon, 15 May 2006 10:12:50 -0500 (CDT) Received: (hashcash-sendmail, from uid 1001); Mon, 15 May 2006 10:12:49 -0500 Date: Mon, 15 May 2006 10:12:49 -0500 From: "Jim C. Nasby" To: Tom Lane Cc: Enzo Daddario , PGADMIN Subject: Re: Constraint question Message-ID: <20060515151249.GE26212@pervasive.com> References: <1147659556.29084.26.camel@localhost.localdomain> <21805.1147661450@sss.pgh.pa.us> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <21805.1147661450@sss.pgh.pa.us> X-Operating-System: FreeBSD 6.0-RELEASE-p4 amd64 X-Distributed: Join the Effort! http://www.distributed.net User-Agent: Mutt/1.5.11 X-Hashcash: 1:20:060515:tgl@sss.pgh.pa.us::kDZzTVunAh9rj7U4:00000000000000000000 000000000000000000000000Cqq7 X-Hashcash: 1:20:060515:enzo@pienetworks.com::62EkUub1IjLvBmjT:00000000000000000 0000000000000000000000001tGT X-Hashcash: 1:20:060515:pgsql-admin@postgresql.org::7XXXBUWY9T3Y7M7L:00000000000 0000000000000000000000000HGZ X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200605/180 X-Sequence-Number: 21712 On Sun, May 14, 2006 at 10:50:50PM -0400, Tom Lane wrote: > Enzo Daddario writes: > > I am now required the remove thousands of obsolete records from table > > "X" and even though I have removed all related rows in all related > > tables, the deletion of rows in table "X" is taking WAY TOO LONG. > > You need to put indexes on the referencing columns. Then start a fresh > session for doing the actual deletes (FK check plans are usually cached > per-session). Would SET CONSTRAINTS ... DEFERRED not help, or does it still use the same machinery to do the checking, regardless of how much data there is to check? -- Jim C. Nasby, Sr. Engineering Consultant jnasby@pervasive.com Pervasive Software http://pervasive.com work: 512-231-6117 vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461