On 17/1/26 14:58, Lillian Berry wrote:
Hmm, where is the evidence that your query uses theindex? Maybe the generic plan accidentally forces SeqScan?Logs on our PostgreSQL cluster show frequent slow reads on a simple query by unique index.This issue has been present for some years, and survived multiple server moves as well as PostgreSQL version upgrades. Vacuuming or reindexing the table does not seem to help.
-- regards, Andrei Lepikhov, pgEdge
