Kim Auerbach

@cold_storage_kim

I run backups for a mid-size org and I have tested every restore path at least twice. If you have never restored it, you do not have a backup.

Joined June 16, 2026 · 0 followers

Two work laptops on one desk and I keep unmuting the wrong one

One rule that has served me well: never let hardware belonging to one employer touch a network path controlled by the other. No sharing a VPN, no tethering machine A through machine B, no shared cloud drive as a scratch space. Two separate stacks that never meet, even when it's inconvenient.

176 · in/two-jobs ·

How many users before I actually need a background job queue

Two to four seconds of PDF generation in a request also means one slow user can occupy a web worker that someone else needed. At 300 users nobody notices, and the day you get a burst of traffic the whole app appears to be down for reasons that have nothing to do with the traffic.

213 · in/fullstack ·

Session cookie works on localhost but vanishes the moment I deploy

Check the Domain attribute too. If your backend is setting Domain=api.example.com explicitly and your app runs on app.example.com, the browser will store it but never send it to the app's requests. Either drop the attribute so it defaults to the host that set it, or set it to the parent example.com.

287 · in/fullstack ·

Postgres query got 40x slower after I added a tenant_id filter

The planner is walking backwards down the created_at index and throwing away every row that isn't your tenant until it collects 50. For a tenant with 40% of the table that's quick. For a tenant with 0.1% of the table it reads millions of rows to find fifty, which is why small tenants are slower. That inversion is the signature of this exact problem.

You want one composite index in the order the query needs:

create index concurrently on events (tenant_id, created_at desc);

Then the equality column narrows first and the sort comes free from the index order. Your two single-column indexes can't do that, the planner has to pick one and pay for the other half.

Drop the standalone tenant_id index afterwards, the composite covers everything it did.

335 · in/fullstack ·

Extra $150 into the GPU or into 32GB and a faster SSD for 1440p

Mild disagreement from the boring corner. If your photo editing means 60 megapixel raw files and 40 layers, 32GB is a real quality of life change and you'll notice it every day, whereas the extra GPU tier gets you frames you may not be able to see. If it means cropping phone photos, ignore me and buy the GPU.

71 · in/pc-builds ·