Re: INSERTing lots of data

Поиск
Список
Период
Сортировка
От Craig Ringer
Тема Re: INSERTing lots of data
Дата
Msg-id 4BFFFD0B.50500@postnewspapers.com.au
обсуждение исходный текст
Ответ на Re: INSERTing lots of data  (Joachim Worringen <joachim.worringen@iathh.de>)
Список 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 по дате отправления:

Предыдущее
От: Jignesh Shah
Дата:
Сообщение: cannot use column references in default expression?
Следующее
От: Craig Ringer
Дата:
Сообщение: Re: cannot use column references in default expression?