Re: Weird issue with planner choosing seq scan

Поиск
Список
Период
Сортировка
От Scott Marlowe
Тема Re: Weird issue with planner choosing seq scan
Дата
Msg-id dcc563d10802241627g6d30808erf1006b3ffe6e1d08@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Weird issue with planner choosing seq scan  (Sean Leach <sleach@wiggum.com>)
Ответы Re: Weird issue with planner choosing seq scan
Список pgsql-performance
On Sun, Feb 24, 2008 at 6:05 PM, Sean Leach <sleach@wiggum.com> wrote:

>  On Feb 24, 2008, at 4:03 PM, Scott Marlowe wrote:
>
>  >
>  > What version pgsql is this?  If it's pre 8.0 it might be worth looking
>  > into migrating for performance and maintenance reasons.
>
>  It's the latest 8.3.0 release :(

Urg.  Then I wonder how your indexes are bloating but your table is
not...  you got autovac running?  No weird lock issues?  It's a side
issue right now since the table is showing as non-bloated (unless
you've got a long running transaction and that number is WAY off from
your vacuum)

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

Предыдущее
От: Sean Leach
Дата:
Сообщение: Re: Weird issue with planner choosing seq scan
Следующее
От: Joel Stevenson
Дата:
Сообщение: Re: LISTEN / NOTIFY performance in 8.3