From: Carlo Stonebanks <stonec.register@sympatico.ca>
To: pgsql-performance@postgresql.org
Subject: Re: Performace Optimization for Dummies
Date: Mon, 2 Oct 2006 22:43:46 -0400
Message-ID: <efsip1$17hd$1@news.hub.org> (raw)
References: <efgu4v$276m$1@news.hub.org>
<451CE38B.7070107@enterprisedb.com>
I have loaded three of the four cores by running three different versions of
the import program to import three different segments of the table to
import. The server jumps to 75% usage, with three postgresql processes
eating up 25% each., the actual client itself taking up just a few ticks.
"Heikki Linnakangas" <heikki@enterprisedb.com> wrote in message
news:451CE38B.7070107@enterprisedb.com...
> 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
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: Don't 'kill -9' the postmaster
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: stonec.register@sympatico.ca
Subject: Re: Performace Optimization for Dummies
In-Reply-To: <efsip1$17hd$1@news.hub.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox