Absolutely!
A summary of relevant comments so far are:
- enable-mergejoin
- shared-buffers
- fsync
Another to consider if you use indexes is random-page-cost.
What would be helpful is if you could identify a slow query and post the explain analyze here.
The concurrent performance of many users should just be faster with 8.2, so I'd think it's a problem with plans.
- Luke
Msg is shrt cuz m on ma treo
-----Original Message-----
From: Douglas J Hunley [mailto:doug@hunley.homeip.net]
Sent: Monday, June 04, 2007 08:40 AM Eastern Standard Time
To: Luke Lonergan
Cc: Tom Lane; pgsql-performance@postgresql.org
Subject: Re: [PERFORM] upgraded to pgsql 8.2.4, getting worse performance then 7.4.x
On Sunday 03 June 2007 16:39:51 Luke Lonergan wrote:
> When you initdb, a config file is edited from the template by initdb to
> reflect your machine config.
I didn't realize that. I'll have to harass the rest of the team to see if
someone overwrote that file or not. In the interim, I did an 'initdb' to
another location on the same box and then copied those values into the config
file. That's cool to do, I assume?
--
Douglas J Hunley (doug at hunley.homeip.net) - Linux User #174778
http://doug.hunley.homeip.net
Cowering in a closet is starting to seem like a reasonable plan.