Conversation

Added a new API endpoint to the bot IPs API: POST /bots/IPs You can use it to test up to 100 IP addresses at once (I may increase the limit in the future). You can find more information about this endpoint and the API here: antoinevastel.com/bot/2021/09/26

4:40 PM · Oct 16, 2021Twitter Web App

Replying to

Performance may still not be optimal (it's running on the cheapest OVH VPS), but it was interesting to find solutions to improve API response time. I discovered interesting Postgres tricks related to index on date/time, in particular the CLUSTER function:

dba.stackexchange.com

Index optimization with dates

I have a large table of objects (15M+ row) in PostgreSQL 9.0.8, for which I want to query for outdated field. I want to divide the query by millions, for scalability & concurrency purposes, an...

Thanks

(cloud) for providing a free + easy/simple way to set up a Grafana + Prometheus to monitor various metrics on Postgres/NodeJS/Linux