After a period of learning about #postgres and indexes.

I replaced the gin index with the tags table and optimized the index on the events table. The query speed of my #nostr #relay has been greatly improved.

Will continue to learn postgres and optimize query speed.

https://github.com/CodyTseng/nostr-relay-nestjs

Reply to this note

Please Login to reply.

Discussion

No replies yet.