Thread

Nick Gazaloff <nick@club.pyat.ru> — 2001-04-29T15:45:20Z

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