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

Re: Fastest pq_restore?

From: Andy Colson <andy(at)squeakycode(dot)net>
To: Kevin Grittner <Kevin(dot)Grittner(at)wicourts(dot)gov>
Cc: Michael Andreasen <michael(at)dunlops(dot)com>, pgsql-performance(at)postgresql(dot)org
Subject: Re: Fastest pq_restore?
Date: 2011-03-18 19:10:05
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-performance
On 3/18/2011 9:38 AM, Kevin Grittner wrote:
> Andy Colson<andy(at)squeakycode(dot)net>  wrote:
>> On 03/17/2011 09:25 AM, Michael Andreasen wrote:
>>> I've been looking around for information on doing a pg_restore as
>>> fast as possible.
>> bgwriter_lru_maxpages = 0
> I hadn't thought much about that last one -- do you have benchmarks
> to confirm that it helped with a bulk load?

Nope, I got it from the "running with scissors" thread (I think), (maybe 
from Greg Smith)

or here:

I dont recall exactly.  I saw it, add added a comment to my .conf just 
incase I ever needed it.


In response to

pgsql-performance by date

Next:From: Kevin GrittnerDate: 2011-03-18 19:21:16
Subject: Re: Help: massive parallel update to the same table
Previous:From: Red MapleDate: 2011-03-18 18:21:09
Subject: Re: Help: massive parallel update to the same table

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