Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id B3EDE6501C1 for ; Fri, 17 Oct 2008 13:47:53 -0300 (ADT) Received: from postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 17178-09 for ; Fri, 17 Oct 2008 13:47:51 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from wa-out-1112.google.com (wa-out-1112.google.com [209.85.146.176]) by postgresql.org (Postfix) with ESMTP id 8B14064FC71 for ; Fri, 17 Oct 2008 13:47:50 -0300 (ADT) Received: by wa-out-1112.google.com with SMTP id j4so375825wah.19 for ; Fri, 17 Oct 2008 09:47:49 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from:to :subject:cc:in-reply-to:mime-version:content-type :content-transfer-encoding:content-disposition:references; bh=nPQ80VDUmR+jNuoldZIqR+mwnGts+YMHOdDabrNCZYE=; b=FCLTnYa5d1L5BI5KZcqA0Ro9LhHPEAuVfO6IKhEzfTSITrkKyRZVZCxL61BwiNHEdM kXTmQcFAUsZ4iEDLiers51HHH0sN1+hkSb2SuOfxKxBDdtVa1UGzdW+4EzkRLsAVTavD +SYk+RRRVO3YMTd+w1Io830KcVK3Df5+dg8+c= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:to:subject:cc:in-reply-to:mime-version :content-type:content-transfer-encoding:content-disposition :references; b=bQ3aJmL8jzz/mBXRZQxiQtoEBzl05DjPF361SMKJ4kSWMVFX8kzENq24qBi7UlHLXj VbPe6bMGw2hG7kGcfT5b4xZd7fRJi60hE0V81/bkkt5mHVOB6NlLxT1/EFcGSQ3P5OgL t+dm1yA7qmevE8jz5VqVJqScaOjNAoS8waXAI= Received: by 10.114.53.1 with SMTP id b1mr3565343waa.53.1224262069365; Fri, 17 Oct 2008 09:47:49 -0700 (PDT) Received: by 10.114.127.18 with HTTP; Fri, 17 Oct 2008 09:47:49 -0700 (PDT) Message-ID: <8a547c840810170947p52075b0cmadc8c2060b38cfa4@mail.gmail.com> Date: Fri, 17 Oct 2008 09:47:49 -0700 From: "Tory M Blue" To: "Kevin Grittner" Subject: Re: Index bloat, reindex weekly, suggestions etc? Cc: pgsql-performance@postgresql.org In-Reply-To: <48F8773F.EE98.0025.0@wicourts.gov> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <8a547c840810170905m7323dbd8x90de7dd004abc7d4@mail.gmail.com> <48F8773F.EE98.0025.0@wicourts.gov> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none X-Spam-Level: X-Archive-Number: 200810/92 X-Sequence-Number: 31673 On Fri, Oct 17, 2008 at 9:30 AM, Kevin Grittner wrote: >>>> "Tory M Blue" wrote: > >> tell me if i should plan upgrades to 8.3.4.. > > It's a good idea. It should be painless -- drop in and restart. > > Make sure that effective_cache_size reflects this. > Thanks Kevin DETAIL: A total of 501440 page slots are in use (including overhead). 501440 page slots are required to track all free space. Current limits are: 1087500 page slots, 430 relations, using 6401 kB. VACUUM that looks fine And effective_cache, ya I didn't change that as I wanted to see how the results were with just adding memory and in all honesty it was night and day without changing that param, what will modifying that param accomplish? effective_cache_size = 7GB (so no not changed and our performance is 50x better with just the memory upgrade) BTW running Linux.. shared_buffers = 600MB (have 300 connections specified) Thanks Tory