On 4 February 2010 15:54, Wang, Mary Y <mary.y.w...@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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general