Re: Making "COPY partitioned_table FROM" faster

Поиск
Список
Период
Сортировка
От Peter Eisentraut
Тема Re: Making "COPY partitioned_table FROM" faster
Дата
Msg-id d6546c1a-ce05-c589-f2f0-b5d9c964bee3@2ndquadrant.com
обсуждение исходный текст
Ответ на Re: Making "COPY partitioned_table FROM" faster  (David Rowley <david.rowley@2ndquadrant.com>)
Ответы Re: Making "COPY partitioned_table FROM" faster  (Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>)
Re: Making "COPY partitioned_table FROM" faster  (David Rowley <david.rowley@2ndquadrant.com>)
Список pgsql-hackers
Two more thoughts:

- Add some tests.  The if (nBufferedTuples > 0) that flushes the tuples
when the partition changes is not currently exercised.

- With proute becoming a function-level variable,
cstate->partition_tuple_routing is obsolete and could be removed.  (No
point in saving this in cstate if it's only used in one function anyway.)

-- 
Peter Eisentraut              http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services


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

Предыдущее
От: Amit Langote
Дата:
Сообщение: Re: Speeding up INSERTs and UPDATEs to partitioned tables
Следующее
От: Amit Langote
Дата:
Сообщение: Re: Making "COPY partitioned_table FROM" faster