Postgres Pro
Downloads
Home   >   mailing lists

Re: limit-offset different result sets with same query - Mailing list pgsql-general

From Tom Lane
Subject Re: limit-offset different result sets with same query
Date
Msg-id 15343.1241817860@sss.pgh.pa.us
Whole thread Raw
In response to limit-offset different result sets with same query  (Emanuel Calvo Franco <postgres.arg@gmail.com>)
Responses Re: limit-offset different result sets with same query
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: Emanuel Calvo Franco
Date:
Subject: limit-offset different result sets with same query
Next
From: David Fetter
Date:
Subject: Re: limit-offset different result sets with same query