4 ms·
That's been my experience as well. Postgres handles everything until you hit an edge case on some of your data (volume writes with scale out, performance critic
by brightball 10y ago
That's been my experience as well. Postgres handles everything until you hit an edge case on some of your data (volume writes with scale out, performance critical advanced functionality, heavy BI work with huge datasets, etc).
When you hit those edge cases or specific needs, you implement the specialty solution. Most people never come close to those edge cases though. When they do, PGs foreign data wrappers make the adjustment as smooth as possible.
- bsg75 10y ago> heavy BI work with huge datasets Because of single threaded query execution, lack of MPP, or something else?