> On Dec 30, 2020, at 11:37, Demitri Muna <postgresql@xxxxxxxxxxx> wrote: > I want to index the results of these repeated, unchanging calculations to speed up other queries. Which mechanism would be best to do this? Create additional columns? Create another table? This might be a good use for a generated column. https://www.postgresql.org/docs/current/ddl-generated-columns.html -- -- Christophe Pettus xof@xxxxxxxxxxxx
