Re: Noobie: Problems with a query

Поиск
Список
Период
Сортировка
От Bruno Wolff III
Тема Re: Noobie: Problems with a query
Дата
Msg-id 20030630123725.GA26142@wolff.to
обсуждение исходный текст
Ответ на Re: Noobie: Problems with a query  ("Chris Boget" <chris@wild.net>)
Список pgsql-novice
On Mon, Jun 30, 2003 at 07:27:30 -0500,
  Chris Boget <chris@wild.net> wrote:
> > Am Mon, 2003-06-30 um 13.56 schrieb Chris Boget:
> > > which, sadly, is greek to me.  The problem is that the above query
> > > takes very close to 12 seconds to execute.  Is there a better way I
> > > could write the query?  The number of rows in each table are as
> > > follows:
> > First of all you should try: VACUUM ANALYZE;
>
> What was that supposed to tell me?

It was supposed to make sure that the planner had reliable data from
which to plan your query.

When sending a query plan to the lists, you want to do an explain analyze
so that we can see what really happens when your query is executed as
well as what the planner thinks is going to happen.

The plan for your query had a fairly small number of rows for it to take
12 seconds to run the query. This is one hint that an analyze might not
have been done.

В списке pgsql-novice по дате отправления:

Предыдущее
От: "Chris Boget"
Дата:
Сообщение: Re: Noobie: Problems with a query
Следующее
От: Nabil Sayegh
Дата:
Сообщение: Re: Noobie: Problems with a query