Re: Possible to go without page headers?

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Possible to go without page headers?
Дата
Msg-id 2953079.1644877175@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Possible to go without page headers?  (Chris Cleveland <ccleve+github@dieselpoint.com>)
Ответы Re: Possible to go without page headers?  (David Steele <david@pgmasters.net>)
Re: Possible to go without page headers?  (Peter Geoghegan <pg@bowt.ie>)
Список pgsql-hackers
Chris Cleveland <ccleve+github@dieselpoint.com> writes:
> Can I treat pages as just a flat, open 8k buffer and fill them with
> arbitrary data?

No, at least not unless you plan to reimplement much of the WAL
mechanism.  You do need at least an LSN in the right place.
I kinda doubt that you can get away with ignoring checksumming,
either.  On the whole, I think you'd be best off to use a standard
page header; the amount you're saving by avoiding that will be
minuscule, and the amount of work you cause for yourself probably
not so much.

BTW, there are also tools such as pg_filedump that expect that index
pages can be identified by some sort of magic number kept in the
"special space" at the page tail.  You're not absolutely bound to make
that work, but you'll be cutting yourself off from some potentially
handy support.

            regards, tom lane



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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Better error message for unsupported replication cases
Следующее
От: David Steele
Дата:
Сообщение: Re: Possible to go without page headers?