Re: Postgres 8.3, four times slower queries?

Поиск
Список
Период
Сортировка
От Robert Haas
Тема Re: Postgres 8.3, four times slower queries?
Дата
Msg-id 603c8f070903050856y37d9825bga53fcc2017143163@mail.gmail.com
обсуждение исходный текст
Ответ на Postgres 8.3, four times slower queries?  (Aaron Guyon <battlemage@gmail.com>)
Список pgsql-performance
On Thu, Mar 5, 2009 at 10:20 AM, Kevin Grittner
<Kevin.Grittner@wicourts.gov> wrote:
>>>> Robert Haas <robertmhaas@gmail.com> wrote:
>> Well, it looks like the problem is that 8.3 is not using the index
>> idx_bundle_content_bundle_id.  But I don't know why that should be
>> happening, unless there's a problem with that index.
>
> I didn't see that index defined.  In fact, in the query shown, t8 is
> the payment_amount table, but in plan, I don't see any references to
> that table, and t8 is a table called bundle_content which is not
> included.

Good point.  Now that you mention it, I notice that many of the tables
and columns seem to have been renamed.  It's pretty hard to make
anything intelligible out of a schema that doesn't resemble the plan.

...Robert

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

Предыдущее
От: Robert Haas
Дата:
Сообщение: Re: Postgres 8.3, four times slower queries?
Следующее
От: Jonathan Hseu
Дата:
Сообщение: Index scan plan estimates way off.