Postgres Pro
Downloads
Home   >   mailing lists

Re: plpython transforms vs. arrays - Mailing list pgsql-sql

From Mark Teper
Subject Re: plpython transforms vs. arrays
Date
Msg-id CAMwSyGq7rke2+32j9ZUOxx+vEa-1m3QBOXckpOi0Ry8JxSVxPg@mail.gmail.com
Whole thread Raw
Responses AW: plpython transforms vs. arrays  ("Sonnenberg-Carstens, Stefan" <ssonnenberg@ophardt.com>)
List pgsql-sql
Tree view
Hi Stefan,

>  is the Python code running inside the PostgreSQL instance?  

Yes, it is using the PL Python language so it runs in the PostgreSQL instance.  With some help from Tom, I've been able to make the change needed to allow this transform.  

I need to do some more testing, but my preliminary results for the arrays I'm interested in show transforming Postgres to Numpy is about 5x faster and transforming Numpy back to Postgres about 2x faster.

Regards,
Mark

pgsql-sql by date:

Previous
From: "Sonnenberg-Carstens, Stefan"
Date:
Subject: AW:
Next
From: "Sonnenberg-Carstens, Stefan"
Date:
Subject: AW: plpython transforms vs. arrays