Re: Performance Tuning - Any easy things that I can do ?

On 4 February 2010 15:54, Wang, Mary Y <mary.y.wang@boeing.com> wrote:
> Hi,
>
> I restored my database.  However, I noticed performance is poor as compared to before.
> Are there some easy things that I can do to improve the performance (besides rewriting the code)?
>
> My pgversion is 7.1.3 (I know, I know that I need to upgrade).
>

Need to upgrade?  That's a bit of an understatement.  If you're able
to do so, I'd strongly recommend it as PostgreSQL has dramatically
improved in every area since then.

I think you'll need a PostgreSQL veteran to help you out there.  All I
can think of is you take a look at the earliest available
documentation (7.2 from what I can tell) and try looking into those
settings: http://www.postgresql.org/docs/7.2/static/runtime-config.html

Regards

Thom