Alex Gleason on Nostr: The main thing I'm working on right now is just trying to make tag queries fast on a ...
The main thing I'm working on right now is just trying to make tag queries fast on a 500GB Postgres database, lol. In order to really, truly do that, I have to first understand on a deep level what "nested loop bitmap heap scan recheck cond" means.
Published at
2024-07-17 17:24:45Event JSON
{
"id": "33c0f6cfe01d5c97ffed159d4c5789c213622afd5417ff6da64e65c126e6f0d0",
"pubkey": "0461fcbecc4c3374439932d6b8f11269ccdb7cc973ad7a50ae362db135a474dd",
"created_at": 1721229885,
"kind": 1,
"tags": [],
"content": "The main thing I'm working on right now is just trying to make tag queries fast on a 500GB Postgres database, lol. In order to really, truly do that, I have to first understand on a deep level what \"nested loop bitmap heap scan recheck cond\" means.",
"sig": "ffc6ac6f7ae2d7f9aa81dc927889a9169722d3a9dabc5f902043ef7491295965240da94236a832086ff6a6bc483d542ce225f330b6fa5f55a9a5ea1b418b8a53"
}