Re: [HACKERS] Error while copying a large file in pg_rewind

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: [HACKERS] Error while copying a large file in pg_rewind
Дата
Msg-id 11176.1499110071@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: [HACKERS] Error while copying a large file in pg_rewind  (Peter Eisentraut <peter.eisentraut@2ndquadrant.com>)
Ответы Re: [HACKERS] Error while copying a large file in pg_rewind  (Michael Paquier <michael.paquier@gmail.com>)
Список pgsql-hackers
Peter Eisentraut <peter.eisentraut@2ndquadrant.com> writes:
> On 7/3/17 09:53, Tom Lane wrote:
>> Hm.  Before we add a bunch of code to deal with that, are we sure we
>> *want* it to copy such files?  Seems like that's expending a lot of
>> data-transfer work for zero added value --- consider e.g. a server
>> with a bunch of old core files laying about in $PGDATA.  Given that
>> it's already excluded all database-data-containing files, maybe we
>> should just set a cap on the plausible size of auxiliary files.

> It seems kind of lame to fail on large files these days, even if they
> are not often useful in the particular case.

True.  But copying useless data is also lame.

> Also, most of the segment and file sizes are configurable, and we have
> had reports of people venturing into much larger file sizes.

But if I understand the context correctly, we're not transferring relation
data files this way anyway.  If we do transfer WAL files this way, we
could make sure to set the cutoff larger than the WAL segment size.
        regards, tom lane



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

Предыдущее
От: Peter Eisentraut
Дата:
Сообщение: Re: [HACKERS] Error while copying a large file in pg_rewind
Следующее
От: Tom Lane
Дата:
Сообщение: Re: [HACKERS] Revisiting NAMEDATALEN