Performance problem with gin index

Поиск
Список
Период
Сортировка
От Bertrand Paquet
Тема Performance problem with gin index
Дата
Msg-id CAN1xZsdH3w0yB6XtSJjX81PUCryuPViB=QtbdC2jLpO4BYY42g@mail.gmail.com
обсуждение исходный текст
Ответы Re: Performance problem with gin index  ("ktm@rice.edu" <ktm@rice.edu>)
Re: Performance problem with gin index  (Jeff Janes <jeff.janes@gmail.com>)
Список 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

В списке pgsql-performance по дате отправления:

Предыдущее
От: "Graeme B. Bell"
Дата:
Сообщение: Another parallel postgres project...
Следующее
От: "ktm@rice.edu"
Дата:
Сообщение: Re: Performance problem with gin index