A place for developers to talk about building on Farcaster.

/dev

⚠️ FarcasterUserStats.com is down

i really need help, this is frustrating

‼️ postgres db connection limit maxed, i have a pool in place, not sure if that actually works or not

sql queries to the db should be less than 1-2s max, but now they're going over 15s timing out

See what dominates in `SELECT * FROM pg_stat_activity` and look for leaks and inefficients in related code. Happy to help you out in scanning the code for such issues :)

Building /frametown. Amusement, wonder, and uncertainty ✴︎ libred.org


Other things that pops to my mind if you're using pgbouncer: 1) check if you're using 'transaction' pool mode, 2) try increasing max_client_conn if you don't have any more optimalizations to make

already added indexes and cleaned up the sql queries, i believe this might be a postgres db connection issue