Re: [PERFORM] Large (almost 50%!) performance drop after upgrading to 8.4.4?

2010-06-10 Thread Max Williams
...@wicourts.gov] Sent: 10 June 2010 16:16 To: Max Williams; pgsql-performance@postgresql.org Subject: Re: [PERFORM] Large (almost 50%!) performance drop after upgrading to 8.4.4? Max Williams wrote: > I'm afraid pg_config is not part of the pgdg packages. Connect (using psql or your

Re: [PERFORM] Large (almost 50%!) performance drop after upgrading to 8.4.4?

2010-06-10 Thread Max Williams
I'm afraid pg_config is not part of the pgdg packages. -Original Message- From: Tom Lane [mailto:t...@sss.pgh.pa.us] Sent: 10 June 2010 15:11 To: Max Williams Cc: pgsql-performance@postgresql.org Subject: Re: [PERFORM] Large (almost 50%!) performance drop after upgrading to

Re: [PERFORM] Large (almost 50%!) performance drop after upgrading to 8.4.4?

2010-06-10 Thread Max Williams
How do I tell if it was built with debugging options? -Original Message- From: Devrim GÜNDÜZ [mailto:dev...@gunduz.org] Sent: 10 June 2010 09:30 To: Robert Haas Cc: Max Williams; pgsql-performance@postgresql.org Subject: Re: [PERFORM] Large (almost 50%!) performance drop after upgrading

Re: [PERFORM] Large (almost 50%!) performance drop after upgrading to 8.4.4?

2010-06-10 Thread Max Williams
Well the packages are from the pgdg repo which I would have thought are pretty common? https://public.commandprompt.com/projects/pgcore/wiki -Original Message- From: Robert Haas [mailto:robertmh...@gmail.com] Sent: 10 June 2010 02:52 To: Max Williams Cc: pgsql-performance

[PERFORM] Large (almost 50%!) performance drop after upgrading to 8.4.4?

2010-06-09 Thread Max Williams
Hi, I was doing some benchmarking while changing configuration options to try to get more performance out of our postgresql servers and noticed that when running pgbench against 8.4.3 vs 8.4.4 on identical hardware and configuration there is a large difference in performance. I know tuning is a