Request a Demo
Home   >   mailing lists

[Solved] Slow queries on simple index - Mailing list pgsql-performance

From Lillian Berry
Subject [Solved] Slow queries on simple index
Date
Msg-id bf946593-213d-4fb2-8f67-d10827b0605b@app.fastmail.com
Whole thread Raw
In response to Re: Slow queries on simple index  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-performance
Tree view 
> 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

pgsql-performance by date:

Previous
From: Tom Lane
Date:
Subject: Re: Slow queries on simple index
Next
From: Andrei Lepikhov
Date:
Subject: Re: Slow queries on simple index