Re: [PERFORM] The usual sequential scan, but with LIMIT !

[Pierre-Frédéric Caillaud]

Update :
select * from apparts where departement=69 order by departement limit 10;
does use an index scan (because of the ORDER BY), even with OFFSET, and  
it's a lot faster.

---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
     joining column's datatypes do not match