Thx you for your hints.
I found lot of information in this thread
http://postgresql.nabble.com/how-to-investigate-GIN-fast-updates-and-cleanup-cycles-td5863756.html
Currently, we are monitoring pending_pages (pgstatginindex works on 9.4.4),
and run a vacuum every night. We hope it will solve the
On Tue, Sep 29, 2015 at 8:45 AM, Bertrand Paquet <
bertrand.paq...@doctolib.fr> wrote:
> Hi,
>
> We have got big slow down on our production plateform (PG 9.4.4).
>
What is it slow compared to? Did your version change, or your
workload/usage change?
>
> After analyzing wals with pg_xlogdump, w
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
> ind
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_pen
