AW: plpython transforms vs. arrays

Understood, a great example what is possible if the toolset is open ;-)

Mit freundlichen Grüßen
Stefan Sonnenberg-Carstens

Teamleiter Softwareentwicklung WECO / DevOps Engineer
B.Sc. Wirtschaftsinformatik

[Signatur_50-Jahre-ingo-man]

OPHARDT HYGIENE-TECHNIK GmbH + Co. KG
Lindenau 27
D - 47661 Issum

Tel: +49 2835 18-492
Fax: +49 2835 18-28492
Mail: ssonnenberg(at)ophardt(dot)com<mailto:ssonnenberg(at)ophardt(dot)com>

www.OPHARDT.com<http://www.ophardt.com/>

Handelsregistereintrag beim Amtsgericht Kleve:
Kommanditgesellschaft HRA 1681, Komplementärin:
OPHARDT HYGIENE-TECHNIK VerwaltungsGmbH HRB 3910

Geschäftsführer: Thomas Houcken

USt.-Identifikations-Nr.: DE813067257

CONFIDENTIALITY NOTICE:

This e-mail communication and any attachments may contain confidential and privileged information for the use
of the designated recipients named above. Any unauthorized review, use, disclosure or distribution is prohibited.
If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies
of the original message.

Von: Mark Teper [mailto:mark(dot)teper(at)gmail(dot)com]
Gesendet: Montag, 6. Mai 2019 11:33
An: Sonnenberg-Carstens, Stefan; pgsql-sql(at)lists(dot)postgresql(dot)org
Betreff: Re: plpython transforms vs. arrays

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