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

From Sergey A.
Subject Re: How to force PostgreSQL to use multiple cores within one connection?
Date
Msg-id 3bff71aa0810010558p50852d53hf48f14ba680757e9@mail.gmail.com
Whole thread Raw
In response to Re: How to force PostgreSQL to use multiple cores within one connection?  (David Fetter <david@fetter.org>)
Responses Re: How to force PostgreSQL to use multiple cores within one connection?  ("Scott Marlowe" <scott.marlowe@gmail.com>)
Re: How to force PostgreSQL to use multiple cores within one connection?  (Bill Moran <wmoran@collaborativefusion.com>)
List pgsql-general
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.

--
Sergey.

pgsql-general by date:

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