... - Mailing list pgsql-bugs

From Nick Gazaloff
Subject ...
Date
Msg-id 1749708169.20010429194520@club.pyat.ru
Whole thread Raw
List pgsql-bugs
Hi!

When I execute

SELECT min(id) FROM test;

PostgreSQL optimizer uses sequential scan for performing the query
even if any index on "id" exists. VACUUM ANALYZE just before the query
doesn't help. Runtime option to not use sequenatial scans doesn't help.
So, I suppose it's a real bug.

--
Best regards,
 Nick                          mailto:nick@club.pyat.ru

pgsql-bugs by date:

Previous
From: "J.R. Onyschak"
Date:
Subject: PostgreSQL bug in SELECT DISTINCT
Next
From: Vivek Khera
Date:
Subject: freebsd sample startup script doesn't work