Horton

Re: generated columns

Adam Brusselback <adambrusselback@gmail.com>

View thread View on postgr.es
From: Adam Brusselback <adambrusselback@gmail.com>
To: pgsql-hackers <pgsql-hackers@postgresql.org>
Date: 2017-10-02T16:50:14Z
Lists: 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

Commits

  1. Generated columns

  2. Add walreceiver API to get remote server version

  3. Add pg_partition_tree to display information about partitions

  4. pg_restore: Augment documentation for -N option

  5. Change delimiter used for display of NextXID