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)
|
| Список | 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 по дате отправления: