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

From: "Ilya Kazakevich" <Ilya(dot)Kazakevich(at)JetBrains(dot)com>
To: "'pinker'" <pinker(at)onet(dot)eu>, <pgsql-general(at)postgresql(dot)org>
Subject: Re: Sequential vs. random values - number of pages in B-tree
Date: 2016-08-18 12:19:25
Message-ID: 006301d1f94a$c2aa6ca0$47ff45e0$@JetBrains.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message pinker 2016-08-18 12:33:58 Re: Sequential vs. random values - number of pages in B-tree
Previous Message pinker 2016-08-18 12:03:02 Re: Sequential vs. random values - number of pages in B-tree