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:[EMAIL PROTECTED] 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.
