Re: Different execution plan

Поиск
Список
Период
Сортировка
От Scott Marlowe
Тема Re: Different execution plan
Дата
Msg-id dcc563d10809221419k25e5a75i1e95984ef382f7f2@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Different execution plan  ("Sabin Coanda" <sabin.coanda@deuromedia.ro>)
Список pgsql-performance
On Mon, Sep 22, 2008 at 2:40 PM, Sabin Coanda
<sabin.coanda@deuromedia.ro> wrote:
> Hi there,
>
> I am still concerned about this problem, because there is a big differences
> between the two cases, and I don't know how to identify the problem. Can
> anybody help me, please ?

Sure, first step, if you can provide the following:

pg version
os and version
output of explain analyze of each query (one good query, one bad)

In the meantime, make sure you've vacuum analyzed your db.

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

Предыдущее
От: "Sabin Coanda"
Дата:
Сообщение: Re: Different execution plan
Следующее
От: Simon Riggs
Дата:
Сообщение: Re: Intel's X25-M SSD