Skip site navigation (1) Skip section navigation (2)

Re: 7 hrs for a pg_restore?

From: Vivek Khera <vivek(at)khera(dot)org>
To: pgsql-performance Performance <pgsql-performance(at)postgresql(dot)org>
Subject: Re: 7 hrs for a pg_restore?
Date: 2008-02-21 19:17:40
Message-ID: 85ECB757-C29E-4736-8A78-41C498B06251@khera.org (view raw or flat)
Thread:
Lists: pgsql-performance
On Feb 21, 2008, at 12:28 PM, Guillaume Cottenceau wrote:

> I have made a comparison restoring a production dump with default
> and large maintenance_work_mem. The speedup improvement here is
> only of 5% (12'30 => 11'50).

At one point I was evaluating several server vendors and did a bunch  
of DB restores.  The one thing that gave me the biggest benefit was to  
bump the number of checkpoint segments to a high number, like 128 or  
256.  Everything else was mostly minor increases in speed.



In response to

pgsql-performance by date

Next:From: Adonias MalossoDate: 2008-02-21 20:48:18
Subject: 4s query want to run faster
Previous:From: Tom LaneDate: 2008-02-21 18:09:32
Subject: Re: 7 hrs for a pg_restore?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group