Hacker Newsnew | past | comments | ask | show | jobs | submit | more SigmundA's commentslogin

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.


Looks like Qualcomm X62


Your quote lists mobile deployments, their bullet point also says:

>Built for rooftops, remote sites, and vehicle based setups

They are insinuating if you actually read their press release then you would not state it was targeted only at stationary deployments.

Based on the spec sheet 2 out of its 6 antennas are directional, this is probably a 4x4 modem so it must have some way to switch 2 antenna from directional to omni.


There are range gains to be had from using a directional antenna. If you wanted to install this on a vehicle you could put it on a mount that rotates towards sources of a set frequency.


The spec sheet mentions 6 antennas and implies only 2 are directional:

(6) Embedded cellular antennas, including (2) high-gain for downlink: peak 9 dBi, 85°x85°

Typically these modems are 4x4 mimo so it must have some method for switching the 2 directional with 2 of the omnis in it based on which ones is needed.

https://techspecs.ui.com/unifi/integrations/u5g-max-outdoor?...


Interesting, thanks!


I wonder if PG will ever implement plan caching like MSSQL so that the speed of the optimizer is less of a concern and it can take more time finding better plans rather than replanning on every execution of the same statement.


Postgres used to have plan caching inside the same session, and that was so disastrous that it was limited severely by default.

Plan caching is very much a two-edged sword; cache too aggressively, and the situation will be different between the runs. Cache too little, and your hit rates are useless.


Not sure how that makes sense, if the stats change significantly then caches would be evicted during the gathering of statistics.

I believe popular connection poolers and clients attempt to do plan caching through prepared statements and keeping the connection open.

My understanding its not easy to do in PG since connections are process based instead of thread based and the query plans are not serializable between processes, so they cannot be shared between connections.

MSSQL has been doing statement plan caching for at least 20 years and it did stored procedure plan caching before that.


SELECT * EXCEPT(col_name) next please.


This was also discussed at the last SQL WG meeting but was postponed for further refinement. But it’s likely to be added soon.



Yes it needs to be in the standard though.


That might be nice for manual experimentation, but for application use, this seems brittle compared to specifying the columns you really want to have and process.


Who would have thought health care and retirement is more expensive than wars, it seems like that should be telling us something about priorities.


Yeah I mean they could pay for the new ballroom or two and have some money left over by not feeding those scammy undeserving people.

Or even better we could give some more money to Argentina.


Brilliant logical fallacies


Avalonia is also working towards using the new Flutter rendering backend Impeller which is being used to replace Skia, which is used by Chrome for rendering, turtles all the way down:

https://avaloniaui.net/blog/avalonia-partners-with-google-s-...


First time I heard of this was in Blindsight, and every time I use an LLM it just makes me think of the crew talking to Rorschach.

Intelligence without consciousness...

https://www.rifters.com/real/Blindsight.htm


Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact

Search: