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

Reply via email to