Re:PostgreSQL 11 and Just in Time Compilation of Queries
by fiddlerwoaroof on Wednesday September 12, 2018 @12:25AM
(#17965543)
I have benchmarked a single Postgres node performing comparably to a six node Cassandra cluster on timeseries data (using TimeseriesDB). The more I’ve had to deal with the limitations of other databases, the more I’ve come to think that people should just start with Postgres and only pick something else if Postgres doesn’t work out
[ Parent
| on HN ]
Re:PostgreSQL 11 and Just in Time Compilation of Queries
by mmt on Wednesday September 12, 2018 @04:20AM
(#17966479)
> I’ve come to think that people should just start with Postgres and only pick something else if Postgres doesn’t work out
Even that standard results in people giving up on PG too early. It's possible to get it to continue working out, but it can require effort beyond a naive implementation and often more hardware knowledge than is common any more.
The other options can make naive implementations much easier, at least initially, and on almost any hardware. Of course, that usually ends up costing far more, even at modest scale.