SigmundA

9 ms·

91.
by SigmundA 8mo ago
Guess it works that way in China too...
92.
by SigmundA 9mo ago
So quickly that the dissociation causes the ignition, this is colloquially called an "explosion" : https://www.youtube.com/watch?v=5UsRiPOFLjk
93.
by SigmundA 9mo ago
In MSSQL Server part of the plan match is the various session/connection options, if they are different there are different plans cached. I believe the plan data structure PG is intimately tied to process space memory addresses since i
94.
by SigmundA 9mo ago
I have found very minimal penalty on secondary index reads in practice such that it has never made a difference. Remember some databases always use clustered index internally (SQLite, MySql) such that even if you have no primary key they wi
95.
by SigmundA 9mo ago
Not just maintained automatically, clustered indexes have no heap at all, the table is an index. The CLUSTER command in PG just moves rows around in the heap so they match the still separate index order which can help a little bit with rang
96.
by SigmundA 9mo ago
>If you lose the WAL you lose the data since the last merge but there’s no risk of corruption. That is not my understanding: https://www.postgresql.org/docs/current/app-pgresetwal.html >After running this co
97.
by SigmundA 9mo ago
Wasn't aware you could put a WAL on a unreliable storage system either without risking data loss? Would be interesting for indexes say put them on ram drive and rebuild them on restart if they aren't there just fallback to table s
98.
by SigmundA 9mo ago
You mean tablespaces: https://www.postgresql.org/docs/current/manage-ag-tablespace... ?
99.
by SigmundA 9mo ago
>in the very rare case where you're indexing the entire table (e.g. if it has very few columns). Not sure I follow most tables are accessed primarily in one way (primary key) while maybe sometimes in others for analysis. Having the
100.
by SigmundA 9mo ago
Would be nice if PG supported clustered indexes (Index Organized Tables in Oracle speak) as an option if you have a table thats accessed mostly the same way you can get a index without the write amplification because the table is the index.
101.
by SigmundA 9mo ago
Yes manual query preparation by client [1] is what you did in MSSQL server up until v7.0 I believe, which was 1998 when it started doing automatic caching based on statement text. I believe it also cached stored procedures before v7.0 which
102.
by SigmundA 9mo ago
>Currently, constraint exclusion is enabled by default only for cases that are often used to implement table partitioning via inheritance trees. Turning it on for all tables imposes extra planning overhead that is quite noticeable on sim
103.
by SigmundA 9mo ago
>South of Spain to the North of Sweden to take 50 hours, more or less the same. That would be like driving from Key West to Prudhoe Bay which looks to be 91 hours. Sorry the US is big spread out place, but I also agree it's not real
104.
by SigmundA 9mo ago
All the money managements apps (Monarch etc) use one of the big three bank gateways, Plaid, MX or Fincity. They all have issues mainly the banks want constant reauth two factor rather than just trusting forever. Mint was better they had the
105.
by SigmundA 10mo ago
There is 400 amp residential service you can get 80 amp 19.2 kw level 2 chargers. You would need 5 80 amp charger to approach 100kw but with other loads in a large house, I have seen large HVAC systems and elaborate pools with lazy rivers e
106.
by SigmundA 10mo ago
Newton meter as a unit of energy is not the same as the newton meter unit of force for torque. The energy unit meter is distance moved, while the force unit meter is the length of the moment arm. This is confusing even though valid, so the
107.
by SigmundA 10mo ago
A watt of power multiplied by a second of time has an agreed upon name called joule, but a watt second is also a perfectly valid SI name. A watt is a joule of energy divided by a second of time, this is a rate, joule per second is also a va
108.
by SigmundA 10mo ago
You must still commit the WAL to disk, this is why the WAL exists it writes ahead to the log on durable storage. Its doesn't have to commit the main storage to disk only the WAL which is better since its just an append to end rather
109.
by SigmundA 10mo ago
The acid in lead acid is sulfuric acid and if overcharged vents hydrogen gas, thats why they need a ventilated space typically. Sealed lead acid have safety vents that might pop if enough pressure builds. They are most certainly not inert,
110.
by SigmundA 10mo ago
Yeah so not sure why but Look around coverage is much better in Europe than the US for some reason which seems odd since Apple is US based. You can see the very poor US coverage here: https://brilliantmaps.com/apple-look-aro
111.
by SigmundA 10mo ago
In the US is has basically zero coverage outside any major city. Google on the other hand has exentiqive coverage into rural areas, albeit some of it old, at least its there, where it has newer coverage it usually has multiple one at differ
112.
by SigmundA 10mo ago
I mean in Google Maps you can drag the little man over the map and it has a map layer that highlights all the roads available, so you can easily see where it is and is not. Not randomly picking a point and seeing if indicator is available.
113.
by SigmundA 10mo ago
Hardly anything unless in a major city, no way to easily tell if there is any coverage other than randomly clicking until it shows, also doesn't tell you the date taken. Google street view has the 2d overlay letting you know where ther
114.
by SigmundA 10mo ago
Sorry I was considering a standard container ship voyage at 30 days. A 9m sphere of 1m thick Aerogel will probably cost above $500k just for the material. Also lithium hydride itself reacts violently with water, not sure if you want to have
115.
by SigmundA 10mo ago
How can you not realize that’s the point? Monopoly on violence is just that, the definition of the state. Anarchy is not a stable system, you have no property rights or freedoms without a way to enforce them. You provide no alternative, a g
116.
by SigmundA 10mo ago
Would love to see any data you have, what kind of storage tank on a ship could keep 680C lithium hydride insulated without significant losses for say a 30 day voyage?
117.
by SigmundA 10mo ago
Unless amelius is stronger than you, or has better weapons, or commands a gang that is bigger than your gang, then you can't stop them. Its almost like you need some sort of power structure with the monopoly on violence to enforce agre
118.
by SigmundA 10mo ago
Round trip efficiency would be very poor, looks like thermal storage is around 75% efficient for the heat then the heat engine (turbine) maxes out around 45% so maybe round trip 33% efficiency if you lucky. So that gives you around twice th
119.
by SigmundA 10mo ago
60 MWh continuous is nonsense because its a unit of energy, 60 MWh per hour is just 60 megawatts, 60 MWh per second however is 216 gigawatts.
120.
by SigmundA 10mo ago
Your math seem to work out, but I don't like the incoherent use if energy units. 60 MWh per what? Per hour? thats just 60 MW continuous POWER or 1440 MWh ENERGY per day.

More ›