Skip site navigation (1) Skip section navigation (2)

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: 2006-09-29 09:12:43
Message-ID: 451CE38B.7070107@enterprisedb.com (view raw or flat)
Thread:
Lists: pgsql-performance
Carlo Stonebanks wrote:
> We urgently need a major performance improvement. We are running the
> PostgreSQL 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) disc
> subsystem. 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

In response to

Responses

pgsql-performance by date

Next:From: Edoardo CeccarelliDate: 2006-09-29 09:19:19
Subject: Re: any hope for my big query?
Previous:From: Carlo StonebanksDate: 2006-09-29 05:01:51
Subject: Re: Performace Optimization for Dummies

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group