Re: Allowing multiple concurrent base backups

Поиск
Список
Период
Сортировка
От Ross J. Reedstrom
Тема Re: Allowing multiple concurrent base backups
Дата
Msg-id 20110113191907.GB2147@rice.edu
обсуждение исходный текст
Ответ на Re: Allowing multiple concurrent base backups  (Josh Berkus <josh@agliodbs.com>)
Ответы Re: Allowing multiple concurrent base backups  (Robert Haas <robertmhaas@gmail.com>)
Список pgsql-hackers
On Tue, Jan 11, 2011 at 11:06:18AM -0800, Josh Berkus wrote:
> 
> > It makes it very convenient to set up standbys, without having to worry
> > that you'll conflict e.g with a nightly backup. I don't imagine people
> > will use streaming base backups for very large databases anyway.
> 
> Also, imagine that you're provisioning a 10-node replication cluster on
> EC2.  This would make that worlds easier.

Hmm, perhaps. My concern is that a naive attempt to do that is going to
have 10 base-backups happening at the same time, completely slamming the
master, and none of them completing is a reasonable time. Is this
possible, or is it that simultaneity will buy you hot caches and backup
#2 -> #10 all run faster?

Ross
-- 
Ross Reedstrom, Ph.D.                                 reedstrm@rice.edu
Systems Engineer & Admin, Research Scientist        phone: 713-348-6166
Connexions                  http://cnx.org            fax: 713-348-3665
Rice University MS-375, Houston, TX 77005
GPG Key fingerprint = F023 82C8 9B0E 2CC6 0D8E  F888 D3AE 810E 88F0 BEDE



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

Предыдущее
От: Robert Haas
Дата:
Сообщение: Re: kill -KILL: What happens?
Следующее
От: Tom Lane
Дата:
Сообщение: Re: kill -KILL: What happens?