From: | Alexander Korotkov <aekorotkov(at)gmail(dot)com> |
---|---|
To: | pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>, Heikki Linnakangas <hlinnakangas(at)vmware(dot)com> |
Subject: | Negative imact of maintenance_work_mem to GIN size |
Date: | 2014-05-20 00:50:19 |
Message-ID: | CAPpHfdt8Yxbj9sJ_9V15Rne1qu08+F+HFnvqceYuVxLXev42ww@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Hi!
I found that sometimes larger maintenance_work_mem leads to larger GIN
index. That is quite strange. ISTM that it's related to posting lists
compression but I can't figure out how exactly it is.
See example on delicious bookmarks dataset.
http://mira.sai.msu.ru/~megera/tmp/js.copy.gz
set maintenance_work_mem = '1GB';
create index js_idx1 on js using gin(v jsonb_path_idx);
set maintenance_work_mem = '16MB';
create index js_idx2 on js using gin(v jsonb_path_ops);
List of relations
Schema | Name | Type | Owner | Table | Size | Description
--------+---------+-------+--------+-------+--------+-------------
public | js_idx1 | index | smagen | js | 432 MB |
public | js_idx2 | index | smagen | js | 309 MB |
(2 rows)
------
With best regards,
Alexander Korotkov.
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2014-05-20 02:24:07 | Re: buildfarm animals and 'snapshot too old' |
Previous Message | Andrew Dunstan | 2014-05-19 23:58:56 | Re: buildfarm animals and 'snapshot too old' |