On 3/18/2011 9:38 AM, Kevin Grittner wrote:
Andy Colson<andy@xxxxxxxxxxxxxxx> 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
--
Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
