Re: Checking for missing heap/index files

Поиск
Список
Период
Сортировка
От Bruce Momjian
Тема Re: Checking for missing heap/index files
Дата
Msg-id YqfFEfxrTCMgQE+l@momjian.us
обсуждение исходный текст
Ответ на Re: Checking for missing heap/index files  (Robert Haas <robertmhaas@gmail.com>)
Ответы Re: Checking for missing heap/index files  (Peter Geoghegan <pg@bowt.ie>)
Список pgsql-hackers
On Mon, Jun 13, 2022 at 04:06:12PM -0400, Robert Haas wrote:
> One idea might be for each heap table to have a metapage and store the
> length - or an upper bound on the length - in the metapage. That'd
> probably be cheaper than updating pg_class, but might still be
> expensive in some scenarios, and it's a fairly large amount of
> engineering.

I agree --- it would be nice, but might be hard to justify the
engineering and overhead involved.  I guess I was just checking that I
wasn't missing something obvious.

-- 
  Bruce Momjian  <bruce@momjian.us>        https://momjian.us
  EDB                                      https://enterprisedb.com

  Indecision is a decision.  Inaction is an action.  Mark Batterson




В списке pgsql-hackers по дате отправления:

Предыдущее
От: Peter Geoghegan
Дата:
Сообщение: Re: better page-level checksums
Следующее
От: Peter Geoghegan
Дата:
Сообщение: Re: Checking for missing heap/index files