Re:PostgreSQL upgrades are hard
by cersa8 on Saturday June 25, 2022 @07:30AM
(#31874359)
CockroachDB and others come with huge downsides in performance and features. I keep trying to see of these databases are a good fit for me but just the sheer time it takes to import my database makes me shudder. I've used the Aws cloud hosted free tier of CockroachDB but ran into transaction timeouts on very moderate loads. There is a reason these databases aren't seeing massive uptake despite their lofty promises.
[ Parent
| on HN ]
Re:PostgreSQL upgrades are hard
by billythemaniam on Saturday June 25, 2022 @07:59AM
(#31874503)
Yeah CockroachDB suffers from the same problem as PG: the defaults kinda suck for certain workloads. CockroachDB has an additional problem that their documentation isn't as detailed as PG so it can be hard to know what to tune. TiDB and Spanner defaults are much better for a wider range of workloads.