Postgres Pro
Downloads
Home   >   mailing lists

Re: GIN JSONB path index is not always used - Mailing list pgsql-performance

From Laurenz Albe
Subject Re: GIN JSONB path index is not always used
Date
Msg-id 93a4f67a1a2fea0a6f59a1f6f314b173f4a27d58.camel@cybertec.at
Whole thread Raw
In response to GIN JSONB path index is not always used  (Tomasz Szymański <lime129@gmail.com>)
List pgsql-performance
Tree view 
On Tue, 2023-10-17 at 15:48 +0200, Tomasz Szymański wrote:
> Hello! We have an issue with database planner choosing really expensive sequence scan instead of an index scan in
somecases. 

To analyze that, we'd need the output from EXPLAIN (ANALYZE, BUFFERS) SELECT ...
Plain text format please, no JSON.

Yours,
Laurenz Albe

pgsql-performance by date:

Previous
From: Tomasz Szymański
Date:
Subject: GIN JSONB path index is not always used
Next
From: Jeff Janes
Date:
Subject: Re: GIN JSONB path index is not always used