Another great post from the Crunchy Data folks on using #PostgreSQL as the datastore for real time #analytics / #metrics / #logging (spoiler, they are not even using a huge machine).
Once again the Pousty Law of Database:
Start with PostgreSQL, then if you run into a problem, go back and read the docs, try again with PostgreSQL, repeat at least twice, ok now you can think about a different datastore
https://www.crunchydata.com/blog/building-customer-facing-real-time-dashboards-with-postgres
#IsThereAnythingPostgresCantDo
Once again the Pousty Law of Database:
Start with PostgreSQL, then if you run into a problem, go back and read the docs, try again with PostgreSQL, repeat at least twice, ok now you can think about a different datastore
https://www.crunchydata.com/blog/building-customer-facing-real-time-dashboards-with-postgres
#IsThereAnythingPostgresCantDo
Building Customer-Facing Real-Time Dashboards with Postgres
Postgres can be a great back end to powering your customer-facing analytics. Craig gives an overview of getting started with a metrics schema and then powering up to performance.Crunchy Data