Re: Parallel Select query performance and shared buffers

Поиск
Список
Период
Сортировка
От Claudio Freire
Тема Re: Parallel Select query performance and shared buffers
Дата
Msg-id CAGTBQpYE3oRUfrt+++E-AFenfnnC8tRZie-Gf7fZHkV48Cwxyg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Parallel Select query performance and shared buffers  (Metin Doslu <metin@citusdata.com>)
Список pgsql-performance
Дерево обсуждения 
On Tue, Dec 3, 2013 at 1:24 PM, Metin Doslu <metin@citusdata.com> wrote:
> Looking into syncscan.c, it says in comments:
>
> "When multiple backends run a sequential scan on the same table, we try to
> keep them synchronized to reduce the overall I/O needed."
>
> But in my workload, every process was running on a different table.

Ah, ok, so that's what you meant by "independent tables".

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

Предыдущее
От: Metin Doslu
Дата:
Сообщение: Re: Parallel Select query performance and shared buffers
Следующее
От: Jan Michel
Дата:
Сообщение: Re: One query run twice in parallel results in huge performance decrease