Alex Gleason 🐍🚬 on Nostr: jsonb columns. Performance was so bad until I reorganized my database around ...
jsonb columns. Performance was so bad until I reorganized my database around Postgres-specific features.
Published at
2024-08-16 21:28:37Event JSON
{
"id": "9485586f4b03ba7a2fb06db677291ab1553075bd7a6b2c60ce3d04114071d855",
"pubkey": "0461fcbecc4c3374439932d6b8f11269ccdb7cc973ad7a50ae362db135a474dd",
"created_at": 1723843717,
"kind": 1,
"tags": [
[
"e",
"f9679417711a87cf6b17ebcb0f737f217c9aba28f446327ab971f8c1f516e1d4",
"wss://gleasonator.dev/relay",
"root"
],
[
"e",
"f59036a0a9d4c4a485825cea7b19446a22db726736595db4e5a6a718f091bc6c",
"wss://gleasonator.dev/relay",
"reply"
],
[
"p",
"d0e27c9abf1e6f633e1ca797bd3a4ec908b650806020573323f6dccf88e489f2"
]
],
"content": "jsonb columns. Performance was so bad until I reorganized my database around Postgres-specific features.",
"sig": "fe47eb0cf1840bc43d1e27601813f51982551261f6729e7eafbe9a819a2bb6e0a10a5b971c357515af29085d95d8b07d12b77339782d23706048accabbdad322"
}
