On 02/04/2010 10:32 AM, Scott Marlowe wrote:
> 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.
One thing you might try if you haven't already done so is run VACUUM
ANALYZE.
Joe