Re: How to force PostgreSQL to use multiple cores within one connection?

From: "Sergey A(dot)" <n39052(at)gmail(dot)com>
To: "David Fetter" <david(at)fetter(dot)org>
Cc: "PostgreSQL General" <pgsql-general(at)postgresql(dot)org>
Subject: Re: How to force PostgreSQL to use multiple cores within one connection?
Date: 2008-10-01 12:58:25
Message-ID: 3bff71aa0810010558p50852d53hf48f14ba680757e9@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello.

> You can use it for whatever you're generating.
I've tested this technique, and I'm wondering! 120000 inserts per
~600ms! Thanks for your help.

> Multiple cores are not the solution to your problem here, but COPY
> almost certainly is :)
But as I can see this approach doesn't work over network: I need to
create file with data locally, and then ask PostgreSQL to read it.

--
Sergey.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Gurjeet Singh 2008-10-01 13:00:46 Re: Index question regarding numeric operators
Previous Message David Fetter 2008-10-01 12:17:19 Re: How to force PostgreSQL to use multiple cores within one connection?