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

Поиск
Список
Период
Сортировка
От Christophe Pettus
Тема Re: Getting "could not read block" error when creating an index on a function.
Дата
Msg-id C3727A25-70C1-4E9B-BD84-17AE5BA6B9C0@thebuild.com
обсуждение исходный текст
Ответ на Re: Getting "could not read block" error when creating an index on a function.  (Demitri Muna <postgresql@demitri.com>)
Ответы Re: Getting "could not read block" error when creating an index on a function.
Список pgsql-general
Дерево обсуждения 

> 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 по дате отправления:

Предыдущее
От: Karsten Hilbert
Дата:
Сообщение: Re: Getting "could not read block" error when creating an index on a function.
Следующее
От: Christophe Pettus
Дата:
Сообщение: Re: Getting "could not read block" error when creating an index on a function.