pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Alex <alex@meerkatsoft.com>
To: pgsql-performance@postgresql.org
Subject: How can I make use of both CPUs in a dual processor machine
Date: Thu, 10 Feb 2005 01:26:35 +1100
Message-ID: <420A1D9B.1040801@meerkatsoft.com> (raw)

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




view thread (7+ messages)  latest in thread

Message-ID: <420A1D9B.1040801@meerkatsoft.com>
Permalink:  ../420A1D9B.1040801@meerkatsoft.com/
Also on:    postgresql.org/message-id/420A1D9B.1040801@meerkatsoft.com

 · 

reply

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: alex@meerkatsoft.com
  Subject: Re: How can I make use of both CPUs in a dual processor machine
  In-Reply-To: <420A1D9B.1040801@meerkatsoft.com>

* 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