Re: PG8.2.1 choosing slow seqscan over idx scan

Поиск
Список
Период
Сортировка
От Jeremy Haile
Тема Re: PG8.2.1 choosing slow seqscan over idx scan
Дата
Msg-id 1169060107.24972.1169765759@webmail.messagingengine.com
обсуждение исходный текст
Ответ на Re: PG8.2.1 choosing slow seqscan over idx scan  (Scott Marlowe <smarlowe@g2switchworks.com>)
Список pgsql-performance
> Also, look at the thread going by about index bloat by 4x.  You'll
> likely want to reindex after a vacuum full since vacuum full doesn't
> reclaim space in indexes and in fact often bloats indexes.

Thanks for the pointer.  That thread might indeed apply to my situation.
 I'm going to reindex the the table tonight.

Jeremy Haile

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

Предыдущее
От: "Jeremy Haile"
Дата:
Сообщение: Re: PG8.2.1 choosing slow seqscan over idx scan
Следующее
От: Tomas Vondra
Дата:
Сообщение: Re: PG8.2.1 choosing slow seqscan over idx scan