Re: TOAST performance (was Re: [GENERAL] Delete Performance)

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: TOAST performance (was Re: [GENERAL] Delete Performance)
Дата
Msg-id 27152.1006393246@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: TOAST performance (was Re: [GENERAL] Delete Performance)  (Bruce Momjian <pgman@candle.pha.pa.us>)
Список pgsql-hackers
Bruce Momjian <pgman@candle.pha.pa.us> writes:
> I was thinking of just throwing the inactive page number into WAL.  Much
> smaller than the entire page image.  You don't touch the page.  Does
> that help?

I don't think so.  Somehow you have to tell the other backends that that
page is dead; merely recording it in WAL doesn't do that.

More to the point, you can't recycle (overwrite) that page until you've
checkpointed or WAL-logged the replacement page; so you still end up
with disk I/O for the replacement.
        regards, tom lane


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

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: Quick question
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Mention NLS option in INSTALL