Re:The Art of PostgreSQL
by stingraycharles on Wednesday August 21, 2019 @09:53AM
(#20757136)
As someone who works for a high perf timeseries database (QuasarDB), the first thing I tell potential clients is to solve the problem with PostgreSQL.
For people who are still exploring their problem domain, using something as flexible as Postgres is a blessing. You’ll be surprised how far you can get nowadays in terms of performance with it.
Only once you properly understand your problem domain, and more precisely the limitations of PostgreSQL that you are running into, you can start figuring out your actual requirements and look for an appropriate database that goes with it.
(Not relevant if you need to process transactions.)