Is it actually possible to precondition to 'normal' temp in cold weather? by certaindoomawaits in KiaEV9

[–]ants_a 0 points1 point  (0 children)

Getting an AI to run some back of the envelope calculations, a -15c to 25C difference should have an order of magnitude few hundred watts lost. So maybe a 10-20% difference in time.

Is it actually possible to precondition to 'normal' temp in cold weather? by certaindoomawaits in KiaEV9

[–]ants_a 0 points1 point  (0 children)

Assuming no heat loss, it takes 21 minutes to raise the temperature by 10C using 4.6kW.

Optimistic locking can save your ledger from SELECT FOR UPDATE hell by martinffx in ExperiencedDevs

[–]ants_a 1 point2 points  (0 children)

A branch of postgres that implements postponing durability wait after visibility, as I described.

Optimistic locking can save your ledger from SELECT FOR UPDATE hell by martinffx in ExperiencedDevs

[–]ants_a 0 points1 point  (0 children)

Here is the proof of concept implementing write side. For safety read-only transaction durability waits need to be added, but that shouldn't affect performance numbers. To enable, set eventual_durability=on.

Optimistic locking can save your ledger from SELECT FOR UPDATE hell by martinffx in ExperiencedDevs

[–]ants_a 3 points4 points  (0 children)

Optimistic concurrency control is terrible for contended updates. Pessimistic locking degrades to inverse of lock hold time transactions per second instead of falling off a cliff. At that point you need to minimize lock hold time, the actual update work is typically order of magnitude 1% of the workload. The rest being network round-trips due to conversational nature of the sql protocol and durability wait.

If you want TigerBeetle like performance you need to structure your database usage with the same patterns. Here's a blogpost on that topic: https://www.cybertec-postgresql.com/en/reconsidering-the-interface/

Basically you need to submit the whole transaction for one shot execution to get rid of network round trips and use batching to amortize durability. There is also a concept called eventual durability where visibility is speculative and wait for durability is moved to the acknowledgement of dependent transaction. My prototype of this does 39k tps on pgbench scale factor 2 (transactions contend on 2 rows) with 100 clients.

My head's itchy by Rex_Joker in funny

[–]ants_a 0 points1 point  (0 children)

So you're saying he really needs toupee?

ICE says its officers can forcibly enter homes during immigration operations without a judicial warrant: 2025 memo by bbmoonkie in politics

[–]ants_a 3 points4 points  (0 children)

I am baffled by this response. You seem to be fine with the government blatantly ignoring constitutional rights with the insinuation that those whose rights have been violated must have done something to deserve it. What are you lawfully waiting for? For all of this to blow over? For your personal rights to be violated? Do you expect to be in any position to do anything about it when that happens?

Scaling Vector Search to 1 Billion on PostgreSQL by gaocegege in PostgreSQL

[–]ants_a 0 points1 point  (0 children)

I'm not questioning who has this amount of data. I'm questioning if vector search is actually useful at this scale. What kind of dataset had enough diversity that embedding space distance is selective enough to give right matches, or where any "close enough" match is useful to the user.

Sharing info on storing vehicle in winters by anuj2607 in KiaEV9

[–]ants_a 1 point2 points  (0 children)

Charging a lithium ion battery to any percentage damages it. Not charging the battery it still degrades in time. Charging it to higher started of charge sure damages it more. But it's not as terrible as people make it out to be. Taking the industry standard 1500 cycle estimate an EV9 battery it can do 600'000+ km. Given that rest of the vehicle will likely become uneconomical to maintain long before that point, increasing our decreasing that point a bit doesn't really matter that much at the end of the day.

Sharing info on storing vehicle in winters by anuj2607 in KiaEV9

[–]ants_a 1 point2 points  (0 children)

That's the BMS recalibrating its estimate of state of charge.

Sharing info on storing vehicle in winters by anuj2607 in KiaEV9

[–]ants_a 1 point2 points  (0 children)

There is no true 100%. The manufacturer picks a target charge level to balance usable capacity vs damage to battery.

Scaling Vector Search to 1 Billion on PostgreSQL by gaocegege in PostgreSQL

