Re: ice-broker scan thread

From: "Jeffrey W(dot) Baker" <jwbaker(at)acm(dot)org>
To: "Pollard, Mike" <mpollard(at)cincom(dot)com>
Cc: Qingqing Zhou <zhouqq(at)cs(dot)toronto(dot)edu>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: ice-broker scan thread
Date: 2005-11-29 17:35:44
Message-ID: 1133285745.1039.1.camel@toonses.gghcwest.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Tue, 2005-11-29 at 09:45 -0500, Pollard, Mike wrote:

> Anyway, what I did was the following. When doing a sequential scan, we
> were starting at the beginning of the table and scanning forward. If I
> threw up some threads to read ahead, then my user thread and my read
> ahead threads would thrash on trying to lock the buffer slots. So, I
> had the read ahead threads start at some distance into the table, and
> work toward the beginning.

I believe this is commonly called a synchronous scan.

-jwb

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Martijn van Oosterhout 2005-11-29 17:52:18 Re: ice-broker scan thread
Previous Message David Boreham 2005-11-29 17:28:57 Re: ice-broker scan thread