| From: | Michael Paquier <michael(dot)paquier(at)gmail(dot)com> |
|---|---|
| To: | Alexander Korotkov <aekorotkov(at)gmail(dot)com> |
| Cc: | Robert Haas <robertmhaas(at)gmail(dot)com>, PostgreSQL mailing lists <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: Fillfactor for GIN indexes |
| Date: | 2015-01-08 05:03:35 |
| Message-ID: | CAB7nPqQipNN4Os-uJPgknAgb5-U3-wnn7d=9B4B4T=6frh=zQQ@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Thu, Jan 8, 2015 at 6:31 AM, Alexander Korotkov <aekorotkov(at)gmail(dot)com> wrote:
> On Wed, Jan 7, 2015 at 4:11 PM, Michael Paquier <michael(dot)paquier(at)gmail(dot)com>
>> I am attaching an updated patch, with the default fillfactor value at
>> 75%, and with the page split code using the fillfactor rate.
>> Thoughts?
> Rewritten version of patch is attached. I made following changes:
Thanks! With this patch (and my previous version as well) GIN indexes
with default fillfactor have a size higher than 9.4 indexes, 9.4
behavior being consistent only with fillfactor=100 and not the default
of 90. Are we fine with that?
--
Michael
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ali Akbar | 2015-01-08 07:53:44 | Re: PATCH: decreasing memory needlessly consumed by array_agg |
| Previous Message | Peter Geoghegan | 2015-01-08 04:23:31 | Re: Possible typo in create_policy.sgml |