Re: Getting "could not read block" error when creating an index on a function.

From: Christophe Pettus <xof(at)thebuild(dot)com>
To: Demitri Muna <postgresql(at)demitri(dot)com>
Cc: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: Getting "could not read block" error when creating an index on a function.
Date: 2020-12-30 19:48:26
Message-ID: C3727A25-70C1-4E9B-BD84-17AE5BA6B9C0@thebuild.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> On Dec 30, 2020, at 11:37, Demitri Muna <postgresql(at)demitri(dot)com> 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(at)thebuild(dot)com

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Christophe Pettus 2020-12-30 19:49:32 Re: Getting "could not read block" error when creating an index on a function.
Previous Message Karsten Hilbert 2020-12-30 19:45:50 Re: Getting "could not read block" error when creating an index on a function.