Re: a back up question

On 12/5/2017 2:09 PM, Martin Mueller wrote:
> Time is not really a problem for me, if we talk about hours rather 
> than days.  On a roughly comparable machine I’ve made backups of 
> databases less than 10 GB, and it was a matter of minutes.  But I know 
> that there are scale problems. Sometimes programs just hang if the 
> data are beyond some size.  Is that likely in Postgres if you go from 
> ~ 10 GB to ~100 GB?  There isn’t any interdependence among my tables 
> beyond  queries I construct on the fly, because I use the database in 
> a single user environment

another factor is restore time.    restores have to create indexes.   
creating indexes on multi-million-row tables can take awhile.  (hint, be 
sure to set maintenance_work_mem to 1GB before doing this!)



-- 
john r pierce, recycling bits in santa cruz