Re: [GENERAL] gin index trouble

2017-11-03 Thread Rob Sargent
On 10/30/2017 10:56 AM, Peter Geoghegan wrote: On Mon, Oct 30, 2017 at 9:45 AM, Rob Sargent wrote: Peter, you beat me to the punch. I was just about to say "Having read the referenced message I thought I would add that we never delete from this table." In this

Re: [GENERAL] gin index trouble

2017-10-30 Thread Rob Sargent
On 10/30/2017 10:56 AM, Peter Geoghegan wrote: On Mon, Oct 30, 2017 at 9:45 AM, Rob Sargent wrote: Peter, you beat me to the punch. I was just about to say "Having read the referenced message I thought I would add that we never delete from this table." In this

Re: [GENERAL] gin index trouble

2017-10-30 Thread Peter Geoghegan
On Mon, Oct 30, 2017 at 9:45 AM, Rob Sargent wrote: > Peter, you beat me to the punch. I was just about to say "Having read the > referenced message I thought I would add that we never delete from this > table." In this particular case it was written to record by record,

Re: [GENERAL] gin index trouble

2017-10-30 Thread Rob Sargent
On 10/30/2017 10:32 AM, Peter Geoghegan wrote: On Fri, Oct 27, 2017 at 3:15 PM, Rob Sargent 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

Re: [GENERAL] gin index trouble

2017-10-30 Thread Peter Geoghegan
On Fri, Oct 27, 2017 at 3:15 PM, Rob Sargent 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

Re: [GENERAL] gin index trouble

2017-10-30 Thread Tom Lane
Rob Sargent writes: >> If you can make a test case that (eventually) hits that, we'd be >> interested to see it ... > Any hint(s) on what might trigger this sort of thing? I could duplicate > the upload, but I doubt you want the 800K records, 200M input file even > if

Re: [GENERAL] gin index trouble

2017-10-30 Thread Peter Geoghegan
On Mon, Oct 30, 2017 at 7:35 AM, Tom Lane wrote: > Rob Sargent writes: >> 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

Re: [GENERAL] gin index trouble

2017-10-30 Thread Rob Sargent
If you can make a test case that (eventually) hits that, we'd be interested to see it ... Any hint(s) on what might trigger this sort of thing? I could duplicate the upload, but I doubt you want the 800K records, 200M input file even if it did regenerate the problem. Would select * from

Re: [GENERAL] gin index trouble

2017-10-30 Thread Tom Lane
Rob Sargent writes: > 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. If you can make a test case that (eventually) hits that,

[GENERAL] gin index trouble

2017-10-30 Thread Rob Sargent
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