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 UAA67247 for ; Sun, 21 Feb 1999 20:08:18 -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 UAA02187; Sun, 21 Feb 1999 20:07:02 -0500 (EST) From: Bruce Momjian Message-Id: <199902220107.UAA02187@candle.pha.pa.us> Subject: Re: [SQL] SQL query _slow_ In-Reply-To: <36D09E44.D881E2BF@gbcomputers.com> from Gregg Berkholtz at "Feb 21, 1999 4: 1: 8 pm" To: gregg@gbcomputers.com (Gregg Berkholtz) Date: Sun, 21 Feb 1999 20:07:02 -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 > So, if I understand correctly. I am not doing anything wrong in terms of the > SQL coding, it is just the speed of the postmaster right now. > I am new to PostgreSQL and SQL for that matter, but another question I have > would be: > Would indexes help at all? <-- If so, what should I index to get the best > speed? Not sure. If EXPLAIN is slow showing results, it is just the optimizer. -- 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