Thread: Performance Tuning - Any easy things that I can do ?
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). Thanks Mary
On 4 February 2010 15:54, 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). > Need to upgrade? That's a bit of an understatement. If you're able to do so, I'd strongly recommend it as PostgreSQL has dramatically improved in every area since then. I think you'll need a PostgreSQL veteran to help you out there. All I can think of is you take a look at the earliest available documentation (7.2 from what I can tell) and try looking into those settings: http://www.postgresql.org/docs/7.2/static/runtime-config.html Regards Thom
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. Tuning 7.1 is kinda like performance tuning a 1916 Apperson Jackrabbit... http://en.wikipedia.org/wiki/Apperson
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
Attachment
analyze? Does the empirical data the optimizer use develop good queries get updated with/after a restore? -----Original Message----- From: pgsql-general-owner@postgresql.org [mailto:pgsql-general-owner@postgresql.org] On Behalf Of Scott Marlowe Sent: Thursday, February 04, 2010 1:32 PM To: Wang, Mary Y Cc: pgsql-general@postgresql.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.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. Tuning 7.1 is kinda like performance tuning a 1916 Apperson Jackrabbit... http://en.wikipedia.org/wiki/Apperson -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Gauthier, Dave escribió: > analyze? Does the empirical data the optimizer use develop good queries get updated with/after a restore? Not automatically, you have to invoke it manually. (In recent releases, autovacuum would do it, but 7.1 didn't have it). -- Alvaro Herrera http://www.CommandPrompt.com/ The PostgreSQL Company - Command Prompt, Inc.
On Thu, Feb 4, 2010 at 11:41 AM, Gauthier, Dave <dave.gauthier@intel.com> wrote: > analyze? Does the empirical data the optimizer use develop good queries get updated with/after a restore? Nope.