Re: -EXT-Re: Table not using tsvector gin index and performance much worse than when it uses it.

От: Tom Lane
Тема: Re: -EXT-Re: Table not using tsvector gin index and performance much worse than when it uses it.
Дата: ,
Msg-id: 10942.1491440905@sss.pgh.pa.us
(см: обсуждение, исходный текст)
Ответ на: Re: -EXT-Re: Table not using tsvector gin index andperformance much worse than when it uses it.  (rverghese)
Ответы: Re: -EXT-Re: Table not using tsvector gin index andperformance much worse than when it uses it.  (rverghese)
Список: pgsql-performance


rverghese <> writes:
> Will play around with those settings as well. Maybe start with default which
> is 50 I believe.

If you're on 9.5, auto-analyze does not result in a pending list flush,
so it's irrelevant to fixing your problem.  (Assuming I've identified
the problem correctly.)  But you do have gin_pending_list_limit, so see
what that does for you.  Note you can set it either globally or per-index.

            regards, tom lane



В списке pgsql-performance по дате сообщения:

От: rverghese
Дата:
Сообщение: Re: -EXT-Re: Table not using tsvector gin index andperformance much worse than when it uses it.
От: Dinesh Chandra 12108
Дата:
Сообщение: [PERFORM] Filter certain range of IP address.