Re: Why does ExecComputeStoredGenerated() form a heap tuple - Mailing list pgsql-hackers

From Peter Eisentraut
Subject Re: Why does ExecComputeStoredGenerated() form a heap tuple
Date
Msg-id cff0f562-da0d-a3ed-9c99-e3ccadb29d65@2ndquadrant.com
Whole thread Raw
In response to Re: Why does ExecComputeStoredGenerated() form a heap tuple  (Andres Freund <andres@anarazel.de>)
Responses Re: Why does ExecComputeStoredGenerated() form a heap tuple
List 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 by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: Why does ExecComputeStoredGenerated() form a heap tuple
Next
From: Thomas Munro
Date:
Subject: Re: C_C_A animal on HEAD gets stuck in initdb