Postgres Pro
Downloads
Home   >   mailing lists

Re: Performance Tuning - Any easy things that I can do ? - Mailing list pgsql-general

From Scott Marlowe
Subject Re: Performance Tuning - Any easy things that I can do ?
Date
Msg-id dcc563d11002041032p36806917h4fff21a8353b081e@mail.gmail.com
Whole thread Raw
In response to Performance Tuning - Any easy things that I can do ?  ("Wang, Mary Y" <mary.y.wang@boeing.com>)
Responses Re: Performance Tuning - Any easy things that I can do ?  (Joe Conway <mail@joeconway.com>)
Re: Performance Tuning - Any easy things that I can do ?  ("Gauthier, Dave" <dave.gauthier@intel.com>)
List pgsql-general
Tree view 
On Thu, Feb 4, 2010 at 8:54 AM, 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).

Yeah, I ran pg as far back as 6.5 or so, but I can't remember enough
to really hope to help.  I'm guessing that upgrading will be less
painful than trying to performance tune such an old release.

Tuning 7.1 is kinda like performance tuning a 1916 Apperson Jackrabbit...

http://en.wikipedia.org/wiki/Apperson

pgsql-general by date:

Previous
From: Greg Smith
Date:
Subject: Re: Any Good Postgresql Courses Offered in the US Area?
Next
From: Joe Conway
Date:
Subject: Re: Performance Tuning - Any easy things that I can do ?