| From: | Joe Conway <mail(at)joeconway(dot)com> |
|---|---|
| To: | Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com> |
| Cc: | "Wang, Mary Y" <mary(dot)y(dot)wang(at)boeing(dot)com>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Performance Tuning - Any easy things that I can do ? |
| Date: | 2010-02-04 18:37:20 |
| Message-ID: | 4B6B13E0.9070106@joeconway.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On 02/04/2010 10:32 AM, Scott Marlowe wrote:
> On Thu, Feb 4, 2010 at 8:54 AM, Wang, Mary Y <mary(dot)y(dot)wang(at)boeing(dot)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.
One thing you might try if you haven't already done so is run VACUUM
ANALYZE.
Joe
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Krzysztof Walkiewicz | 2010-02-04 18:40:30 | How to set default database |
| Previous Message | Scott Marlowe | 2010-02-04 18:32:21 | Re: Performance Tuning - Any easy things that I can do ? |