X-Original-To: pgsql-hackers-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.130]) by svr1.postgresql.org (Postfix) with ESMTP id 3C79DD1B4F0 for ; Mon, 29 Sep 2003 20:19:52 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new, port 10024) with ESMTP id 68040-01 for ; Mon, 29 Sep 2003 17:19:22 -0300 (ADT) Received: from megazone.bigpanda.com (megazone.bigpanda.com [64.147.171.210]) by svr1.postgresql.org (Postfix) with ESMTP id 7A696D1B522 for ; Mon, 29 Sep 2003 17:19:20 -0300 (ADT) Received: by megazone.bigpanda.com (Postfix, from userid 1001) id 07A0435364; Mon, 29 Sep 2003 13:19:22 -0700 (PDT) Received: from localhost (localhost [127.0.0.1]) by megazone.bigpanda.com (Postfix) with ESMTP id 05FBE352A2; Mon, 29 Sep 2003 13:19:22 -0700 (PDT) Date: Mon, 29 Sep 2003 13:19:22 -0700 (PDT) From: Stephan Szabo To: Tom Lane Cc: Christopher Kings-Lynne , Bruce Momjian , Peter Childs , PostgreSQL-development Subject: Re: ADD FOREIGN KEY (was Re: [GENERAL] 7.4Beta) In-Reply-To: <20030929112706.U94710@megazone.bigpanda.com> Message-ID: <20030929131850.S97190@megazone.bigpanda.com> References: <20030815073837.R19338-100000@megazone.bigpanda.com> <1718.1064705858@sss.pgh.pa.us> <20030928111850.B73144@megazone.bigpanda.com> <10377.1064775363@sss.pgh.pa.us> <20030929112706.U94710@megazone.bigpanda.com> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200309/1603 X-Sequence-Number: 44615 On Mon, 29 Sep 2003, Stephan Szabo wrote: > When I lowered random_page_cost to 1, I got an indexscan on fktable, but > that hadn't seemed to finish after about 2 hours (as opposed to about > 30-35 minutes for the not exists and about 30 min - 1 1/2 hours for the Small correction, I'd meant to type 20-35 minutes above, not 30-35.