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

building reel.farm and farcasterstudio.com

Do you have a link to the schema definition, as well as some example queries in the GitHub repo that are timing out?

I know you've said that you've added indexes, but I've seen Postgres databases chug along just fine until they cross a threshold where the schema design crumbles underneath the weight of the data.