Re: Improving compressibility of WAL files

Поиск
Список
Период
Сортировка
Искать
От
Richard Huxton
Тема
Re: Improving compressibility of WAL files
Дата
Msg-id
49678715.9020602@archonet.com
Ответ на
Список
Дерево обсуждения
Re: Improving compressibility of WAL files Hannu Krosing <hannu@krosing.net>
Re: Improving compressibility of WAL files Hannu Krosing <hannu@2ndQuadrant.com>
Re: Improving compressibility of WAL files Greg Smith <gsmith@gregsmith.com>
Re: Improving compressibility of WAL files "Kevin Grittner" <Kevin.Grittner@wicourts.gov>
Re: Improving compressibility of WAL files Aidan Van Dyk <aidan@highrise.ca>
Re: Improving compressibility of WAL files "Kevin Grittner" <Kevin.Grittner@wicourts.gov>
Re: Improving compressibility of WAL files Greg Smith <gsmith@gregsmith.com>
Re: Improving compressibility of WAL files Aidan Van Dyk <aidan@highrise.ca>
Re: Improving compressibility of WAL files Tom Lane <tgl@sss.pgh.pa.us>
Re: Improving compressibility of WAL files Bruce Momjian <bruce@momjian.us>
Re: Improving compressibility of WAL files Richard Huxton <dev@archonet.com>
Re: Improving compressibility of WAL files Aidan Van Dyk <aidan@highrise.ca>
Re: Improving compressibility of WAL files Richard Huxton <dev@archonet.com>
Re: Improving compressibility of WAL files Zeugswetter Andreas OSB sIT <Andreas.Zeugswetter@s-itsolutions.at>
Tom Lane wrote:
> "Kevin Grittner"  writes:
>> Greg Smith  wrote: 
>>> I thought at one point that the direction this was going toward was to 
>>> provide the size of the WAL file as a parameter you can use in the 
>>> archive_command:
>  
>> Hard to beat for performance.  I thought there was some technical
>> snag.
>  
> Yeah: the archiver process doesn't have that information available.

Am I being really dim here - why isn't the first record in the WAL file
a fixed-length record containing e.g. txid_start, time_start, txid_end,
time_end, length? Write it once when you start using the file and once
when it's finished.

--  Richard Huxton Archonet Ltd

В списке pgsql-hackers по дате отправления
От: Andrew Dunstan
Дата:
От: Aidan Van Dyk
Дата:
FAQ