[Solved] Slow queries on simple index

From: "Lillian Berry" <lillian(at)star-ark(dot)net>
To: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>, "Andrei Lepikhov" <lepihov(at)gmail(dot)com>
Cc: pgsql-performance(at)lists(dot)postgresql(dot)org, infra(at)pluralkit(dot)me
Subject: [Solved] Slow queries on simple index
Date: 2026-01-17 22:06:39
Message-ID: bf946593-213d-4fb2-8f67-d10827b0605b@app.fastmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-performance

> I bet it's a datatype mismatch issue.

It was indeed!

I changed the query to `select * from members where hid = ($1)::char(6)` and this completely got rid of the slow queries.

Thanks all!

Kindly,
Lillian

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Andrei Lepikhov 2026-01-18 09:24:56 Re: Slow queries on simple index
Previous Message Tom Lane 2026-01-17 21:10:45 Re: Slow queries on simple index