Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: Performace Optimization for Dummies
- From: Heikki Linnakangas <heikki(at)enterprisedb(dot)com>
- To: Carlo Stonebanks <stonec(dot)register(at)sympatico(dot)ca>
- Cc: pgsql-performance(at)postgresql(dot)org
- Subject: Re: Performace Optimization for Dummies
- Date: Fri, 29 Sep 2006 10:12:43 +0100
Carlo Stonebanks wrote:
We urgently need a major performance improvement. We are running thePostgreSQL 8.1.4 on a Windows 2003 x64 Server on a dual processor, dual core 3.2Ghz Xeon box with 4gb RAM and a RAID (sorry, I don't know what type) discsubsystem. Sorry about the long intro, but here are my questions:
Others have already drilled down to the way you do the inserts and statistics etc., so I'll just point out:
Are you fully utilizing all the 4 cores you have? Could you parallelize the loading process, if you're currently running just one client? Are you I/O bound or CPU bound?
-- Heikki Linnakangas EnterpriseDB http://www.enterprisedb.com
- References:
- Performace Optimization for Dummies
- From: Carlo Stonebanks
- Performace Optimization for Dummies
- Prev by Date: Re: Performace Optimization for Dummies
- Next by Date: Re: any hope for my big query?
- Previous by thread: Re: Performace Optimization for Dummies
- Next by thread: Re: Performace Optimization for Dummies
- Indexes: