Re: plan time of MASSIVE partitioning ...

Поиск
Список
Период
Сортировка
От Leonardo Francalanci
Тема Re: plan time of MASSIVE partitioning ...
Дата
Msg-id 570592.14631.qm@web29006.mail.ird.yahoo.com
обсуждение исходный текст
Ответ на Re: plan time of MASSIVE partitioning ...  (Leonardo Francalanci <m_lists@yahoo.it>)
Список pgsql-hackers
> but I don't get any gain from the patch... explain time is still  around 250
>ms.
> Tried with 9000 partitions, time is still 2  secs.


Small correction: I tried with 3000 partitions (FOR i IN 0..3000 ...)
and got 250ms with both versions, with 9000 partitions 2 secs (again
no gain from the patch)





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

Предыдущее
От: Leonardo Francalanci
Дата:
Сообщение: Re: plan time of MASSIVE partitioning ...
Следующее
От: Robert Haas
Дата:
Сообщение: Re: sorted writes for checkpoints