Re: speeding up planning with partitions

Поиск
Список
Период
Сортировка
От Jesper Pedersen
Тема Re: speeding up planning with partitions
Дата
Msg-id dcda0c1b-6360-193d-9c94-0113b0b905a1@redhat.com
обсуждение исходный текст
Ответ на Re: speeding up planning with partitions  (Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>)
Ответы Re: speeding up planning with partitions
Список pgsql-hackers
On 3/5/19 5:24 AM, Amit Langote wrote:
> Attached an updated version.  This incorporates fixes for both Jesper's
> and Imai-san's review.  I haven't been able to pin down the bug (or
> whatever) that makes throughput go down as the partition count increases,
> when tested with a --enable-cassert build.
> 

Thanks !

I'm seeing the throughput going down as well, but are you sure it isn't 
just the extra calls of MemoryContextCheck you are seeing ? A flamegraph 
diff highlights that area -- sent offline.

A non cassert build shows the same profile for 64 and 1024 partitions.

Best regards,
  Jesper


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