Postgres Pro
Downloads
Home   >   mailing lists

Re: Getting "could not read block" error when creating an index on a function. - Mailing list pgsql-general

From Christophe Pettus
Subject Re: Getting "could not read block" error when creating an index on a function.
Date
Msg-id C3727A25-70C1-4E9B-BD84-17AE5BA6B9C0@thebuild.com
Whole thread Raw
In response to Re: Getting "could not read block" error when creating an index on a function.  (Demitri Muna <postgresql@demitri.com>)
Responses Re: Getting "could not read block" error when creating an index on a function.  (Christophe Pettus <xof@thebuild.com>)
List pgsql-general
Tree view 

> On Dec 30, 2020, at 11:37, Demitri Muna <postgresql@demitri.com> wrote:
> I want to index the results of these repeated, unchanging calculations to speed up other queries. Which mechanism
wouldbe 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@thebuild.com

pgsql-general by date:

Previous
From: Karsten Hilbert
Date:
Subject: Re: Getting "could not read block" error when creating an index on a function.
Next
From: Christophe Pettus
Date:
Subject: Re: Getting "could not read block" error when creating an index on a function.