Re: [SQL] what is "cost"?

From: Gregory Holston <holston(at)itd(dot)nrl(dot)navy(dot)mil>
To: Bruce Momjian <maillist(at)candle(dot)pha(dot)pa(dot)us>
Cc: pgsql-sql(at)hub(dot)org
Subject: Re: [SQL] what is "cost"?
Date: 1999-04-23 21:27:37
Message-ID: Pine.SUN.3.91.990423172542.17226C-100000@shell
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

On Fri, 23 Apr 1999, Bruce Momjian wrote:

> >
> > Hi All,
> >
> > I just did an explain and was wondering what is meant by cost. I just
> > got a 72.983 cost from a query I found not working. Any info or pointers
> > would be appreciated.
>
> Just added to explain manual page:
>
> The cost value is only meaningful to the optimizer in comparing various
> query plans.
>
I got the 72.98 on this table while doing a simple "select * from
publication" meanwhile I got nothing higher than 4 on any other table. Is this
indicative of a problem?

-Greg

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Bruce Momjian 1999-04-23 21:29:24 Re: [SQL] what is "cost"?
Previous Message Bruce Momjian 1999-04-23 21:24:01 Re: [SQL] what is "cost"?