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

From: "Scott Marlowe" <scott(dot)marlowe(at)gmail(dot)com>
To: "Sergey A(dot)" <n39052(at)gmail(dot)com>
Cc: "David Fetter" <david(at)fetter(dot)org>, "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 13:03:07
Message-ID: dcc563d10810010603i3fc375d2lf02aa48a2b883bed@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wed, Oct 1, 2008 at 6:58 AM, Sergey A. <n39052(at)gmail(dot)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
\.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Bill Moran 2008-10-01 13:05:50 Re: How to force PostgreSQL to use multiple cores within one connection?
Previous Message Gurjeet Singh 2008-10-01 13:00:46 Re: Index question regarding numeric operators