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 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Scott Marlowe | 2008-10-17 17:02:35 | Re: Index bloat, reindex weekly, suggestions etc? |
Previous Message | Kevin Grittner | 2008-10-17 16:30:07 | Re: Index bloat, reindex weekly, suggestions etc? |