Re: Quick-and-dirty compression for WAL backup blocks

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Quick-and-dirty compression for WAL backup blocks
Дата
Msg-id 8971.1118077782@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Quick-and-dirty compression for WAL backup blocks  (Heikki Linnakangas <hlinnaka@iki.fi>)
Ответы Re: Quick-and-dirty compression for WAL backup blocks  (Junji TERAMOTO <teramoto.junji@lab.ntt.co.jp>)
Список pgsql-hackers
Heikki Linnakangas <hlinnaka@iki.fi> writes:
> On Mon, 6 Jun 2005, Tom Lane wrote:
>> Heikki Linnakangas <hlinnaka@iki.fi> writes:
>>> Vacuum doesn't zero out the free space between lower and upper,
>> 
>> It does now ;-)

> Oh :). Does it affect vacuum performance?

I haven't tried to measure it ... but certainly it's not totally free.
I'd be happy to rip that change out again.

>> Would this be institutionalizing a particular approach to data
>> compression in the XLogInsert API, though?

> The "skip the free space" optimization is still useful and worthwhile 
> even if we have a more sophisticated compression method for the 
> rest of the page.

Good point.  OK, I'm hacking XLOG stuff now anyway so I'll see about
making that happen.
        regards, tom lane


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

Предыдущее
От: Heikki Linnakangas
Дата:
Сообщение: Re: Quick-and-dirty compression for WAL backup blocks
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: [PATCHES] regexp_replace