Re: Why does ExecComputeStoredGenerated() form a heap tuple

Поиск
Список
Период
Сортировка
От Peter Eisentraut
Тема Re: Why does ExecComputeStoredGenerated() form a heap tuple
Дата
Msg-id cff0f562-da0d-a3ed-9c99-e3ccadb29d65@2ndquadrant.com
обсуждение исходный текст
Ответ на Re: Why does ExecComputeStoredGenerated() form a heap tuple  (Andres Freund <andres@anarazel.de>)
Ответы Re: Why does ExecComputeStoredGenerated() form a heap tuple  (Andres Freund <andres@anarazel.de>)
Список pgsql-hackers
On 2019-03-31 05:00, Andres Freund wrote:
> Also, have you actually benchmarked this code? ISTM that adding a
> stored generated column would cause quite noticable slowdowns in the
> COPY path based on this code.

Yes, it'll be slower than not having it, but it's much faster than the
equivalent trigger.

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



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

Предыдущее
От: Peter Eisentraut
Дата:
Сообщение: Re: Why does ExecComputeStoredGenerated() form a heap tuple
Следующее
От: Thomas Munro
Дата:
Сообщение: Re: C_C_A animal on HEAD gets stuck in initdb