On Fri, Sep 25, 2015 at 10:43 PM, rlemaroi <remi.le-mar...@capgemini.com> wrote: > Please how long does it take approximately to restore a 300 Go database using > pg_restore ? Are there benchmarks for that ?
That's not an exact science and this is really application-dependent. For example the more your schema has index entries to rebuild at restore the longer it would take. There are as well ways to tune the server to perform a faster restore, by for example increasing maintenance_work_mem, disabling autovacuum, moving wal_level to minimum, etc. -- Michael -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
