Nostr Web Client

Nostream uses a jsonb field for tags. But a tags table with correct indexes is more performant.

cc #[5]

I have about 20M tags on my DB it's hungry on CPU because tag quieries are usually the most common, threads and reactions, notifications etc, author lookups are much cheaper

Reply to this note

Please Login to reply.

Discussion

Vitor Pamplona 2y ago

That was my main concern... I think I will do a separate table to make queries slightly faster.

Kieran 2y ago

Correction: 36M