"PostgreSQL Bugs List" <[EMAIL PROTECTED]> writes:
> When I do a select * from table limit 1
> Postgresql does a sequential scan on the whole table.
AFAICS you simply are misreading the EXPLAIN output.
(It also sounds like you haven't vacuumed or analyzed that table in a
mighty long time... if y
The following bug has been logged online:
Bug reference: 1122
Logged by: P Buder
Email address: [EMAIL PROTECTED]
PostgreSQL version: 7.3.5
Operating system: Debian Linux
Description:limit 1 doing a sequential scan
Details:
I am actually running 7.3.6 but that
