Received: from malur.postgresql.org ([217.196.149.56])
	by arkaria.postgresql.org with esmtp (Exim 4.84_2)
	(envelope-from
 <pgsql-hackers-owner+M337237=pgsql-hackers-arkari@postgresql.org>)
	id 1dz5Vx-0004PH-IN
	for pgsql-hackers@arkaria.postgresql.org; Mon, 02 Oct 2017 18:32:25 +0000
Received: from localhost ([127.0.0.1] helo=postgresql.org)
	by malur.postgresql.org with smtp (Exim 4.84_2)
	(envelope-from
 <pgsql-hackers-owner+M337237=pgsql-hackers-arkari@postgresql.org>)
	id 1dz5Vx-0002SL-3R
	for pgsql-hackers@arkaria.postgresql.org; Mon, 02 Oct 2017 18:32:25 +0000
Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29])
	by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256)
	(Exim 4.84_2)
	(envelope-from <tgl@sss.pgh.pa.us>)
	id 1dz5UP-00088x-C7
	for pgsql-hackers@postgresql.org; Mon, 02 Oct 2017 18:30:49 +0000
Received: from sss.pgh.pa.us ([66.207.139.130])
	by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256)
	(Exim 4.84_2)
	(envelope-from <tgl@sss.pgh.pa.us>)
	id 1dz5UI-00087q-8B
	for pgsql-hackers@postgresql.org; Mon, 02 Oct 2017 18:30:48 +0000
Received: from sss1.sss.pgh.pa.us (localhost [127.0.0.1])
	by sss.pgh.pa.us (8.14.4/8.14.4) with ESMTP id v92IUcT0010551;
	Mon, 2 Oct 2017 14:30:38 -0400
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Nico Williams <nico@cryptonector.com>
cc: Adam Brusselback <adambrusselback@gmail.com>,
        pgsql-hackers <pgsql-hackers@postgresql.org>
Subject: Re: generated columns
In-reply-to: <20171002181042.GI1251@localhost>
References: <b151f851-4019-bdb1-699e-ebab07d2f40a@2ndquadrant.com>
 <20171002152338.GH1251@localhost>
 <CAMjNa7fhskTTMSLMUL=e1r-EOg2Q3-cSayEDB1MADmX_zzn1gw@mail.gmail.com>
 <20171002181042.GI1251@localhost>
Comments: In-reply-to Nico Williams <nico@cryptonector.com>
	message dated "Mon, 02 Oct 2017 13:10:43 -0500"
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-ID: <10549.1506969038.1@sss.pgh.pa.us>
Date: Mon, 02 Oct 2017 14:30:38 -0400
Message-ID: <10550.1506969038@sss.pgh.pa.us>
List-Archive: <http://archives.postgresql.org/pgsql-hackers>
List-Help: <mailto:majordomo@postgresql.org?body=help>
List-ID: <pgsql-hackers.postgresql.org>
List-Owner: <mailto:pgsql-hackers-owner@postgresql.org>
List-Post: <mailto:pgsql-hackers@postgresql.org>
List-Subscribe: <mailto:majordomo@postgresql.org?body=sub%20pgsql-hackers>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-hackers>
X-Mailing-List: pgsql-hackers
Precedence: bulk
Sender: pgsql-hackers-owner@postgresql.org

Nico Williams <nico@cryptonector.com> writes:
> On Mon, Oct 02, 2017 at 12:50:14PM -0400, Adam Brusselback wrote:
>> So for me, i'd rather default to compute on read, as long storing the
>> pre-computed value is an option when necessary.

> Sure, I agree.  I was just wondering whether there might be any other
> difference besides performance characteristics.  The answer to that is,
> I think, "no".

What about non-immutable functions in the generation expression?

			regards, tom lane


-- 
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers