Re: [GENERAL] SELECTing every Nth record for better performance

[Grzegorz Jaśkiewicz]

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;