Re: How to force PostgreSQL to use multiple cores within one connection? - Mailing list pgsql-general

From Scott Marlowe
Subject Re: How to force PostgreSQL to use multiple cores within one connection?
Date
Msg-id dcc563d10810010603i3fc375d2lf02aa48a2b883bed@mail.gmail.com
Whole thread Raw
In response to Re: How to force PostgreSQL to use multiple cores within one connection?  ("Sergey A." <n39052@gmail.com>)
Responses Re: How to force PostgreSQL to use multiple cores within one connection?  ("Sergey A." <n39052@gmail.com>)
List pgsql-general
On Wed, Oct 1, 2008 at 6:58 AM, Sergey A. <n39052@gmail.com> wrote:
> 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.

Sure it does.

copy .... from STDIN
213 345 567
847 837 473
\.

pgsql-general by date:

Previous
From: "Gurjeet Singh"
Date:
Subject: Re: Index question regarding numeric operators
Next
From: Bill Moran
Date:
Subject: Re: How to force PostgreSQL to use multiple cores within one connection?