Re: limit-offset different result sets with same query

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Emanuel Calvo Franco <postgres(dot)arg(at)gmail(dot)com>
Cc: postgresql Forums <pgsql-general(at)postgresql(dot)org>
Subject: Re: limit-offset different result sets with same query
Date: 2009-05-08 21:24:20
Message-ID: 15343.1241817860@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Emanuel Calvo Franco <postgres(dot)arg(at)gmail(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message David Fetter 2009-05-08 21:33:59 Re: limit-offset different result sets with same query
Previous Message Emanuel Calvo Franco 2009-05-08 21:10:18 limit-offset different result sets with same query