psycopg3 performance article

From: Daniele Varrazzo <daniele(dot)varrazzo(at)gmail(dot)com>
To: psycopg(at)postgresql(dot)org
Subject: psycopg3 performance article
Date: 2020-05-20 08:15:04
Message-ID: CA+mi_8Y3FRJy9W=mb5VLzpiOfvyiAoiTaXs4UcGphuyLWXjkAg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: psycopg

Hello,

I did some benchmark on psycopg3 and got a pretty grim picture of how
slow a pure Python module is compared to something similar written in
C...

As per original plan I added an optional C implementation
(specifically, written in Cython, to help with boilerplate/refcount)
and the result is a sweet 20x speed-up.

If you are interested I have a write-up of the profiling/optimization
process here: https://www.varrazzo.com/blog/2020/05/19/a-trip-into-optimisation/

Cheers!

-- Daniele

Browse psycopg by date

  From Date Subject
Next Message Frank Millman 2020-05-26 11:42:56 Minor issue
Previous Message Daniele Varrazzo 2020-04-06 07:54:11 Psycopg 2.8.5 released