Re: Speeding up INSERTs and UPDATEs to partitioned tables

Поиск
Список
Период
Сортировка
От Amit Langote
Тема Re: Speeding up INSERTs and UPDATEs to partitioned tables
Дата
Msg-id a9c2dd8f-f406-e59e-65f5-a837cf033e52@lab.ntt.co.jp
обсуждение исходный текст
Ответ на Re: Speeding up INSERTs and UPDATEs to partitioned tables  (Krzysztof Nienartowicz <krzysztof.nienartowicz@gmail.com>)
Список pgsql-hackers
Hi,

On 2018/10/15 19:04, Krzysztof Nienartowicz wrote:
> 
> We see quite prohibitive 5-6x slowdown with native partitioning on in
> comparison to trigger based in PG9.5.
> This is clearly visible with highly parallel inserts (Can share
> flamediagrams comparing the two). 
> 
> This basically excludes native partitioning from being used by us. Do you
> think your changes could be backported to PG10? - we checked and this would
> need quite a number of changes but given the weight of this change maybe it
> could be considered?

It's unfortunate that PG 10's partitioning cannot be used for your use
case, but I don't think such a major refactoring will be back-ported to 10
or 11. :-(

Thanks,
Amit



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

Предыдущее
От: Krzysztof Nienartowicz
Дата:
Сообщение: Re: Speeding up INSERTs and UPDATEs to partitioned tables
Следующее
От: John Naylor
Дата:
Сообщение: Re: WIP: Avoid creation of the free space map for small tables