Anže :python: on Nostr: Any idea why PostgreSQL is this much slower compared to SQLite and MySQL? This is on ...
Any idea why PostgreSQL is this much slower compared to SQLite and MySQL?
This is on Ubuntu 24.04, connecting through Django and I've tried both psycopg and psycopg2, but the result is the same: ~200 requests per second with Postgres compared to ~2000 with SQLite or MySQL.
Published at
2024-06-04 10:00:20Event JSON
{
"id": "e73b3f2783d4640563e458cecbc2469ac921127ed0ba1e7f99d3c006732a66bf",
"pubkey": "a39a91945320863e63212c3b4f06a13aa380f33aa231788cf172e6701ba657f4",
"created_at": 1717495220,
"kind": 1,
"tags": [
[
"proxy",
"https://fosstodon.org/@anze3db/112557766800166792",
"web"
],
[
"imeta",
"url https://cdn.fosstodon.org/media_attachments/files/112/557/766/709/204/795/original/0afcdbb686c466a4.png",
"m image/png"
],
[
"proxy",
"https://fosstodon.org/users/anze3db/statuses/112557766800166792",
"activitypub"
],
[
"L",
"pink.momostr"
],
[
"l",
"pink.momostr.activitypub:https://fosstodon.org/users/anze3db/statuses/112557766800166792",
"pink.momostr"
]
],
"content": "Any idea why PostgreSQL is this much slower compared to SQLite and MySQL?\n\nThis is on Ubuntu 24.04, connecting through Django and I've tried both psycopg and psycopg2, but the result is the same: ~200 requests per second with Postgres compared to ~2000 with SQLite or MySQL.\nhttps://cdn.fosstodon.org/media_attachments/files/112/557/766/709/204/795/original/0afcdbb686c466a4.png\n",
"sig": "c1281cf769096958d787a1ff107a894f70d69ee11397f3b1213559783c1a6b3dddbf2b11216b476dc7de40c8b86be048fdcc653f393e9ee7f136188387588e48"
}