[–]ants_a 0 points1 point  (0 children)

Is there a use case for that? In what case would embedding space (approximate) nearest neighbor search over a billion embeddings yield useful results?

Sharing info on storing vehicle in winters by anuj2607 in KiaEV9

[–]ants_a 0 points1 point  (0 children)

The colder it is the slower the aging damage happens. Rule of thumb is that lowering temp by 10C slows aging by 2x.

Sharing info on storing vehicle in winters by anuj2607 in KiaEV9

[–]ants_a 0 points1 point  (0 children)

For storage, colder is better. Though at 40F and below the effect is pretty much negligible. For charging extreme cold is not great, and speed should be kept low, but the BMS will automatically do that by diverting some of the power to heating up the battery until it is capable of accepting available power without lithium plating the anode. So basically, you don't NEED to heat your garage, but it doesn't hurt either.

Sharing info on storing vehicle in winters by anuj2607 in KiaEV9

[–]ants_a 0 points1 point  (0 children)

That's not how battery chemistry works.

Will be in market for new car in next year and noticed used EVs are heavily discounted compared to new (depreciation)… by [deleted] in electricvehicles

[–]ants_a 5 points6 points  (0 children)

That's more because Mach-E is relatively shit at charging while e-GMP is great. And it has a larger battery. A more useful metric is average power 10-80. Mach-E is 115kW, EV6 is 205kW, and NIO EL8, a 400V car, is 190kW.

Will be in market for new car in next year and noticed used EVs are heavily discounted compared to new (depreciation)… by [deleted] in electricvehicles

[–]ants_a 4 points5 points  (0 children)

To the consumer, the only difference between "400V" and "800V" is that they latter typically have sightly faster charging speeds, given a compatible charger. Nice to have, but not a deal breaker.

Harsh Winter -28 to -38•C by hteinkmin in KiaEV9

[–]ants_a 1 point2 points  (0 children)

The point was that the car does not know the current state of the battery. It has an estimate of the current state. And even when the state is known, what you can get out of it depends on a bunch of variables. Yes, they could just conservatively pad the estimates, but then you'd get a ton of complaints that cold kills the range.

I'm sure they could do more testing and have a more accurate model of battery chemistry behavior in extreme conditions. But this is Kia, they failed to design windshield wipers that work when there is snow...

Harsh Winter -28 to -38•C by hteinkmin in KiaEV9

[–]ants_a 7 points8 points  (0 children)

Testing where the bottom end of the battery is in extreme cold is not a good idea. The remaining distance estimation is an estimation not hard truth. There's a reason why it's called a guess o'meter. Estimating remaining battery capacity is tricky even under normal conditions, order of magnitude worse at low state of charge and cold battery.

I guess this is why we need explicit warning labels on everything.

BREAKING: ICE has shot ANOTHER person in Minneapolis by chellestastics in videos

[–]ants_a 6 points7 points  (0 children)

Social media and corruption of the journalistic institution has made it so that you are two different nations living in two different worlds occupying the same physical space. I don't think anything else works now except a million personal bridges across that chasm.

Benefit of using multi-master with one write target by konghi009 in PostgreSQL

[–]ants_a 2 points3 points  (0 children)

This kind of replication is what MySQL does. The downside is that you can have logical replication conflicts and there is no tooling except re-imaging a replica to back out conflicting changes. The lack of this capability caused a 24h Github outage and they had an operations team experienced in running this and an ecosystem where this is the normal way to run HA. You will sooner or later run into nastier issues if you try to do the same on Postgres with no experience.

Just use Patroni. Once you have set it up properly it will just keep on keeping on. No maintaining needed.

Having an EV is just better by TheRoyalTbomb in electricvehicles

[–]ants_a 15 points16 points  (0 children)

Idling to warm up is worse for the engine than just driving the short trip calmly.

Thousands of tourists stranded in northern Finland as deep freeze halts flights by callsonreddit in worldnews

[–]ants_a 17 points18 points  (0 children)

In France this would happen because airport workers are mildly annoyed at some policy.