Re: Performace Optimization for Dummies

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(at)enterprisedb(dot)com> wrote in message
news:451CE38B(dot)7070107(at)enterprisedb(dot)com(dot)(dot)(dot)
> 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
>