Re: [HACKERS] Error creating gin index on jsonb columns

2015-10-16 Thread Glenn Zhu
reported are from large tables, with number of rows between 150 to 350 millions. What would you need in terms of test cases? Thank you very much. -glenn On Fri, Oct 16, 2015 at 6:28 AM, Tom Lane <t...@sss.pgh.pa.us> wrote: > Glenn Zhu <g...@medallia.com> writes: > > We

Re: [HACKERS] Error creating gin index on jsonb columns

2015-10-16 Thread Glenn Zhu
ad" values? Maybe I shall drop all these indexes. If it's a bug, what information would be needed to trigger a bug fix? Is there a formal channel? Thanks. -glenn On Fri, Oct 16, 2015 at 6:43 AM, Tom Lane <t...@sss.pgh.pa.us> wrote: > Glenn Zhu <g...@medallia.com> writes: &g

[HACKERS] Error creating gin index on jsonb columns

2015-10-16 Thread Glenn Zhu
deploy to multiple databases we got exactly the same error. I did try to set maintenance_work_mam to 4GB and still the same error occurred. Thank you. -glenn -- Glenn Zhu SaaS Operations | ❖ Medallia, Inc.

Re: [HACKERS] Error creating gin index on jsonb columns

2015-10-16 Thread Glenn Zhu
in general? -glenn On Fri, Oct 16, 2015 at 7:02 AM, Tom Lane <t...@sss.pgh.pa.us> wrote: > Glenn Zhu <g...@medallia.com> writes: > > Currently, after hitting the error, the indexes were still created but > > marked with status of "invalid" > > That's j

Re: [HACKERS] Error creating gin index on jsonb columns

2015-10-16 Thread Glenn Zhu
We will follow your instructions and get back to you. Thank you Tom. Much appreciated! -glenn On Fri, Oct 16, 2015 at 7:16 AM, Tom Lane <t...@sss.pgh.pa.us> wrote: > Glenn Zhu <g...@medallia.com> writes: > > Is this categorized as a bug specific to GIN indexe