Search Postgresql Archives
Re: GENERATED STORED columns and table rewrites?
[
Date Prev
][
Date Next
][
Thread Prev
][
Thread Next
][
Date Index
][
Thread Index
]
Subject
: Re: GENERATED STORED columns and table rewrites?
From
: Michael Lewis <mlewis@xxxxxxxxxxx>
Date
: Wed, 15 Apr 2020 14:44:55 -0600
Cc
: "pgsql-generallists.postgresql.org" <pgsql-general@xxxxxxxxxxxxxxxxxxxx>
In-reply-to
: <
CAOtHd0BMw1A58d35DjWj5jScbmcoF1heGbBz_WV7kd2fU92cKg@mail.gmail.com
>
References
: <
CAOtHd0BMw1A58d35DjWj5jScbmcoF1heGbBz_WV7kd2fU92cKg@mail.gmail.com
>
Yes, the system will do a full table rewrite to compute the value and store it. Unfortunately, I believe it is an access exclusive lock during that entire time.
[
Date Prev
][
Date Next
][
Thread Prev
][
Thread Next
][
Date Index
][
Thread Index
]
References
:
GENERATED STORED columns and table rewrites?
From:
Maciek Sakrejda
Prev by Date:
Re: timestamp and timestamptz
Next by Date:
Re: timestamp and timestamptz
Previous by thread:
GENERATED STORED columns and table rewrites?
Next by thread:
timestamp and timestamptz
Index(es):
Date
Thread
[Index of Archives]
[Postgresql Jobs]
[Postgresql Admin]
[Postgresql Performance]
[Linux Clusters]
[PHP Home]
[PHP on Windows]
[Kernel Newbies]
[PHP Classes]
[PHP Books]
[PHP Databases]
[Postgresql & PHP]
[Yosemite]
