From: davidjesse091@aol.com
To: pgsql-performance@lists.postgresql.org
Subject: query gets very slow when :jsonb ?& operator is used
Date: Thu, 6 Sep 2018 23:51:46 +0000 (UTC)
Message-ID: <401454367.836254.1536277906458@mail.yahoo.com> (raw)
References: <401454367.836254.1536277906458.ref@mail.yahoo.com>
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 query slows down so much when I add account.residence_details::jsonb ?& array['city', 'state', 'streetName'] ?
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: davidjesse091@aol.com, pgsql-performance@lists.postgresql.org
Subject: Re: query gets very slow when :jsonb ?& operator is used
In-Reply-To: <401454367.836254.1536277906458@mail.yahoo.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox