238 karma · joined May 17, 2011
In short I can imagine the trade-off of less-optimal support for some edge cases like these.
This is quite the statement and inconsistent with your later point. Postgres never updates data in-place, and certain workloads can never be as fast on Postgres as using a different storage engine such as MySQL/TokuDB.
We're running a setup that employs postgres for a write-heavy (but far from write-only) application, and are experiencing similarly troubling vacuum jobs. We're considering moving back to good old MySQL because of it. Anyone who's been here before and has some insight?
In my experience, 9/10 production use cases are covered using a path as primary key with prefix matching (select path,data from tree where path='a/b' or path like 'a/b/%') - as a side effect your subtree nodes will often be on the same table page (mySQL by default, pgSQL when using CLUSTER).
[1] https://code.google.com/p/chromium/issues/detail?id=272416
The interesting thing in posts like these, I would say, is that everyone puts in the "classic" Wall street boys comparison. Are they really all unhappy, money unconsidered? Is money their only measure in life? Sounds rather generalizing to me..
But more formally, a self-hosting compiler says stuff about the language per se, see also http://en.wikipedia.org/wiki/Bootstrapping_(compilers).
I for one think that people ought to take stuff less seriously, and this writing style seems befitting. Way to go!