Re: [HACKERS] generated columns
От | Nico Williams |
---|---|
Тема | Re: [HACKERS] generated columns |
Дата | |
Msg-id | 20171002152338.GH1251@localhost обсуждение исходный текст |
Ответ на | [HACKERS] generated columns (Peter Eisentraut <peter.eisentraut@2ndquadrant.com>) |
Ответы |
Re: [HACKERS] generated columns
|
Список | pgsql-hackers |
On Thu, Aug 31, 2017 at 12:16:43AM -0400, Peter Eisentraut wrote: > In previous discussions, it has often been a source of confusion whether > these generated columns are supposed to be computed on insert/update and > stored, or computed when read. The SQL standard is not explicit, but > appears to lean toward stored. DB2 stores. Oracle computes on read. Question: How would one know the difference between storing computed columns vs. computing them on read? Answer?: Performance. If the computation is slow, then you'll really notice on read. Nico -- -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
В списке pgsql-hackers по дате отправления: