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 (Tom Lane)
Список
Дерево обсуждения
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 по дате отправления