Received: from maia.hub.org (maia-3.hub.org [200.46.204.243]) by mail.postgresql.org (Postfix) with ESMTP id 6EBB36326A2 for ; Wed, 16 Jun 2010 16:34:54 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.243]) (amavisd-maia, port 10024) with ESMTP id 16430-10 for ; Wed, 16 Jun 2010 19:34:46 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from mail-gw0-f46.google.com (mail-gw0-f46.google.com [74.125.83.46]) by mail.postgresql.org (Postfix) with ESMTP id 6BE55632E20 for ; Wed, 16 Jun 2010 16:34:47 -0300 (ADT) Received: by gwj15 with SMTP id 15so4277771gwj.19 for ; Wed, 16 Jun 2010 12:34:46 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:mime-version:received:received:in-reply-to :references:date:message-id:subject:from:to:cc:content-type; bh=qqOPtV14OorzWgz9B926sxkmnohxdRXxQxqXSaSeHbw=; b=aIpb2ImCEqQmguBmVRpMGFYBhISv9jKO5N1Zb2JOrAN/bweC2/k1iuuwvQHZIU0r1S scySRdKb0K2WNJNyA0SxHdyFyp13bLu2KnpTC3Jibejx1+Lnr3h8TXnYdL62QNhtDIqv a2mcpckSWv27tDLLPmRYiprcK5AwXduBFDvYY= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=mime-version:in-reply-to:references:date:message-id:subject:from:to :cc:content-type; b=pt5Hdl/glpmgc1GvU4RHK3N1QY2e8pO0IW4hVbhSLLKgCPM9oJUmZFMYyskX+SLA2U w+pzj2MWUHlSCv8DmrfGVeBQh3jOCyADV27Y/sCztmVES+PbYi4ecRaKTkB3pMniVDu0 c1CDWS24t0Gn5B8gvxsnLDZGPJ9Y7mS7thTrE= MIME-Version: 1.0 Received: by 10.151.3.25 with SMTP id f25mr10281904ybi.183.1276716883717; Wed, 16 Jun 2010 12:34:43 -0700 (PDT) Received: by 10.151.13.3 with HTTP; Wed, 16 Jun 2010 12:34:43 -0700 (PDT) In-Reply-To: <20100616191255.BEF916349F0@mail.postgresql.org> References: <20100616191255.BEF916349F0@mail.postgresql.org> Date: Wed, 16 Jun 2010 13:34:43 -0600 Message-ID: Subject: Re: Confirm calculus From: Scott Marlowe To: juapabsan@tutopia.com Cc: pgsql-performance@postgresql.org Content-Type: text/plain; charset=ISO-8859-1 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/294 X-Sequence-Number: 39150 On Wed, Jun 16, 2010 at 7:46 AM, Juan Pablo Sandoval Rivera wrote: > Good morning List > > In relation to the process of tuning the engine PostgreSQL database, especially > 7.3.7 version that is being used currently, agreaceria me clarify a procedure I concur with the other poster on keeping shared_mem lower on this older version. Also, you should be running at the very least the latest version of 7.3, which is 7.3.21 and available here: ftp://ftp-archives.postgresql.org/pub/source/ Tuning 7.3 is more an effort in futility at this point, considering that a non-tuned 8.3 or 8.4 install will still be much much faster. If the lack of auto-casts in 8.3 impacts you negatively then at least look at 8.2.latest.