Received: from candle.pha.pa.us (216-55-132-35.dialup.tnt01.san-diego.abac.net [216.55.132.35]) by postgresql.org (8.11.3/8.11.4) with ESMTP id fBH5dmm60825 for ; Mon, 17 Dec 2001 00:39:48 -0500 (EST) (envelope-from pgman@candle.pha.pa.us) Received: (from pgman@localhost) by candle.pha.pa.us (8.11.6/8.10.1) id fBH5dR606887; Mon, 17 Dec 2001 00:39:27 -0500 (EST) From: Bruce Momjian Message-Id: <200112170539.fBH5dR606887@candle.pha.pa.us> Subject: Re: performance tuning in large function / transaction In-Reply-To: "from Christopher Kings-Lynne at Dec 17, 2001 12:06:14 pm" To: Christopher Kings-Lynne Date: Mon, 17 Dec 2001 00:39:27 -0500 (EST) CC: Stephan Szabo , MindTerm , pgsql-sql@postgresql.org X-Mailer: ELM [version 2.4ME+ PL90 (25)] MIME-Version: 1.0 Content-Transfer-Encoding: 7bit Content-Type: text/plain; charset=US-ASCII X-Archive-Number: 200112/175 X-Sequence-Number: 5998 > > As a note, does rewriting the queries in the function > > to use exists rather than in help any? > > Is it true that the IN command is implemented sort of as a linked list > linear time search? Is there any plan for a super-fast implementation of > 'IN'? I keep asking for it and am told it is hard to do. -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 853-3000 + If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill, Pennsylvania 19026