Received: from maia.hub.org (maia-5.hub.org [200.46.204.29]) by mail.postgresql.org (Postfix) with ESMTP id BE6EC1337B81 for ; Fri, 18 Mar 2011 16:10:00 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.29]) (amavisd-maia, port 10024) with ESMTP id 07993-10 for ; Fri, 18 Mar 2011 19:09:50 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from marajade.localdomain (vcs5.camavision.com [63.228.164.252]) by mail.postgresql.org (Postfix) with ESMTP id 0FF351337999 for ; Fri, 18 Mar 2011 16:09:49 -0300 (ADT) Received: from [192.168.10.84] (unknown [192.168.10.84]) (Authenticated sender: andy) by marajade.localdomain (Postfix) with ESMTPA id C7586407E6; Fri, 18 Mar 2011 14:09:48 -0500 (CDT) Message-ID: <4D83AE0D.1020607@squeakycode.net> Date: Fri, 18 Mar 2011 14:10:05 -0500 From: Andy Colson User-Agent: Mozilla/5.0 (Windows; U; Windows NT 6.1; en-US; rv:1.9.2.15) Gecko/20110303 Lightning/1.0b2 Thunderbird/3.1.9 MIME-Version: 1.0 To: Kevin Grittner CC: Michael Andreasen , pgsql-performance@postgresql.org Subject: Re: Fastest pq_restore? References: <4D82B075.7070202@squeakycode.net> <4D8327FD020000250003BA92@gw.wicourts.gov> In-Reply-To: <4D8327FD020000250003BA92@gw.wicourts.gov> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.9 tagged_above=-10 required=5 tests=BAYES_00=-1.9 X-Spam-Level: X-Archive-Number: 201103/225 X-Sequence-Number: 42904 On 3/18/2011 9:38 AM, Kevin Grittner wrote: > Andy Colson 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