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 BAA00158 for ; Mon, 22 Feb 1999 01:46:15 -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 BAA21794; Mon, 22 Feb 1999 01:45:23 -0500 (EST) From: Bruce Momjian Message-Id: <199902220645.BAA21794@candle.pha.pa.us> Subject: Re: [SQL] SQL query _slow_ In-Reply-To: <36D0F943.2D094E5D@gbcomputers.com> from Gregg Berkholtz at "Feb 21, 1999 10:29:24 pm" To: gregg@gbcomputers.com (Gregg Berkholtz) Date: Mon, 22 Feb 1999 01:45:23 -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 > EXPLAIN -- What is that? A psql command. > > Bruce Momjian wrote: > > > > 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 > > -- > ----------------------------------------------------- > ///////////// Gregg Berkholtz - Owner > | G B | Computer consulting, sales and support > | Computers | > \\\\\\\\\\\\\ INFO: www.gbcomputers.com > > > -- 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