Postgres Pro
Downloads
Home   >   mailing lists

Re: [GENERAL] gin index trouble - Mailing list pgsql-general

From Peter Geoghegan
Subject Re: [GENERAL] gin index trouble
Date
Msg-id CAH2-WzmniOJGc_c8rAtMxkwm1QrRuW5sbL1ysJ1BsuM=YJNwAA@mail.gmail.com
Whole thread Raw
In response to [GENERAL] gin index trouble  (Rob Sargent <rsargent@xmission.com>)
Responses Re: [GENERAL] gin index trouble  (Rob Sargent <robjsargent@gmail.com>)
List pgsql-general
Tree view 
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 by date:

Previous
From: Adam Brusselback
Date:
Subject: [GENERAL] UPDATE syntax change
Next
From: Justin Pryzby
Date:
Subject: Re: [GENERAL] UPDATE syntax change (column-list UPDATE syntax failswith single column)