3 ms·

Here's a benchmark [1] against aiopg, which is psycopg2+asyncio. [1] http://magic.io/blog/asyncpg-1m-rows-from-postgres-to-python/report.html http://magic.io/b

• ddorian43 7y ago
  You can't scale that. Adding clients will have a lot of overhead (ex: 100K clients to 1 db server). Only way is autocommit with proxy (pgbouncer etc).
• ghostwriter 7y ago
  Unless aiopg patches psycopg2 around its C extension with available callback hooks (see [1] and [2] - psycogreen uses it to register gevent callbacks), this comparison is still between blocking and non-blocking IO scripts. Quick GitHub search for `set_wait_callback` didn't return any result in the aiopg repository - https://github.com/aio-libs/aiopg/search?q=set_wait_callback&unscoped_q=set_wait_callback https://github.com/aio-libs/aiopg/search?q=set_wait_callback... [1] https://www.psycopg.org/docs/extensions.html#coroutines-support-functions https://www.psycopg.org/docs/extensions.html#coroutines-supp... [2] https://www.psycopg.org/docs/advanced.html#green-support https://www.psycopg.org/docs/advanced.html#green-support