Re: [SQL] SQL query _slow_

From: Gregg Berkholtz <gregg(at)gbcomputers(dot)com>
To: Bruce Momjian <maillist(at)candle(dot)pha(dot)pa(dot)us>
Cc: pgsql-sql(at)postgreSQL(dot)org
Subject: Re: [SQL] SQL query _slow_
Date: 1999-02-22 06:29:24
Message-ID: 36D0F943.2D094E5D@gbcomputers.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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(at)candle(dot)pha(dot)pa(dot)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

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Bruce Momjian 1999-02-22 06:45:23 Re: [SQL] SQL query _slow_
Previous Message Bruce Momjian 1999-02-22 01:07:02 Re: [SQL] SQL query _slow_