Re:An early look at Postgres 14: Performance and monitoring ...
by samsquire on Sunday May 23, 2021 @02:39AM
(#27252895)
Elasticsearch requires lots of hand holding if you have a cluster. Sounds like you're talking about a single instance.
Especially if an index goes down and you need to kick it to continue indexing.
Re:An early look at Postgres 14: Performance and monitoring ...
by Mike8435234 on Sunday May 23, 2021 @03:02AM
(#27252970)
We had a cluster. It was low maintenance. Any clustered / distributed database will require maintenance. At my current job we have SQL Server and there's a shitload of admin/maintenance required for that.
In our case for a small website serving the general public (a few tens of thousands of requests per day) it just worked OOTB with hardly any tuning or maintenance at all.