Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: Limited performance on multi core server
- From: Heikki Linnakangas <heikki(at)enterprisedb(dot)com>
- To: mlunnon(at)rwa-net(dot)co(dot)uk
- Cc: pgsql-performance(at)postgresql(dot)org
- Subject: Re: Limited performance on multi core server
- Date: Fri, 14 Dec 2007 11:11:58 +0000
- Message-id: <476264FE(dot)8050101(at)enterprisedb(dot)com>
Matthew Lunnon wrote:
Ah I was afraid of that. Maybe I'll have to come out of the dark ages.
At the very least, upgrade to latest 7.4 minor version. It probably won't help with you're performance, but 7.4.3 is very old. There's been a *lot* of bug fixes between 7.4.3 and 7.4.18, including fixes for security vulnerabilities and data corruption bugs.
Steinar H. Gunderson wrote:On Wed, Dec 12, 2007 at 10:16:43AM +0000, Matthew Lunnon wrote:Does anyone have any ideas what my bottle neck might be and what I can do about it?Your bottleneck is that you are using a very old version of PostgreSQL. Try 8.2 or (if you can) the 8.3 beta series -- it scales a _lot_ better in thiskind of situation. /* Steinar */
-- Heikki Linnakangas EnterpriseDB http://www.enterprisedb.com
- References:
- Limited performance on multi core server
- From: Matthew Lunnon
- Re: Limited performance on multi core server
- From: Steinar H. Gunderson
- Re: Limited performance on multi core server
- From: Matthew Lunnon
- Limited performance on multi core server
- Prev by Date: Re: Need help on parameters and their values to tune the postgresql database
- Next by Date: viewing source code
- Previous by thread: Re: Limited performance on multi core server
- Next by thread: Re: Limited performance on multi core server
- Indexes: