Re: [FEATURE REQUEST] Streaming Onlinebackup (MaybeOFFTOPIC)

Поиск
Список
Период
Сортировка
От Kevin Grittner
Тема Re: [FEATURE REQUEST] Streaming Onlinebackup (MaybeOFFTOPIC)
Дата
Msg-id 46FB741E.EE98.0025.0@wicourts.gov
обсуждение исходный текст
Ответ на Re: [FEATURE REQUEST] Streaming Onlinebackup (MaybeOFFTOPIC)  ("Zeugswetter Andreas ADI SD" <Andreas.Zeugswetter@s-itsolutions.at>)
Ответы Re: [FEATURE REQUEST] Streaming Onlinebackup (MaybeOFFTOPIC)  ("Zeugswetter Andreas ADI SD" <Andreas.Zeugswetter@s-itsolutions.at>)
Список pgsql-hackers
>>> On Thu, Sep 27, 2007 at  3:17 AM, in message
<E1539E0ED7043848906A8FF995BDA57902685E09@m0143.s-mxs.net>, "Zeugswetter
Andreas ADI SD" <Andreas.Zeugswetter@s-itsolutions.at> wrote:
>
> The probably useful next step would be to pass the current length to the
> archive_command,
> so it can write the filled part of the file without the need for a
> filter.
I can see that helping a lot, but not by writing onto the file on disk.
If the file is nearly empty, that would be a lot of disk I/O which doesn't
need to happen.  One place it could help is allowing the archive script to
skip the filter if the file is full.  On files with unused space, we could
skip the rest of the input and just blast out zeros to the desired file
length.
-Kevin




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

Предыдущее
От: NikhilS
Дата:
Сообщение: Assertion failure due to ColumnRefStar
Следующее
От: "Kevin Grittner"
Дата:
Сообщение: Re: [FEATURE REQUEST] Streaming Onlinebackup (Maybe OFFTOPIC)