Re: Parallel Select query performance and shared buffers

Поиск
Список
Период
Сортировка
От Metin Doslu
Тема Re: Parallel Select query performance and shared buffers
Дата
Msg-id CAL1dPcfJmYNaegTUVi9nDYZRBwr8F=dWUTcdUg9Y1P1gO-nYWw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Parallel Select query performance and shared buffers  (Andres Freund <andres@2ndquadrant.com>)
Ответы Re: Parallel Select query performance and shared buffers  (Andres Freund <andres@2ndquadrant.com>)
Список pgsql-performance
Дерево обсуждения
> Is your workload bigger than RAM?

RAM is bigger than workload (more than a couple of times).

> I think a good bit of the contention
> you're seeing in that listing is populating shared_buffers - and might
> actually vanish once you're halfway cached.
> From what I've seen so far the bigger problem than contention in the
> lwlocks itself, is the spinlock protecting the lwlocks...

Could you clarify a bit what do you mean by "halfway cached" and "spinlock protecting the lwlocks".

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

Предыдущее
От: Andres Freund
Дата:
Сообщение: Re: Parallel Select query performance and shared buffers
Следующее
От: Andres Freund
Дата:
Сообщение: Re: Parallel Select query performance and shared buffers