[Solved] Slow queries on simple index

Поиск
Список
Период
Сортировка
От Lillian Berry
Тема [Solved] Slow queries on simple index
Дата
Msg-id bf946593-213d-4fb2-8f67-d10827b0605b@app.fastmail.com
обсуждение
Ответ на Re: Slow queries on simple index  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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



В списке pgsql-performance по дате отправления: