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