Negative imact of maintenance_work_mem to GIN size

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.

Responses

Browse pgsql-hackers by date

  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'