Skip site navigation (1) Skip section navigation (2)

Re: Index bloat, reindex weekly, suggestions etc?

From: "Tory M Blue" <tmblue(at)gmail(dot)com>
To: "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Index bloat, reindex weekly, suggestions etc?
Date: 2008-10-17 16:47:49
Message-ID: 8a547c840810170947p52075b0cmadc8c2060b38cfa4@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-performance
On Fri, Oct 17, 2008 at 9:30 AM, Kevin Grittner
<Kevin(dot)Grittner(at)wicourts(dot)gov> wrote:
>>>> "Tory M Blue" <tmblue(at)gmail(dot)com> 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

In response to

Responses

pgsql-performance by date

Next:From: Scott MarloweDate: 2008-10-17 17:02:35
Subject: Re: Index bloat, reindex weekly, suggestions etc?
Previous:From: Kevin GrittnerDate: 2008-10-17 16:30:07
Subject: Re: Index bloat, reindex weekly, suggestions etc?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group