@vladyslav

Finally after 4 days of non stop work I can rest for a bit - optimized database for @launchtokenbot as it before could not handle the traffic. Most of the queries take milliseconds to execute now. My lesson learned - you can index lots of dex events but most likely it’s not worth it and you’ll end up in unoptimizable SYNC exec plan pit-hole. Good thing is that I understand postgresql much better now.

1 reply

6 recasts

13 reactions