analyze? Does the empirical data the optimizer use develop good queries get updated with/after a restore?
-----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Scott Marlowe Sent: Thursday, February 04, 2010 1:32 PM To: Wang, Mary Y Cc: [email protected] Subject: Re: [GENERAL] Performance Tuning - Any easy things that I can do ? On Thu, Feb 4, 2010 at 8:54 AM, Wang, Mary Y <[email protected]> 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 -- Sent via pgsql-general mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general -- Sent via pgsql-general mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
