Re: Performance difference in accessing differrent columns in a Postgres Table

2018-09-06 Thread Dinesh Kumar
Ok, will do that. Thanks a lot. On Wed, Sep 5, 2018 at 9:37 PM Jeff Janes wrote: > > > On Wed, Sep 5, 2018 at 12:00 PM Jeff Janes wrote: > >> On Wed, Sep 5, 2018 at 12:21 AM Dinesh Kumar wrote: >> >>> Hi All, >>> I was wondering whether the case is solved or still continuing. As a >>> Postgres

Re: query gets very slow when :jsonb ?& operator is used

2018-09-06 Thread Jeff Janes
On Thu, Sep 6, 2018 at 7:52 PM wrote: > I have also asked this question on Stackoverflow and DBA stack exchange > with no answer. It's a fairly long post, so I will post a link to it, as on > Stackoverflow it is formatted nicely > > > https://stackoverflow.com/questions/52212878/query-gets-very-s

query gets very slow when :jsonb ?& operator is used

2018-09-06 Thread davidjesse091
I have also asked this question on Stackoverflow and DBA stack exchange with no answer. It's a fairly long post, so I will post a link to it, as on Stackoverflow it is formatted nicely  https://stackoverflow.com/questions/52212878/query-gets-very-slow-when-jsonb-operator-is-used Any idea why my