Re: optimizer behavior in the case of highly updated tables

Поиск
Список
Период
Сортировка
От Scott Marlowe
Тема Re: optimizer behavior in the case of highly updated tables
Дата
Msg-id AANLkTik8XqRz6pheRvn3X52aRmTRqJnqagPrJJLEZFSy@mail.gmail.com
обсуждение исходный текст
Ответ на optimizer behavior in the case of highly updated tables  (Mark Rostron <mrostron@ql2.com>)
Список pgsql-admin
On Tue, Jun 8, 2010 at 8:58 PM, Mark Rostron <mrostron@ql2.com> wrote:
> I am looking for some specific information regarding optimizer behavior.
>
> We recently experienced a situation where a query that was previously using
> a btree lookup (efficient) SWITCHED to using seqscan/hash lookup.

OK, before we go any further, got any explain analyze output of the
fast and slow queries?

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

Предыдущее
От: Greg Smith
Дата:
Сообщение: Re: Details about pg_stat_bgwriter
Следующее
От: Scott Marlowe
Дата:
Сообщение: Re: Details about pg_stat_bgwriter