Re: [PERFORM] Postgres batch write very slow - what to do

On 3/15/07, femski <[EMAIL PROTECTED]> wrote: 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. we

Re: [PERFORM] Postgres batch write very slow - what to do

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, femski <[EMAIL PROT

Re: [PERFORM] Postgres batch write very slow - what to do

On 3/14/07, femski <[EMAIL PROTECTED]> wrote: Ok, I turned off XDMCP and network bandwidth utilization dropped to less than 5%. Timings remained the same. Curiously five times faster time for Oracle came from a client running on a different host than the server. To make things worse for Postgre

Re: [PERFORM] Postgres batch write very slow - what to do

Ok, I turned off XDMCP and network bandwidth utilization dropped to less than 5%. Timings remained the same. Curiously five times faster time for Oracle came from a client running on a different host than the server. To make things worse for Postgres, when I replace "hostname" in jdbc string to "