Re: Fillfactor for GIN indexes

Поиск
Список
Период
Сортировка
От Alexander Korotkov
Тема Re: Fillfactor for GIN indexes
Дата
Msg-id CAPpHfdtWVc0sSwFugo4+tTDwqN=-bN2LxgS=-hnw_mr4LYPcsQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Fillfactor for GIN indexes  (Tomas Vondra <tomas.vondra@2ndquadrant.com>)
Ответы Re: Fillfactor for GIN indexes  (Tomas Vondra <tomas.vondra@2ndquadrant.com>)
Список pgsql-hackers
On Tue, Feb 24, 2015 at 5:15 PM, Tomas Vondra <tomas.vondra@2ndquadrant.com> wrote:
I hoped lowering the fillfactor will improve this, but fillfactor=75 had
pretty much no effect in this case. Is that expected for this kind of
workload? I see the previous discussion talked about random updates, not
inserts, so maybe that's the culprit?

Yes. Since posting trees are ordered by item pointers, you can get benefit of fillfactor only if you use some item pointers lower than item pointers already in use. You can still get benefit in the insert case but you should have already some free space in the heap (perhaps do some deletes and vacuum).

Actually, this is narrowing benefit from GIN fillfactor. Probably, that means that we should still have default value of 100. But I think GIN fillfactor still might be useful.

------
With best regards,
Alexander Korotkov.

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

Предыдущее
От: Amit Langote
Дата:
Сообщение: Re: Partitioning WIP patch (was: Partitioning: issues/ideas)
Следующее
От: Fabien COELHO
Дата:
Сообщение: event triggers with args?