(Yes, those 100k inserts should be in background task and they are. I have related ire for celery, which will be a different thread)
The crappy orange-site answer to this would be "lol inspect your logs or hire a DBA/SRE"
What's amazing about that answer is how startup-unfriendly it is.
But @burbteam, we're ingesting hundreds of thousands of rows of data (soon to be millions), and almost every perf issue we've had is because we were ingesting those points as single INSERTs.
A thing that bugs me about #django (and really all ORMs) that we keep running into @burbteam -- no graceful ramp between single-fetch and bulk processing.
One of the joys of hosting the site that hosts the searchable archive of Alameda Minutes is that I can figure out what the hell is going on. (Really anyone can and honestly more people should)
The issue on the table: ASPA's management of Franklin Pool
Hey @simonw you've seen this, right?
Run Stable Diffusion on a mac without CUDA 😱
Level 10 Patreon Platformer, admin here and at Wandering.Shop. Say hello!
The social network of the future: No ads, no corporate surveillance, ethical design, and decentralization! Own your data with Mastodon!