Yesterday we migrated many #postgresql databases to 16.2. It went smoothly for all of them except one.
The database is used by Sidekiq for 90% of the traffic. We choose a time window outside of working hours, but still we had some traffic, and we didn't turn off pods. The database was inaccessible for 10min. Jobs rescheduled, and quickly auto-scaling was triggered. I was not able to perform ANALYZE. So requests retrying at the same time + huge disk read. 💥
The last 2 week were full of SQL and PostgreSQL RDS. Sometimes it was difficult but always very interesting. I learn a lot and I really love the community and this piece of technology.
Still some frustrations but at least I know some caveats about the #postgresql.
We had also a big freeze on one of our DB after an upgrade. We had to do a full analyze, then kill queries that were waiting because of BufferIO or DataFileRead.
We didn't understand what happen. Bad statistic? Query that block I/O 🤷
OK le gang de la #Daronnie.
C'est dur de faire des repas et de faire manger des enfants par ce temps.
Il faut pourtant qu'ils avalent des calories.
Quels sont vos pro tips?
Je commence :
🔸melon-pastèque
🔸smoothies
🔸wraps froids avec du fromage frais, du jambon de dinde et de la salade / du céleri
🔸hoummous de pois chiches en boîte
🔸si on cuit des trucs, c'est au micro ondes
changer le format des repas. Faire un apéro avec des légumes à croquer avec des formes cool, du fromage, des mix type humus (avec déclinaison haricots rouges, lentilles corail, etc) ou simplement rajouter des pics en bois pour manger en général
tomates cerises au four (dans un peu d'eau et d'huile d'olive) avec du riz à côté
Les priorités à droite en agglomération, encore une idée qui devrait disparaître pour permettre aux enfants de plus prendre la route.
Je comprendrais jamais ces économies de panneaux, alors que tous les mois ces carrefours sont des sources d'accidents.
I’m building an attention tracking app for macOS called N₁₀, and it’s far enough along now that I feel comfortable talking about it.
Here’s the onboarding animation I’ve been working on. There’s more to the app that I want to illustrate, but this video explains the core functionality. Everything you see is drawn with #SwiftUI