Perhaps useful to also send this question to a postgres forum? On Jul 13, 2017 9:55 PM, "Edward Robinson" <erobin...@projectbalance.com> wrote:
> I’ve setup a new Ubuntu 16.04 box with PostgreSQL 9.5.5 and I’m restoring > a fairly large DHIS2 backup but having speed issues. It’s a full pg_dump > in custom format and about 650Gb compressed (a plain text dump produces a > 7Gb file). I made sure inserts were turned off, so that’s not the issue, > but so far it’s been running for 33 hours – CPU at 100% - with no end in > sight. This is a backup file that took 30 minutes to generate. > > > > If it is running synchronously, I calculated that it’s on around 20 > million DB rows of around 170 million after 33 hours! Surely that’s not > normal. > > I’ve tweaked PostgreSQL with the following settings: > > > > maintenance_work_mem=2GB > > max_wal_size = 1Gb > > checkpoint_timeout = 3600 > > checkpoint_completion_target = 0.9 > > > > Anyway, if anyone has insight or has had a similar experience, or > suggestions, please let me know! > > I’m testing it on another (Windows) instance to see if there’s something > amiss. > > > > Cheers, > > Ed > > _______________________________________________ > Mailing list: https://launchpad.net/~dhis2-users > Post to : dhis2-users@lists.launchpad.net > Unsubscribe : https://launchpad.net/~dhis2-users > More help : https://help.launchpad.net/ListHelp > >
_______________________________________________ Mailing list: https://launchpad.net/~dhis2-users Post to : dhis2-users@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp
