Re: [FEATURE REQUEST] Streaming Onlinebackup (Maybe OFFTOPIC)

Поиск
Список
Период
Сортировка
От Simon Riggs
Тема Re: [FEATURE REQUEST] Streaming Onlinebackup (Maybe OFFTOPIC)
Дата
Msg-id 1190894211.4194.64.camel@ebony.site
обсуждение исходный текст
Ответ на Re: [FEATURE REQUEST] Streaming Onlinebackup (Maybe OFFTOPIC)  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
Ответы Re: [FEATURE REQUEST] Streaming Onlinebackup (Maybe OFFTOPIC)  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
Re: [FEATURE REQUEST] Streaming Onlinebackup (Maybe OFFTOPIC)  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
Список pgsql-hackers
On Wed, 2007-09-26 at 16:31 -0500, Kevin Grittner wrote:

> The one downside I've found is that it adds 0.2
> seconds of CPU time per WAL file archive during our heaviest update
> periods.  It's in the archiver process, not a backend process that's
> running a query, and we're not generally CPU bound, so this is not a
> problem for us. 

OK, first time anybody's measured a significant cost to process creation
during execution of the archive_command. Still fairly low though.

Increasing the size of the WAL files would cure that. :-(

--  Simon Riggs 2ndQuadrant  http://www.2ndQuadrant.com



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

Предыдущее
От: Simon Riggs
Дата:
Сообщение: Re: [FEATURE REQUEST] Streaming Onlinebackup (MaybeOFFTOPIC)
Следующее
От: "Brendan Jurd"
Дата:
Сообщение: Re: Text <-> C string