RE: Performance of the partitioning in the large scale

Поиск
Список
Период
Сортировка
От Kato, Sho
Тема RE: Performance of the partitioning in the large scale
Дата
Msg-id 25C1C6B2E7BE044889E4FE8643A58BA963B259B7@G01JPEXMBKW03
обсуждение исходный текст
Ответ на Re: Performance of the partitioning in the large scale  (David Rowley <david.rowley@2ndquadrant.com>)
Список pgsql-hackers
On Friday, September 28, 2018 6:03 AM, David Rowley < david.rowley@2ndquadrant.com> wrote:
> I think instead of attempting to highlight other bottlenecks, it might
> be better to focus on lending a hand reviewing and testing the existing
> set of patches. 

Thanks for your reply. Ok, I focus on reviewing and testing the existing set of patches.

> Unless you're running with plan_cache_mode =
> 'force_generic_plan' then the overhead of the partitioned cases likely
> includes planning too.

I'm running with plan_cache_mode = auto. I'll check cached plan is used.

Thanks,
--
Sho Kato

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

Предыдущее
От: Andres Freund
Дата:
Сообщение: Re: Pluggable Storage - Andres's take
Следующее
От: Michael Paquier
Дата:
Сообщение: Re: heap_sync seems rather oblivious to partitioned tables(wal_level=minimal)