Received: from maia.hub.org (maia-5.hub.org [200.46.204.29]) by mail.postgresql.org (Postfix) with ESMTP id 646C0632A04 for ; Thu, 24 Jun 2010 22:15:19 -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 02877-06 for ; Fri, 25 Jun 2010 01:15:12 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from moutng.kundenserver.de (moutng.kundenserver.de [212.227.17.10]) by mail.postgresql.org (Postfix) with ESMTP id D273563330B for ; Thu, 24 Jun 2010 22:15:11 -0300 (ADT) Received: from [69.97.198.58] (58.sub-69-97-198.myvzw.com [69.97.198.58]) by mrelayeu.kundenserver.de (node=mreu2) with ESMTP (Nemesis) id 0MDCvo-1OOiv32Ds4-00HIyL; Fri, 25 Jun 2010 03:15:10 +0200 Message-ID: <4C24031B.7080701@2ndquadrant.com> Date: Thu, 24 Jun 2010 21:15:07 -0400 From: Greg Smith User-Agent: Thunderbird 2.0.0.24 (X11/20100317) MIME-Version: 1.0 To: Cliff Pratt CC: pgsql-admin@postgresql.org Subject: Re: Tuning knobs References: In-Reply-To: Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Provags-ID: V01U2FsdGVkX19FlmxqTtUwOTsFCEgL5Ik6CIPhHu/ktWur4Hz P34C39oRPdM39fUtGWviL2J75szcBWZDGPZoVEbBUz/j7q3Cmm 8vDwpIAUxLe5FG4QoES1r49CjQTZld5 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.8 tagged_above=-10 required=5 tests=BAYES_50=0.8, RCVD_IN_DNSWL_NONE=-0.0001 X-Spam-Level: X-Archive-Number: 201006/200 X-Sequence-Number: 34978 Cliff Pratt wrote: > What are the main 'knobs' that can be used to tune PostgreSQL? http://wiki.postgresql.org/wiki/Tuning_Your_PostgreSQL_Server -- Greg Smith 2ndQuadrant US Baltimore, MD PostgreSQL Training, Services and Support greg@2ndQuadrant.com www.2ndQuadrant.us