Re: ice-broker scan thread

Поиск
Список
Период
Сортировка
От David Boreham
Тема Re: ice-broker scan thread
Дата
Msg-id 438C6D4A.4000103@boreham.org
обсуждение исходный текст
Ответ на Re: ice-broker scan thread  ("Pollard, Mike" <mpollard@cincom.com>)
Список pgsql-hackers
>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.  The user thread would do its own I/O until
>  
>
Ah. The lightbulb went on. You want multiple outstanding I/O operations
in the case that table or index spans multiple physical disks.




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

Предыдущее
От: Mario Weilguni
Дата:
Сообщение: Re: Hashjoin startup strategy (was Re: Getting different number of results when using hashjoin on/off)
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Using multi-row technique with COPY