Postgres Pro
Downloads
Home   >   mailing lists

Performance problem with gin index - Mailing list pgsql-performance

From Bertrand Paquet
Subject Performance problem with gin index
Date
Msg-id CAN1xZsdH3w0yB6XtSJjX81PUCryuPViB=QtbdC2jLpO4BYY42g@mail.gmail.com
Whole thread Raw
Responses Re: Performance problem with gin index
Re: Performance problem with gin index
List pgsql-performance
Tree view
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

pgsql-performance by date:

Previous
From: "Graeme B. Bell"
Date:
Subject: Another parallel postgres project...
Next
From: "ktm@rice.edu"
Date:
Subject: Re: Performance problem with gin index