HN user

jeltz

7,814 karma
Posts17
Comments3,463
View on HN

Ok ... you know PostgreSQL supports hash tables in shared memory, right? PostgreSQL could in theory share those if we wanted to. The issue is just that coding anything which uses shared memory is a lot of work.

Additionally the reasons PostgreSQL does not offer Clickhouse performance has very little to do with parallelism. PostgreSQL plans to move to threading but the efforts around imporving OLAP performance are almost entirely unrelated.

Some, but not that much. Switching PostgreSQL to a threaded model will not magically make spawning connections fast. PostgreSQL connections are quite heavyweight.

The reason to use threads is almost entirely about ease of development, not about performance. If you use shrared memory like PostgreSQL does you need to write your own allocators, etc. So much you get for free if you use threads.

Stop Using JWTs 1 month ago

I agree with your first part but your edit is a logic fallacy. I don't need to be able to hack something to say that it is insecure.

For example: I don't know how to exploit SAML but I know it is a terrible standard dur to making all of the XML parser an attack surface. I am not a security researcher so I dont know how to find exploits in XML parsers but I know having a huge attack surface is bad.

That is true for software engineering in general. If you have a manager like that nothing is fun. And the products you build are likely to be bad.

Other than coal gas being not very efficient use of coal what was so bad about it? Stockholm still had coal gas in the early 2000s and accidental carbon monoxide poisoning was very rare. Of course the alternatives are better, but only marginally so.

It is also a bit tricky tradeoff. You do not want to be stuck with the same data format forever. So databases like MySQL and PostgreSQL need a downtime when doing a major version upgrade. They both try to keep it short, usually seconds, but minutes can happen in either database.

I have not ran MySQL for some years but it at least used to have exactly the same issue. Upgrading a database with MySQL can take a long time if you have many tables. The main difference is only really that PostgreSQL does it with a separate tool, pg_upgrade, while MySQL does it as part of the main binary.

For both MySQL and PostgreSQL you will need to use some kind of logical upgrades if you want no downtime.

Sorry, I was unclear. With that I did not talk about this particular deal. This particular deal seems sane. XAI built more compute that they can use themselves since Grok is not very successful so to not just have the hardware standing there they rent it out to competitors. Makes total sense.

It is other things Musk has gone with Twitter and SpaceX which are shady.

Their satellite internet business is the only thing which makes them money, which is enabled by their orbital launch business which is as of right now not profitable and I have no idea of if it ever will be but without it they would not be able to launch enough satellites.

Their stupidity with AI and buying X mostly seems to be about scamming investors to make Musk even richer. Like this particular deal is just them doing what CoreWeave does at a SpaceX valuation.

Yeah, I am employed by an open source company (to be clear not open core) and most of the external code contributions we get are a net cost for us. It takes more time to review than it would have taken for our team to code and review.

The real value we get from being open source is high quality bug reports and trust from our customers, not the external contributions. The only reason we welcome external contributors is marketing and generally being welcoming. If LLMs make this cost even higher for us then we might have to stop accepting external PRs.

But apparently trying to distinguish those from the 'one-shot' vibe coded PRs is too much work for the Ladybird team.

Yes, that is exactly what this announcement is about. That it was too much work for them to tell those two apart.