Alex wrote:
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
Thanks John.
Well as I mentioned. I have a Dual AMD Opteron 64 2.4ghz, 15k rpm SCSI
Disks, 4GB of memory.
Disks are pretty fast and memory should be more than enough. Currently
we dont have many concurrent connections.
I run PG 8.0.1 on Fedora Core 3
When I now run the batch job, one CPU runs
Thanks John.
Well as I mentioned. I have a Dual AMD Opteron 64 2.4ghz, 15k rpm
SCSI
Disks, 4GB of memory.
Disks are pretty fast and memory should be more than enough. Currently
we dont have many concurrent connections.
I run PG 8.0.1 on Fedora Core 3
When I now run the batch job, one
: [PERFORM] How can I make use of both CPUs in a dual processor
Thanks John.
Well as I mentioned. I have a Dual AMD Opteron 64 2.4ghz, 15k rpm SCSI
Disks, 4GB of memory.
Disks are pretty fast and memory should be more than enough. Currently we
dont have many concurrent connections.
I run PG 8.0.1