ants_a

13 ms·

91.
by ants_a 6y ago
I did some time series data benchmarking recently. Most large data is "time series" data, but I will not digress on terminology right now. For the usecase I was looking at my results for InfluxDB did not qualitatively disagree the
92.
by ants_a 6y ago
Fast charging is not really needed in cities where daily driving distances comfortably fit into almost all EV-s ranges. What is needed is parking space in residential areas with access to Type2 charging.
93.
by ants_a 6y ago
You're using terms to mean things that they usually do not mean. Calling superscalar OoO scheduling a jit-ed VLIW is misleading at best. The whole point of VLIW is that you don't need the control logic and, more importantly these
94.
by ants_a 6y ago
While environment variables are not the most bulletproof place to store secrets, a plpython function will be able to access environment variable via the os module.
95.
by ants_a 6y ago
There is no technical tradeoff here. PostgreSQL could add a batched, vectorized and JITed execution engine, and ClickHouse could add "relational features". Either one would of course be a significant engineering project, but there
96.
by ants_a 6y ago
I once read that using ZFS was supposed to boil the oceans.
97.
by ants_a 6y ago
Pointing into the head or away from the head are not ergonomically viable options. Realistically, if you are going to have a quarter wave antenna the product shape is going to look a lot like an Airpod, but not necessarily shaped as a white
98.
by ants_a 6y ago
To add to others, writing a file over and over doesn't do anything on pretty much any solid state storage device you would use for a database. You would have to look at something like a bargain basement SD card to find something that d
99.
by ants_a 6y ago
Qt can be developed with Python or JavaScript too. And there are other third party bindings available. [1] [1] https://wiki.qt.io/Language_Bindings
100.
by ants_a 6y ago
I am not. As I said this outgoing radiation is mostly balanced by incoming radiation. But it does illustrate the theoretical maximal capacity for radiative cooling, when stuck naked in interstellar space.
101.
by ants_a 6y ago
I think that the analogy is used because people underestimate how much heat is lost to radiation. Human body radiates energy away at about 800W. It's not noticeable, because normally it is balanced by a similar flux of thermal radiatio
102.
by ants_a 6y ago
I don't feel there is a significant time investment with using the builtin way. Timescale has some neat features for handling time series data, but for just sharding out data for scalability I can't see it offering anything substa
103.
by ants_a 6y ago
Why wouldn't you use built in partitioning for this?
104.
by ants_a 6y ago
I have a Beko upright freezer that the documentation states is fine until -10C. Probably around half the price of a similar Liebherr.
105.
by ants_a 6y ago
Bosch for example has a modular system where you can mix and match technologies. They have a 6 kW gas burner available in it [1] which can be matched up with a nice induction top [2]. [1] https://www.bosch-home.co.uk/product
106.
by ants_a 6y ago
To add to this, often the primary goal of the person who paid the security auditor is not to actually increase security. It is to get to claim that they did their due diligence when something does happen. Any arguments with the auditor, no
107.
by ants_a 6y ago
Patroni is a good choice for fully automated PostgreSQL HA. Depending on what you are comfortable with, you could either deploy it using something like Ansible on bare-metal or VMs, or with Spilo and postgres-operator on Kubernetes.
108.
by ants_a 6y ago
Average visual acuity for young people is about 0.7 arcminutes, best being around 0.5. There seems to be disconnect about how people are consuming media. For me holding a 2280x1080 6.3" phone ~8" from my eyeballs is a natural view
109.
by ants_a 6y ago
> How many more votes would the party in second place at the last election have needed in order to have won instead? It's a multiple party proportional representation system so who "wins" doesn't really matter that mu
110.
by ants_a 6y ago
That only tends to be the case for tiny loops where loop iterator updates can be folded into addressing displacements and that frees up an execution port needed for something else. If you don't know what you are doing unrolling is just
111.
by ants_a 6y ago
I somewhat agree. Not with the sweeping that declarative query languages can't work, for every case where faulty statistics cause a bad plan there are likely to be many cases where a statistic based plan choice correctly switched plans
112.
by ants_a 6y ago
"What if I want to switch" is a valid question if your business is at the mercy of a single vendor with a history of abusive business practices towards its customers. While I may have a selection bias, I have seen quite a lot of c
113.
by ants_a 6y ago
I don't think undo vs. heap based MVCC choice has any big impact with regards to transactional truncate, nor transactional DDL in general. You are likely to see proof of that within a couple of years.
114.
by ants_a 6y ago
All cost based optimisers rely on statistics being correct. And inevitably there will be a case where they aren't. The problem with PostgreSQLs optimiser, and I assume with others too, is that it's too risk happy. It's optimi
115.
by ants_a 6y ago
Agreed. Most people can't replace a wristwatch battery, but wristwatches are not considered disposable items. I don't see why similar approach couldn't work here. Non user-serviceable does not have to mean non-serviceable. Un
116.
by ants_a 6y ago
Most other electric cars besides Tesla were already using this.
117.
by ants_a 6y ago
In cold countries a typical new installation will have an air-to-water or ground-to-water heat-pump for heating with an integrated hot water tank (actually more like a warm water tank for efficiency reasons). Hot water is a considerable fra
118.
by ants_a 6y ago
Makes sense for hot water, but with central heating less so. The energy is mostly needed during the months when there is not a lot of sun, over-sizing the solar collector is financially untenable, as is large enough insulated storage to cov
119.
by ants_a 6y ago
Approximately 50%.
120.
by ants_a 7y ago
While I have no doubt that Redis is faster for slinging blobs around, that blog post is not great comparison of the technologies. Both Django ORM and Python psycopg2 driver are not performance oriented tools.

More ›