Received: from candle.pha.pa.us (maillist@s5-03.ppp.op.net [209.152.195.67]) by hub.org (8.9.2/8.9.1) with ESMTP id MAA94383 for ; Thu, 11 Mar 1999 12:36:28 -0500 (EST) (envelope-from maillist@candle.pha.pa.us) Received: (from maillist@localhost) by candle.pha.pa.us (8.9.0/8.9.0) id MAA18715; Thu, 11 Mar 1999 12:36:28 -0500 (EST) From: Bruce Momjian Message-Id: <199903111736.MAA18715@candle.pha.pa.us> Subject: Re: [SQL] Very disappointing performance -- All Indexes Ignored. In-Reply-To: <36E7F732.C2F469BB@kearneydev.com> from secret at "Mar 11, 1999 12: 2:43 pm" To: secret@kearneydev.com (secret) Date: Thu, 11 Mar 1999 12:36:27 -0500 (EST) Cc: pgsql-sql@postgreSQL.org X-Mailer: ELM [version 2.4ME+ PL47 (25)] MIME-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit OK, some questions. First, how long does EXPLAIN take to run. It is a significant percentage of the query time? If so, please download the current snapshot, and try that. Should be much faster. Second, indexes are not of a huge value in this query, because there are no restrictions, i.e. x=3. In most cases, walking the index and then going to the heap table takes longer than just reading the entire table into a hash and doing the join there. I am interested in seeing this resolved for you. -- Bruce Momjian | http://www.op.net/~candle maillist@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