Re: choosing fillfactor

Поиск
Список
Период
Сортировка
От Heikki Linnakangas
Тема Re: choosing fillfactor
Дата
Msg-id 464E0A34.6030802@enterprisedb.com
обсуждение исходный текст
Ответ на choosing fillfactor  (Gene Hart <genekhart@gmail.com>)
Список pgsql-performance
Gene Hart wrote:
> I've tried searching the documentation to answer this question but could
> not find anything. When trying to choose the optimal fillfactor for an
> index, what is important the number of times the row is updated or the
> column indexed upon is updated? In my case each row is updated on
> average about 5 times but for some of the columns with indexes don't
> change after insertion ever. thanks for any advice

It's the number of times the row is updated, regardless of which columns
are changed.


--
   Heikki Linnakangas
   EnterpriseDB   http://www.enterprisedb.com

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Slow queries on big table
Следующее
От: "Tyrrill, Ed"
Дата:
Сообщение: Re: Slow queries on big table