Performance problem with gin index

From: Bertrand Paquet <bertrand(dot)paquet(at)doctolib(dot)fr>
To: pgsql-performance(at)postgresql(dot)org
Subject: Performance problem with gin index
Date: 2015-09-29 15:45:41
Message-ID: CAN1xZsdH3w0yB6XtSJjX81PUCryuPViB=QtbdC2jLpO4BYY42g@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Hi,

We have got big slow down on our production plateform (PG 9.4.4).

After analyzing wals with pg_xlogdump, we see lot of writing in Gin Indexes.

We suspect slow down are related to the write of pending update on the
index.

So, is there any method to see
- what is the current config of gin_pending_list_limit on a given index ?
- the current size of pending list on a given index ?

Regards,

Bertrand

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message ktm@rice.edu 2015-09-29 16:12:16 Re: Performance problem with gin index
Previous Message Graeme B. Bell 2015-09-29 08:41:01 Another parallel postgres project...