Re: Fastest pq_restore?

On 3/18/2011 9:38 AM, Kevin Grittner wrote:
> Andy Colson<andy@squeakycode.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:

http://rhaas.blogspot.com/2010/06/postgresql-as-in-memory-only-database_24.html

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

-Andy