Re: Parallel Seq Scan vs kernel read ahead

Поиск
Список
Период
Сортировка
От Thomas Munro
Тема Re: Parallel Seq Scan vs kernel read ahead
Дата
Msg-id CA+hUKGLD7FeyDkDbCU3=kkt30QdBuARv529PM=E5NsfGKr18Ug@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Parallel Seq Scan vs kernel read ahead  (Amit Kapila <amit.kapila16@gmail.com>)
Ответы Re: Parallel Seq Scan vs kernel read ahead  (Ranier Vilela <ranier.vf@gmail.com>)
Список pgsql-hackers
On Wed, May 20, 2020 at 2:23 PM Amit Kapila <amit.kapila16@gmail.com> wrote:
> Good experiment.  IIRC, we have discussed a similar idea during the
> development of this feature but we haven't seen any better results by
> allocating in ranges on the systems we have tried.  So, we want with
> the current approach which is more granular and seems to allow better
> parallelism.  I feel we need to ensure that we don't regress
> parallelism in existing cases, otherwise, the idea sounds promising to
> me.

Yeah, Linux seems to do pretty well at least with smallish numbers of
workers, and when you use large numbers you can probably tune your way
out of the problem.  ZFS seems to do fine.  I wonder how well the
other OSes cope.



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

Предыдущее
От: Noah Misch
Дата:
Сообщение: Re: Problem with pg_atomic_compare_exchange_u64 at 32-bit platformwd
Следующее
От: Justin Pryzby
Дата:
Сообщение: Re: Warn when parallel restoring a custom dump without data offsets