Re: Speeding up INSERTs and UPDATEs to partitioned tables

Поиск
Список
Период
Сортировка
От David Rowley
Тема Re: Speeding up INSERTs and UPDATEs to partitioned tables
Дата
Msg-id CAKJS1f_OPRRhX-DJ=EqUvq1cnNQx_YJkojeK9dbHLnCgXmA3hQ@mail.gmail.com
обсуждение исходный текст
Ответ на Speeding up INSERTs and UPDATEs to partitioned tables  (David Rowley <david.rowley@2ndquadrant.com>)
Ответы RE: Speeding up INSERTs and UPDATEs to partitioned tables  ("Kato, Sho" <kato-sho@jp.fujitsu.com>)
Список pgsql-hackers
On 22 June 2018 at 18:28, David Rowley <david.rowley@2ndquadrant.com> wrote:
> I've written fixes for items 1-6 above.
>
> I did:
>
> 1. Use an array instead of a List.
> 2. Don't do this loop. palloc0() the partitions array instead. Let
> UPDATE add whatever subplans exist to the zeroed array.
> 3. Track what we initialize in a gapless array and cleanup just those
> ones. Make this array small and increase it only when we need more
> space.
> 4. Only allocate the map array when we need to store a map.
> 5. Work that out in relcache beforehand.
> 6. ditto

I've added this to the July 'fest:

https://commitfest.postgresql.org/18/1690/

-- 
 David Rowley                   http://www.2ndQuadrant.com/
 PostgreSQL Development, 24x7 Support, Training & Services


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

Предыдущее
От: Christian Ohler
Дата:
Сообщение: Re: Using JSONB directly from application
Следующее
От: Nico Williams
Дата:
Сообщение: Re: Using JSONB directly from application