3 ms·
I get what you are saying. I don't think you'll find a commercial database that does not have performance struggles of its own. If you need to do a large data
by atsaloli 2y ago
I get what you are saying.
I don't think you'll find a commercial database that does not have performance struggles of its own.
If you need to do a large data export, you can dump it off a read replica.
A big import, like you said, can be staged and then swapped into place.
Good luck. :)
- atombender 2y agoSurely they do, but some of Postgres' problems are architectural, and other databases with other architectures don't suffer from them. That said, this was not the point of my post, and I was hesitant to mention any concrete issues because I didn't want the thread to be about that, but rather the question of how Postgres today stacks up against commercial databases that are in use.
- atsaloli 2y agoAbsolutely. I see you didn’t get much traction here. You could try the DBA Stack Exchange. Or talk to the vendors.