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
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_ |