How can I make use of both CPUs in a dual processor machine

From: Alex <alex(at)meerkatsoft(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: How can I make use of both CPUs in a dual processor machine
Date: 2005-02-09 14:26:35
Message-ID: 420A1D9B.1040801@meerkatsoft.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Hi,
we just got a new dual processor machine and I wonder if there is a way
to utilize both processors.

Our DB server is basically fully dedicated to postgres. (its a dual amd
with 4gb mem.)

I have a batch job that periodically loads about 8 million records into
a table.
for this I drop the indices, truncate the table, use the copy to insert
the data, recreate the indices (4 indices), vacuum the table.

That is all done through a perl batch job.

While I am doing this, I noticed that only one CPU is really used.

So here are my questions:

Is there a way to utilize both CPUs

Is it possible to split up the import file and run 2 copy processes

Is it possible to create 2 indices at the same time

Would I actually gain anything from that, or is the bottleneck somewhere
else ?

(perl is a given here for the batch job)

If anyone has some experience or ideas... any hints or help on this
would be appreciated.

Thanks
Alex

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message John A Meinel 2005-02-09 14:49:11 Re: How can I make use of both CPUs in a dual processor
Previous Message Christopher Kings-Lynne 2005-02-09 09:14:49 Re: query produces 1 GB temp file