Re: Parallel Seq Scan

Поиск
Список
Период
Сортировка
От Joshua D. Drake
Тема Re: Parallel Seq Scan
Дата
Msg-id 54C298F5.6040107@commandprompt.com
обсуждение исходный текст
Ответ на Re: Parallel Seq Scan  (Jim Nasby <Jim.Nasby@BlueTreble.com>)
Ответы Re: Parallel Seq Scan  (Amit Kapila <amit.kapila16@gmail.com>)
Список pgsql-hackers
On 01/23/2015 10:44 AM, Jim Nasby wrote:
> number of workers especially at slightly higher worker count.
>
> Those fixed chunk numbers look pretty screwy. 2, 4 and 8 workers make no
> difference, then suddenly 16 cuts times by 1/2 to 1/3? Then 32 cuts time
> by another 1/2 to 1/3?

cached? First couple of runs gets the relations into memory?

JD



-- 
Command Prompt, Inc. - http://www.commandprompt.com/  503-667-4564
PostgreSQL Support, Training, Professional Services and Development
High Availability, Oracle Conversion, @cmdpromptinc
"If we send our children to Caesar for their education, we should             not be surprised when they come back as
Romans."



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

Предыдущее
От: Stephen Frost
Дата:
Сообщение: Re: pg_upgrade and rsync
Следующее
От: Andres Freund
Дата:
Сообщение: Re: pg_upgrade and rsync