Re: [HACKERS] generated columns

From: Michael Paquier <michael(at)paquier(dot)xyz>
To: Peter Eisentraut <peter(dot)eisentraut(at)2ndquadrant(dot)com>
Cc: Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>, pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>, Sergei Kornilov <sk(at)zsrv(dot)org>, Jaime Casanova <jaime(dot)casanova(at)2ndquadrant(dot)com>
Subject: Re: [HACKERS] generated columns
Date: 2019-02-01 03:48:09
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-hackers

On Thu, Jan 17, 2019 at 10:12:26AM +0900, Michael Paquier wrote:
> Yes, something like that grows the memory and CPU usage rather
> linearly:
> CREATE TABLE tab (a int, b int GENERATED ALWAYS AS (a * 2) STORED);
> INSERT INTO tab VALUES (generate_series(1,100000000));

The latest patch set got plenty of feedback not addressed yet, so I am
marking it as returned with feedback.

In response to


Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2019-02-01 03:51:11 Re: [PATCH] Pass COPT and PROFILE to CXXFLAGS as well
Previous Message Michael Paquier 2019-02-01 03:46:18 Re: pg_dumpall --exclude-database option