| From: | Bill Moran <wmoran(at)collaborativefusion(dot)com> |
|---|---|
| To: | "Scott Marlowe" <scott(dot)marlowe(at)gmail(dot)com> |
| Cc: | "Sergey A(dot)" <n39052(at)gmail(dot)com>, "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 15:25:22 |
| Message-ID: | 20081001112522.aea0d352.wmoran@collaborativefusion.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
In response to "Scott Marlowe" <scott(dot)marlowe(at)gmail(dot)com>:
> On Wed, Oct 1, 2008 at 7:58 AM, Sergey A. <n39052(at)gmail(dot)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(at)collaborativefusion(dot)com
Phone: 412-422-3463x4023
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andreas Kretschmer | 2008-10-01 15:28:23 | Re: pg_restore stalled ??? |
| Previous Message | Gauthier, Dave | 2008-10-01 15:20:42 | pg_restore stalled ??? |