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

From: Bill Moran <wmoran(at)collaborativefusion(dot)com>
To: "Sergey A(dot)" <n39052(at)gmail(dot)com>
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 13:05:50
Message-ID: 20081001090550.1d361979.wmoran@collaborativefusion.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

In response to "Sergey A." <n39052(at)gmail(dot)com>:
>
> > 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.

There is a network API for COPY. Look up pg_put_line (or PQputLine
or whatever the convention is for whatever API you're using).

--
Bill Moran
Collaborative Fusion Inc.
http://people.collaborativefusion.com/~wmoran/

wmoran(at)collaborativefusion(dot)com
Phone: 412-422-3463x4023

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2008-10-01 13:21:45 Re: Index question regarding numeric operators
Previous Message Scott Marlowe 2008-10-01 13:03:07 Re: How to force PostgreSQL to use multiple cores within one connection?