Re: limit-offset different result sets with same query

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

2009/5/8 Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>:
> 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
>

It works Tom,
Thanks!

--
Emanuel Calvo Franco
Sumate al ARPUG !
( www.arpug.com.ar)
ArPUG / AOSUG Member

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Adam Rich 2009-05-08 21:36:10 Re: limit-offset different result sets with same query
Previous Message David Fetter 2009-05-08 21:33:59 Re: limit-offset different result sets with same query