Re: SELECTing every Nth record for better performance

[Grzegorz Jaśkiewicz <gryzman@xxxxxxxxx>]

why create another table, straightforward on 8.4:
SELECT * FROM (SELECT *, (row_number() OVER( ORDER BY id))%10 AS rn FROM table) sa WHERE sa.rn=1 LIMIT 10;