Re: Core team statement on replication in PostgreSQL

Поиск
Список
Период
Сортировка
От Andrew Dunstan
Тема Re: Core team statement on replication in PostgreSQL
Дата
Msg-id 48406C35.9050409@dunslane.net
обсуждение исходный текст
Ответ на Re: Core team statement on replication in PostgreSQL  (Andreas 'ads' Scherbaum <adsmail@wars-nicht.de>)
Ответы Re: Core team statement on replication in PostgreSQL  (Tatsuo Ishii <ishii@postgresql.org>)
Re: Core team statement on replication in PostgreSQL  (Josh Berkus <josh@agliodbs.com>)
Re: Core team statement on replication in PostgreSQL  (Andreas 'ads' Scherbaum <adsmail@wars-nicht.de>)
Список pgsql-hackers

Andreas 'ads' Scherbaum wrote:
> On Thu, 29 May 2008 23:02:56 -0400 Andrew Dunstan wrote:
>
>   
>> Well, yes, but you do know about archive_timeout, right? No need to wait 
>> 2 hours.
>>     
>
> Then you ship 16 MB binary stuff every 30 second or every minute but
> you only have some kbyte real data in the logfile. This must be taken
> into account, especially if you ship the logfile over the internet
> (means: no high-speed connection, maybe even pay-per-traffic) to the
> slave.
>
>
>
>   

Sure there's a price to pay. But that doesn't mean the facility doesn't 
exist. And I rather suspect that most of Josh's customers aren't too 
concerned about traffic charges or affected by such bandwidth 
restrictions. Certainly, none of my clients are, and they aren't in the 
giant class. Shipping a 16Mb file, particularly if compressed, every 
minute or so, is not such a huge problem for a great many commercial 
users, and even many domestic users.

cheers

andrew


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

Предыдущее
От: Robert Treat
Дата:
Сообщение: Re: Core team statement on replication in PostgreSQL
Следующее
От: Zdenek Kotala
Дата:
Сообщение: move hash_any from hash to utils