Date: Thu, 6 Sep 2018 23:51:46 +0000 (UTC)
From: <davidjesse091@aol.com>
To: pgsql-performance@lists.postgresql.org
Message-ID: <401454367.836254.1536277906458@mail.yahoo.com>
Subject: query gets very slow when :jsonb ?& operator is used
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_Part_836253_1087396995.1536277906457"
References: <401454367.836254.1536277906458.ref@mail.yahoo.com>
Content-Length: 1735
Precedence: bulk

------=_Part_836253_1087396995.1536277906457
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

I have also asked this question on Stackoverflow and DBA stack exchange wit=
h no answer. It's a fairly long post, so I will post a link to it, as on St=
ackoverflow it is formatted nicely=C2=A0
https://stackoverflow.com/questions/52212878/query-gets-very-slow-when-json=
b-operator-is-used

Any idea why my query slows down so much when I add=C2=A0account.residence_=
details::jsonb ?& array['city', 'state', 'streetName'] ?
------=_Part_836253_1087396995.1536277906457
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: 7bit

<font color='black' size='2' face='Arial, Helvetica, sans-serif'>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&nbsp;
<div><br>
</div>

<div>https://stackoverflow.com/questions/52212878/query-gets-very-slow-when-jsonb-operator-is-used<br>
</div>

<div><br>
</div>

<div>Any idea why my query slows down so much when I add&nbsp;<span style="background-color: rgb(239, 240, 241); color: rgb(36, 39, 41); font-family: Consolas, Menlo, Monaco, &quot;Lucida Console&quot;, &quot;Liberation Mono&quot;, &quot;DejaVu Sans Mono&quot;, &quot;Bitstream Vera Sans Mono&quot;, &quot;Courier New&quot;, monospace, sans-serif; font-size: 13px; white-space: pre-wrap;">account.residence_details::jsonb ?&amp; array['city', 'state', 'streetName']</span><span style="background-color: rgb(239, 240, 241); color: rgb(36, 39, 41); font-size: 13px; white-space: pre-wrap;"> ?</span></div>
</font>
------=_Part_836253_1087396995.1536277906457--