in case - I am missing something.
If 17k record/sec is right around expected then I must say I am little
disappointed from the "most advanced open source database".
thanks for all your help.
-Sanjay
Merlin Moncure-2 wrote:
>
> On 3/15/07, femski <[EMAIL PROTECTED]> wrot
I am using Oracle XE so its using only one core and doing just fine.
How do I split backend to 4+ processes ?
I don't want to write a multithreaded loader app.
And I didn't think Postgres can utilize multiple cores for the
same insert statement.
thanks,
-Sanjay
On 3/14/07, fems
string
to "localhost" or 127.0.0.1
it runs another 60% slower (446 sec vs 275 sec). Strange.
Before I take this discussion to jdbc list, why is CPU utilization 100%
during insert ? could that be a bottleneck. How to eliminate it ? These are
Intel WordCrest 5110 Xeon cores.
thank you
-S
I am runing Postgres 8.2 on OpenSuse 10.2 with latest jdbc driver. I moved
the app to be collocated with the server. Oracle takes 60 sec. Postgres 275
sec. For 4.7 million rows.
There are 4 CPUs on the server and one is runing close to 100% during
inserts.
Network history shows spikes of upto 60%
Folks !
I have a batch application that writes approx. 4 million rows into a narrow
table. I am using JDBC addBatch/ExecuteBatch with auto commit turned off.
Batch size is 100. So far I am seeing Postgres take roughly five times the
time it takes to do this in the Oracle.
I have played with man
