Search Postgresql Archives

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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Subject: Re: Getting "could not read block" error when creating an index on a function.
From: Karsten Hilbert <Karsten.Hilbert@xxxxxxx>
Date: Wed, 30 Dec 2020 20:45:50 +0100
Di_x_sposition-notification-to: Karsten.Hilbert@xxxxxxx
In-reply-to: <B76CAF59-EC22-4907-8AD7-A4261C4DA5CA@demitri.com>
Ma_x_il-followup-to: d
Re_x_turn-receipt-to: Karsten.Hilbert@xxxxxxx
References: <E88B1929-C94D-45C1-B11F-0B48B39D64B7@demitri.com> <2344514.1609347027@sss.pgh.pa.us> <B76CAF59-EC22-4907-8AD7-A4261C4DA5CA@demitri.com>

Am Wed, Dec 30, 2020 at 02:37:59PM -0500 schrieb Demitri Muna:

> 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?

A materialized view ?

Karsten
--
GPG  40BE 5B0E C98E 1713 AFA6  5BC0 3BEA AC80 7D4F C89B

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Follow-Ups:
- Re: Getting "could not read block" error when creating an index on a function.
  - From: Tom Lane

References:
- Getting "could not read block" error when creating an index on a function.
  - From: Demitri Muna
- Re: Getting "could not read block" error when creating an index on a function.
  - From: Tom Lane
- Re: Getting "could not read block" error when creating an index on a function.
  - From: Demitri Muna

Prev by Date: Re: Getting "could not read block" error when creating an index on a function.
Next by Date: Re: Getting "could not read block" error when creating an index on a function.
Previous by thread: Re: Getting "could not read block" error when creating an index on a function.
Next by thread: Re: Getting "could not read block" error when creating an index on a function.
Index(es):
- Date
- Thread

[Index of Archives] [Postgresql Jobs] [Postgresql Admin] [Postgresql Performance] [Linux Clusters] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Books] [PHP Databases] [Postgresql & PHP] [Yosemite]