Re: [GENERAL] gin index trouble

Поиск
Список
Период
Сортировка
От Peter Geoghegan
Тема Re: [GENERAL] gin index trouble
Дата
Msg-id CAH2-WzmniOJGc_c8rAtMxkwm1QrRuW5sbL1ysJ1BsuM=YJNwAA@mail.gmail.com
обсуждение исходный текст
Ответ на [GENERAL] gin index trouble  (Rob Sargent <rsargent@xmission.com>)
Ответы Re: [GENERAL] gin index trouble  (Rob Sargent <robjsargent@gmail.com>)
Список pgsql-general
On Fri, Oct 27, 2017 at 3:15 PM, Rob Sargent <rsargent@xmission.com> wrote:
> I’ve hit this same message
>
> Caused by: org.postgresql.util.PSQLException: ERROR: right sibling of GIN
> page is of different type
>
> in a couple of contexts and I’m starting to get worried.
>
> I’ve rebuilt the index, but will that help?
> Is there a way to see what the ‘different type’ is?
> Is it caught/clean-up by vacuum analyse or some such?

Is there a lot of churn on this table? Do you either heavily update or
heavily delete rows in the table? Does vacuum tend to run on the table
rather frequently?

--
Peter Geoghegan


--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

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

Предыдущее
От: Adam Brusselback
Дата:
Сообщение: [GENERAL] UPDATE syntax change
Следующее
От: Justin Pryzby
Дата:
Сообщение: Re: [GENERAL] UPDATE syntax change (column-list UPDATE syntax failswith single column)