From: | Stefan Froehlich <postgresql(at)froehlich(dot)priv(dot)at> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: unable to understand query result |
Date: | 2022-07-06 09:57:14 |
Message-ID: | 20220706095714.GA13812@static.231.150.9.176.clients.your-server.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Wed, Jul 06, 2022 at 11:40:22AM +0200, Peter Eisentraut wrote:
> On 06.07.22 11:31, Stefan Froehlich wrote:
> >I have a database returing these result sets for two almost
> >identical queries:
> >
> >#v+
> >$ select id, pid, length(pid), md5(pid) from product where pid like '8000000';
> >(1 row)
> >
> >$ select id, pid, length(pid), md5(pid) from product where pid like '%8000000';
> >(2 rows)
> >#v-
> Check the EXPLAIN output for the two queries. Maybe there is index
> corruption somewhere.
OMG. Thanks, this was the root of the problem. Never run into this
before so it did not come to my mind.
Bye,
Stefan
From | Date | Subject | |
---|---|---|---|
Next Message | Francisco Olarte | 2022-07-06 10:11:27 | Re: ADD COLUMN ts tsvector GENERATED too slow |
Previous Message | Pavan Kumar S | 2022-07-06 09:55:18 | CPU is 100% azure rds postgreSQL-11 |