Re: The usual sequential scan, but with LIMIT !

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.