anze3db, 4 days ago to PostgreSQL

Mystery solved! The problem was that requests were creating new db connections which is super expensive.

Adding POOL to the database OPTIONS (added in Django 5.1a1) solves this problem and brings throughput on par with SQLite 🎉

https://docs.djangoproject.com/en/dev/releases/5.1/#postgresql-connection-pools
https://fosstodon.org/@anze3db/112557766800166792

helge, 4 days ago to PostgreSQL

Did I mention that it would be really nice to have #PostgreSQL as an embeddable library similar to #SQLite? Size wise that should be fine, I think the whole PG daemon is just ~5MB.
I know that the architecture doesn't lean to it, but someone has to do this eventually! 🙂

ascherbaum, 4 days ago to PostgreSQL

Call for Papers for the PostgreSQL Conference Europe 2024 in Athens is open. You have about 4 weeks to submit your cool talks!

And please limit the number of submissions to a reasonable number ...

#PostgreSQL #Conference #Athens #CfP #CallForPapers

https://www.postgresql.eu/events/pgconfeu2024/news/call-for-papers-for-postgresql-conference-europe-2024-is-now-open-131/

hunleyd, 4 days ago to PostgreSQL

Pavel Stehule's blog: new extension pgmeminfo #postgresql https://okbob.blogspot.com/2024/02/new-extension-pgmeminfo.html

ascherbaum, 4 days ago to PostgreSQL

#PostgreSQL Event Calendar, Reminder:

👫 PG Development Conference 2024

Date: 2024-05-28 - 2024-05-31
Location: Vancouver, BC, Canada

ICS file: https://ics.postgresql.life/7c61p323nvvu9ul2r4v07rmp71.ics

ascherbaum, 4 days ago to PostgreSQL

TIL (ok, last week): #PostgreSQL has 375+ extensions

According to Abigale Kim at #PGConfdev

hunleyd, 5 days ago to PostgreSQL

Waiting for #PostgreSQL 17 – Add new COPY option SAVE_ERROR_TO / Rename COPY option from SAVE_ERROR_TO to ON_ERROR – select * from depesz; https://www.depesz.com/2024/02/07/waiting-for-postgresql-17-add-new-copy-option-save_error_to-rename-copy-option-from-save_error_to-to-on_error/

pgconfeu, 6 days ago to PostgreSQL

Call for Papers for PostgreSQL Conference Europe 2024 is now open 🐘 https://www.postgresql.eu/events/pgconfeu2024/news/call-for-papers-for-postgresql-conference-europe-2024-is-now-open-131/

#postgresql #database #opensource #athens