| From: | "ktm(at)rice(dot)edu" <ktm(at)rice(dot)edu> |
|---|---|
| To: | Bertrand Paquet <bertrand(dot)paquet(at)doctolib(dot)fr> |
| Cc: | pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: Performance problem with gin index |
| Date: | 2015-09-29 16:12:16 |
| Message-ID: | 20150929161216.GU30163@aart.rice.edu |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Corey Huinker | 2015-09-29 16:25:05 | Re: Another parallel postgres project... |
| Previous Message | Bertrand Paquet | 2015-09-29 15:45:41 | Performance problem with gin index |