Re: Synchronized scans

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Jeff Davis <pgsql(at)j-davis(dot)com>
Cc: Heikki Linnakangas <heikki(at)enterprisedb(dot)com>, Alvaro Herrera <alvherre(at)commandprompt(dot)com>, Patches <pgsql-patches(at)postgresql(dot)org>
Subject: Re: Synchronized scans
Date: 2007-06-05 17:43:40
Message-ID: 21611.1181065420@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-patches

Jeff Davis <pgsql(at)j-davis(dot)com> writes:
> That's how it works now. Small limit queries don't change the location
> in the hint, so if you repeat them, the queries keep starting from the
> same place, and fetching the same tuples.

OK, maybe the problem's not as severe as I thought then.

regards, tom lane

In response to

Browse pgsql-patches by date

  From Date Subject
Next Message Jeff Davis 2007-06-05 17:48:32 Re: Synchronized scans
Previous Message Jeff Davis 2007-06-05 17:34:18 Re: Synchronized scans