From: ktm@rice.edu <ktm@rice.edu>
To: Bertrand Paquet <bertrand.paquet@doctolib.fr>
Cc: pgsql-performance@postgresql.org
Subject: Re: Performance problem with gin index
Date: Tue, 29 Sep 2015 11:12:16 -0500
Message-ID: <20150929161216.GU30163@aart.rice.edu> (raw)
In-Reply-To: <CAN1xZsdH3w0yB6XtSJjX81PUCryuPViB=QtbdC2jLpO4BYY42g@mail.gmail.com>
References: <CAN1xZsdH3w0yB6XtSJjX81PUCryuPViB=QtbdC2jLpO4BYY42g@mail.gmail.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-performance>
On Tue, Sep 29, 2015 at 05:45:41PM +0200, Bertrand Paquet wrote:
> 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
Hi Bertrand,
You might try disabling fastupdate for the index. 9.5 has some work in
this area, but prior to that disabling it is the best fix. It certainly
helped our system with the same issue.
Regards,
Ken
--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: ktm@rice.edu, bertrand.paquet@doctolib.fr
Subject: Re: Performance problem with gin index
In-Reply-To: <20150929161216.GU30163@aart.rice.edu>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox