From: Tomas Vondra <tomas.vondra@enterprisedb.com>
To: John Burns <john@impactdatametrics.com>
Cc: pgsql-bugs@lists.postgresql.org
Subject: Re: Index plan returns different results to sequential scan
Date: Fri, 22 Mar 2024 00:58:09 +0100
Message-ID: <27496161-e7ec-47bd-b559-3571fde4dcb4@enterprisedb.com> (raw)
In-Reply-To: <881DF028-5222-486C-A13B-451239C1316F@impactdatametrics.com>
References: <3B86F188-F4BF-4331-AD79-E5FF2D0711A3@impactdatametrics.com>
<72600f8a-4231-45b7-a116-8ceec5ccf66e@enterprisedb.com>
<881DF028-5222-486C-A13B-451239C1316F@impactdatametrics.com>
On 3/21/24 21:08, John Burns wrote:
>
>
>> On 21 Mar 2024, at 20:27, Tomas Vondra <tomas.vondra@enterprisedb.com> wrote:
>>
>>
>> Sorry about that … the patched version of the package, plus a sample data set is in the attached zip file,
>>
>> -John
>>
Thanks, I can reproduce the issue. I don't know why is it happening, but
the behavior I see is that the (postcode % 'NW10') query somehow misses
rows with postcodes 'NW10 0AA' - 'NW10 3NL' when executed using index.
I don't see anything obviously wrong in the extension / index pages.
You suggested it used to work OK and then broke. Do you perhaps know at
which version it broke? Or did you use 9.x until now, upgrades to 16 and
realized it's broken?
regards
--
Tomas Vondra
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company
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-bugs@postgresql.org
Cc: tomas.vondra@enterprisedb.com, john@impactdatametrics.com, pgsql-bugs@lists.postgresql.org
Subject: Re: Index plan returns different results to sequential scan
In-Reply-To: <27496161-e7ec-47bd-b559-3571fde4dcb4@enterprisedb.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