Received: from makus.postgresql.org (makus.postgresql.org [98.129.198.125]) by mail.postgresql.org (Postfix) with ESMTP id E85C8BB5DD3 for ; Tue, 1 May 2012 14:00:23 -0300 (ADT) Received: from plane.gmane.org ([80.91.229.3]) by makus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1SPGR4-0000QH-9O for pgsql-performance@postgresql.org; Tue, 01 May 2012 17:00:23 +0000 Received: from list by plane.gmane.org with local (Exim 4.69) (envelope-from ) id 1SPGQp-0006su-Ox for pgsql-performance@postgresql.org; Tue, 01 May 2012 19:00:07 +0200 Received: from host-188-174-171-159.customer.m-online.net ([188.174.171.159]) by main.gmane.org with esmtp (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Tue, 01 May 2012 19:00:07 +0200 Received: from spam_eater by host-188-174-171-159.customer.m-online.net with local (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Tue, 01 May 2012 19:00:07 +0200 X-Injected-Via-Gmane: http://gmane.org/ To: pgsql-performance@postgresql.org From: Thomas Kellerer Subject: Re: Tuning Postgres 9.1 on Windows Date: Tue, 01 May 2012 19:00:02 +0200 Lines: 12 Message-ID: References: <21BFB59709EBB84DB412ED7F739FFD3B19E5E3@TBPINFN0203.cad.local> <21BFB59709EBB84DB412ED7F739FFD3B1AC2C2@TBPINFN0203.cad.local> <21BFB59709EBB84DB412ED7F739FFD3B1AC325@TBPINFN0203.cad.local> <21BFB59709EBB84DB412ED7F739FFD3B1AC403@TBPINFN0203.cad.local> Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Complaints-To: usenet@dough.gmane.org X-Gmane-NNTP-Posting-Host: host-188-174-171-159.customer.m-online.net User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; de; rv:1.8.1.21) Gecko/20090302 Thunderbird/2.0.0.21 Mnenhy/0.7.5.666 In-Reply-To: <21BFB59709EBB84DB412ED7F739FFD3B1AC403@TBPINFN0203.cad.local> X-Pg-Spam-Score: -1.9 (-) X-Archive-Number: 201205/11 X-Sequence-Number: 46835 Walker, James Les wrote on 01.05.2012 16:44: > I installed the enterprisedb distribution and immediately saw a 400% performance increase. What exactly is "the enterprisedb distribution"? Are you talking about the the Advanced Server? I would be very surprised if the code base would differ so much to allow such a performance gain. Could it be that the default settings for the Advanced Server are different than those of the "community edition"? And what did you have installed before that? (as the Windows binary are always distributed by EnterpriseDB) Thomas