Re: [SQL] SQL query _slow_

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

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