Re: limit-offset different result sets with same query

Emanuel Calvo Franco <postgres.arg@gmail.com> writes:
> Executing 'select * from datos limit 1 offset 150000' two times i have different
> result sets.

The "synchronous scan" logic is probably responsible.  Turn off
synchronize_seqscans if this behavior bothers you.

            regards, tom lane