Re: INSERTing lots of data - Mailing list pgsql-general

From Craig Ringer
Subject Re: INSERTing lots of data
Date
Msg-id 4BFFFD0B.50500@postnewspapers.com.au
Whole thread Raw
In response to Re: INSERTing lots of data  (Joachim Worringen <joachim.worringen@iathh.de>)
List pgsql-general
On 28/05/2010 9:17 PM, Joachim Worringen wrote:

> In the "import data" case, however, I really need concurrent processing
> on the CPU in the first place, so you may be right on this one. I'll
> check it.

If you run into GIL problems, you can always work around it by spawning
multiple processes and communicating between them via pipes, signals,
shm, etc. That way you get one GIL per Python instance.

BTW, if you need decent CPU performance with Python, make sure you're
using the Pysco specializing compiler module for Python. Activating it
requires literally four lines at the start of your main module and the
speed improvement is mind blowing.

--
Craig Ringer

pgsql-general by date:

Previous
From: Jignesh Shah
Date:
Subject: cannot use column references in default expression?
Next
From: Craig Ringer
Date:
Subject: Re: cannot use column references in default expression?