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

From Bill Moran
Subject Re: How to force PostgreSQL to use multiple cores within one connection?
Date
Msg-id 20081001112522.aea0d352.wmoran@collaborativefusion.com
Whole thread Raw
In response to Re: How to force PostgreSQL to use multiple cores within one connection?  ("Scott Marlowe" <scott.marlowe@gmail.com>)
List pgsql-general
In response to "Scott Marlowe" <scott.marlowe@gmail.com>:

> On Wed, Oct 1, 2008 at 7:58 AM, Sergey A. <n39052@gmail.com> wrote:
> >> Sure it does.
> >>
> >> copy .... from STDIN
> >> 213 345 567
> >> 847 837 473
> >> \.
> >
> > Thanks. Was this query entered in psql shell?
>
> Yes, but if you're using something like php, you can enter it as a
> single string and it will work.

php also has pg_put_line(), which reduces the memory overhead on both
the client and server.  Hopefully, whatever language you're using has
an API for expediting as well.

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

wmoran@collaborativefusion.com
Phone: 412-422-3463x4023

pgsql-general by date:

Previous
From: "Gauthier, Dave"
Date:
Subject: pg_restore stalled ???
Next
From: Andreas Kretschmer
Date:
Subject: Re: pg_restore stalled ???