From: Nick Gazaloff <nick(at)club(dot)pyat(dot)ru>
To: pgsql-bugs(at)postgresql(dot)org
Subject:
Date: 2001-04-29 15:45:20
Message-ID: 1749708169.20010429194520@club.pyat.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)club(dot)pyat(dot)ru

Browse pgsql-bugs by date

  From Date Subject
Next Message pgsql-bugs 2001-04-30 01:52:05 DECIMAL NULL value
Previous Message Peter Mount 2001-04-29 10:09:21 Re: