Re: [HACKERS] generated columns - Mailing list pgsql-hackers

From Adam Brusselback
Subject Re: [HACKERS] generated columns
Date
Msg-id CAMjNa7fhskTTMSLMUL=e1r-EOg2Q3-cSayEDB1MADmX_zzn1gw@mail.gmail.com
Whole thread Raw
In response to Re: [HACKERS] generated columns  (Nico Williams <nico@cryptonector.com>)
Responses Re: [HACKERS] generated columns
List pgsql-hackers
I know that for my use-cases, having both options available would be very appreciated.  The vast majority of the computed columns I would use in my database would be okay to compute on read.  But there are for sure some which would be performance prohibitive to have compute on read, so i'd rather have those stored.

So for me, i'd rather default to compute on read, as long storing the pre-computed value is an option when necessary.

Just my $0.02
Thanks,
-Adam

pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: [HACKERS] issue: record or row variable cannot be part of multiple-item INTO list
Next
From: Alexander Korotkov
Date:
Subject: Re: [HACKERS] GSoC 2017: weekly progress reports (week 6)