Received: from mail2.teleport.com (mail2.teleport.com [192.108.254.43]) by hub.org (8.9.2/8.9.1) with SMTP id BAA97766 for ; Mon, 22 Feb 1999 01:29:28 -0500 (EST) (envelope-from gregg@gbcomputers.com) Received: (qmail 17325 invoked from network); 22 Feb 1999 06:29:25 -0000 Received: from i48-25-21.pdx.du.teleport.com (HELO gbcomputers.com) (216.26.8.21) by mail2.teleport.com with SMTP; 22 Feb 1999 06:29:25 -0000 Message-ID: <36D0F943.2D094E5D@gbcomputers.com> Date: Sun, 21 Feb 1999 22:29:24 -0800 From: Gregg Berkholtz Organization: GB Computers X-Mailer: Mozilla 4.5 [en] (Win95; U) X-Accept-Language: en MIME-Version: 1.0 To: Bruce Momjian CC: pgsql-sql@postgreSQL.org Subject: Re: [SQL] SQL query _slow_ References: <199902220107.UAA02187@candle.pha.pa.us> Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit EXPLAIN -- What is that? 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