Re: Some ideas about Vacuum

Alvaro Herrera wrote:
> Heikki Linnakangas escribió:
>> For more usefulness, we'd need to keep databases more separate from each 
>> other than we do now. Databases would need to have their own transaction 
>> counters, for example.
> 
> Hmm, why?  Perhaps you are right but I don't see the reason.

If each database was stand-alone, you would need only one base backup 
and WAL per database to restore, instead of base backup and WAL of the 
database, and base backup and WAL of shared stuff. You could backup one 
database in cluster, restore it somewhere else, and later copy it back 
to the original cluster. You could back up one database at a time, and 
restore the whole cluster from the N per-database backups.

--   Heikki Linnakangas  EnterpriseDB   http://www.enterprisedb.com