rverghese <riyav@xxxxxxxxxxx> 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 -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
