Our great sponsors
-
-
InfluxDB
Power Real-Time Data Analytics at Scale. Get real-time insights from all types of time series data with InfluxDB. Ingest, query, and analyze billions of data points in real-time with unbounded cardinality.
My experiences are very similar to this. Hours and tens of hours for tiny DB re-creation (for 50-250GBs that's not the DB, it's the total of the files!), all local or in the local network (the DB itself on local SSD or even ramdrive), nothing particularly bogged down except sql stuff. Recovering 2-3TBs used to be like 3 weeks, from and to a local drive on the same machine and barely possible. Backing up the same is very tough, unless you increase significantly the default block size and still have a very nice machine. Generally the performance is really bad and many times what it could be, even simple stuff for example this one that's just checking the sha256 checksum of the files used to be 100 times slower than it should (I'm lowering my head in shame that I didn't fix it or at least report it myself even if I knew about it for years).