> it was veery fast. To be honest I do not know what is happening?!
This is really weird.
It seems that PostgreSql OFFSET / LIMIT are not optimized and thus typical
paging queries
SELECT ... FROM bigtable ORDER BY intprimarykey OFFSET pageno*100 LIMIT 100
or even first page query
SELECT ... FROM bigtable ORDER BY intprimarykey OFFSET 0 LIMIT 100
cannot be used in PostgreSql at all for big tables.
Do you have any idea how to fix this ?
Andrus.