Re: ice-broker scan thread

Поиск
Список
Период
Сортировка
От Martijn van Oosterhout
Тема Re: ice-broker scan thread
Дата
Msg-id 20051129150617.GE31333@svana.org
обсуждение исходный текст
Ответ на Re: ice-broker scan thread  ("Pollard, Mike" <mpollard@cincom.com>)
Список pgsql-hackers
On Tue, Nov 29, 2005 at 09:45:30AM -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

<snip>

> so above, the user threads is starting low in the table and working
> high; the readahead threads are starting higher (but not at the end of
> the table), and working low.

Ok, this may be a really dumb question, but doesn't this rely on the
fact that the table is smaller than the amount of buffers? If the table
is large most of your data will be tossed out again by later data
before it's been used by the backend.

Have a nice day,
--
Martijn van Oosterhout   <kleptog@svana.org>   http://svana.org/kleptog/
> Patent. n. Genius is 5% inspiration and 95% perspiration. A patent is a
> tool for doing 5% of the work and then sitting around waiting for someone
> else to do the other 95% so you can sue them.

В списке pgsql-hackers по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Using multi-row technique with COPY
Следующее
От: "Pollard, Mike"
Дата:
Сообщение: Re: ice-broker scan thread