| From: | "Gauthier, Dave" <dave(dot)gauthier(at)intel(dot)com> |
|---|---|
| To: | Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>, "Wang, Mary Y" <mary(dot)y(dot)wang(at)boeing(dot)com> |
| Cc: | "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:41:59 |
| Message-ID: | 482E80323A35A54498B8B70FF2B87980043DF01CD0@azsmsx504.amr.corp.intel.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
analyze? Does the empirical data the optimizer use develop good queries get updated with/after a restore?
-----Original Message-----
From: pgsql-general-owner(at)postgresql(dot)org [mailto:pgsql-general-owner(at)postgresql(dot)org] On Behalf Of Scott Marlowe
Sent: Thursday, February 04, 2010 1:32 PM
To: Wang, Mary Y
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: [GENERAL] Performance Tuning - Any easy things that I can do ?
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.
Tuning 7.1 is kinda like performance tuning a 1916 Apperson Jackrabbit...
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Scott Marlowe | 2010-02-04 18:42:20 | Re: Any Good Postgresql Courses Offered in the US Area? |
| Previous Message | Krzysztof Walkiewicz | 2010-02-04 18:40:30 | How to set default database |