brycethornton

Try keeping it on airplane mode if you don't already. It definitely improves the length of a charge.

I still use Groups and Marketplace but my home feed is blocked thanks to News Feed Eradicator. Check it out if you haven't heard of it. It's a browser extension that can block the home feed (and more) for a number of social sites.

Really cool. It'll be interesting to see how Multigres (by Supabase) shapes up compared to this. I think it's great to have more/better competitive hosted Postgres offerings.

I believe Mixture-of-Experts is a way for a neural network to group certain knowledge into smaller subsets. AFAIK there isn't a specific grouping goal, the network just figures out what goes where on it's own and then when an inference request is made it determines what "expert" would have that knowledge and routes it there. This makes the inference process much more efficient.

Yeah, I believe the firmware on all compatible devices was auto-updated to the new architecture and apparently they can't go back to the old firmware for some reason. What a mess.

Apple Watches have been great for us. Both of my kids (ages 10 & 13) use a cellular Apple Watch which gives them a way to call/text with us and their friends but it doesn't give them access to social media. I know they'll want a phone soon (my youngest is already asking) but it's an easy "no" for us. I think waiting until around age 14 (or later) sounds about right. I'd like to delay even longer if possible. We'll see how hard they push.

I don't think anybody is assuming it will stay clean without continued work to clean and improve the root causes of the pollution. Still worth doing.

Probably "air" squats, just squatting to parallel or below without any weights.

I don't think so, just a handy feature.

ToothFairy for macOS is what I've been using to handle this. It has an advanced setting for headphones that "Improve sound quality by disabling audio input from device". It's always good to have multiple tools out there to solve problems like this.

Thanks for the reply. My question was specifically about the MVCC feature that creates new rows for updates like this. If you're backfilling data into a new column then you'll likely end up creating new rows for the entire table and the space for the old rows will be marked for re-use via auto-vacuuming. Anyway, bloat like this is a big pain for me when make migrations on huge tables. It doesn't sound like this type of bloat cleanup is a goal for pgroll. Regardless, it's always great to have more options in this space. Thanks for your work!

Does pgroll have any process to address table bloat after the migration? One of the (many) nice things about pg-osc is that it results in a fresh new table without bloat.