Re: [PATCHES] Incrementally Updated Backup - Mailing list pgsql-hackers

From Csaba Nagy
Subject Re: [PATCHES] Incrementally Updated Backup
Date
Msg-id 1158829670.25023.264.camel@coppola.muc.ecircle.de
Whole thread Raw
In response to Re: [PATCHES] Incrementally Updated Backup  ("Jim C. Nasby" <jim@nasby.net>)
List pgsql-hackers
> True, but running several dozen instances on a single machine will
> require a lot more memory (or, conversely, each individual database gets
> a lot less memory to use).
>
> Of course, this is all hand-waving right now... it'd be interesting to
> see which approach was actually better.

I'm running 4 WAL logging standby clusters on a single machine. While
the load on the master servers occasionally goes up to >60, the load on
the standby machine have never climbed above 5.

Of course when the master servers are all loaded, the standby gets
behind with the recovery... but eventually it gets up to date again.

I would be very surprised if it would get less behind if I would use it
in the 1 by 1 scenario.

Cheers,
Csaba.



pgsql-hackers by date:

Previous
From: Simon Riggs
Date:
Subject: Re: Release Notes: Major Changes in 8.2
Next
From: Heikki Linnakangas
Date:
Subject: Re: Phantom Command ID