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

Re: PostgreSQL 8.4 performance tuning questions

From: Merlin Moncure <mmoncure(at)gmail(dot)com>
To: Rauan Maemirov <rauan(at)maemirov(dot)com>
Cc: tv(at)fuzzy(dot)cz, pgsql-performance(at)postgresql(dot)org
Subject: Re: PostgreSQL 8.4 performance tuning questions
Date: 2009-07-31 15:11:57
Message-ID: b42b73150907310811r56c17a1ei8b413a3b9acb7a7f@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-performance
On Thu, Jul 30, 2009 at 10:07 AM, Rauan Maemirov<rauan(at)maemirov(dot)com> wrote:
> Unfortunately had to downgrade back to 8.3. Now having troubles with
> that and still solving them.
>
> For future upgrade, what is the basic steps?
>
>>Was the database analyzed recently?
> Hm... there was smth like auto analyzer in serverlog when i started it
> first time, but i didn't mention that.
> Should I analyze whole db? How to do it?
>
> And how should I change _cost variables?
>
> I/O was very high. at first memory usage grew up and then began to full swap.

There is at least one known case of memory leak 8.4.0.  Possibly you
got hit by that or another early adopter bug.  I think in your case
it's probably to soon to have upgraded...with 10k connections even
minor annoyances can be real nasty.

I'd wait a few months while in the meantime stage your app on a
testing database and double check the important query plans to make
sure there are no big performance regressions.  Each version of pg has
a couple for various reasons.

merlin

In response to

pgsql-performance by date

Next:From: Tom LaneDate: 2009-07-31 17:04:52
Subject: Re: PostgreSQL 8.4 performance tuning questions
Previous:From: Jerry ChamplinDate: 2009-07-31 14:04:45
Subject: Re: load / stress testing

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