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@xxxxxxxxxx> 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
Attachment:
signature.asc
Description: OpenPGP digital signature
