Re: Sequential vs. random values - number of pages in B-tree

Поиск
Список
Период
Сортировка
От Ilya Kazakevich
Тема Re: Sequential vs. random values - number of pages in B-tree
Дата
Msg-id 006301d1f94a$c2aa6ca0$47ff45e0$@JetBrains.com
обсуждение исходный текст
Ответ на Re: Sequential vs. random values - number of pages in B-tree  (pinker <pinker@onet.eu>)
Список pgsql-general
>Thank you. So if that is the reason changing the fillfactor parameter should
>help?

Fillfactor is not about rebalancing, but about page split. If you have many insertions you may decrease fillfactor to
minimize page splits, but I am not sure it will help in your case.  But you should try) 
Better approach is to create index _after_ insertion, but it is not always possible.


Ilya Kazakevich

JetBrains
http://www.jetbrains.com
The Drive to Develop



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

Предыдущее
От: pinker
Дата:
Сообщение: Re: Sequential vs. random values - number of pages in B-tree
Следующее
От: pinker
Дата:
Сообщение: Re: Sequential vs. random values - number of pages in B-tree