Re: Sequential vs. random values - number of pages in B-tree - Mailing list pgsql-general

From Ilya Kazakevich
Subject Re: Sequential vs. random values - number of pages in B-tree
Date
Msg-id 006301d1f94a$c2aa6ca0$47ff45e0$@JetBrains.com
Whole thread Raw
In response to Re: Sequential vs. random values - number of pages in B-tree  (pinker <pinker@onet.eu>)
List 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 by date:

Previous
From: pinker
Date:
Subject: Re: Sequential vs. random values - number of pages in B-tree
Next
From: pinker
Date:
Subject: Re: Sequential vs. random values - number of pages in B-tree