PostgreSQL is quite terrible at OLAP, though. We got a few orders of magnitude performance improvement in some aggregation queries by rewriting them with ClickHouse. It's incredible at it.

My rule of thumb is: PG for transactional data consistency, Clickhouse for OLAP. Maybe Elasticsearch if a full-text search is really needed.

This. Don't loose your time and sanity trying to optimize complex queries for pg's non deterministic query planner, you have no guarantee your indexes will be used (even running the same query again with different arguments). Push your data to clickhouse and enjoy good performance without even attempting to optimize. If even more performance is needed, denormalize here and there.

Keep postgres as the source of truth.

I find that postgres query planner is quite satisfactory for very difficult use cases. I was able to get 5 years into a startup that wasn't basically trying to be the next Twitter on a 300 dollar postgres tier with heroku. The reduced complexity was so huge we didn't need a team of 10. The cost savings were yuge and I got really good at debugging slow queries to a point of I could tell when postgres would cough at one.

My point isn't that this will scale. It's that you can get really really far without complexity and then tack on as needed. This is just another bit of complexity removal for early tech. I'd use this in a heart beat.

It’s simple high throughput queries that often bite you with the PG query planner.

Redis, PG, Clickhouse sounds like a good combo to scale workloads that require OLTP and OLAP workloads, at scale (?).

SEEKING WORK | Eastern Europe | Remote: yes | Travel & willingness to relocate: Depending on the place

Technologies: Ruby on Rails 4+, React.js & Redux, Webpack, Bootstrap, Semantic UI, Typescript, SQL.

Résumé/CV: https://www.linkedin.com/in/zernie/

Email: hnewsrails@boun.cr

Github: https://github.com/zernie

I'm currently working as a senior full-stack dev on a startup that has already raised more than 3 million USD in investments. Contact me immediately if you have any questions or proposals, I'm always happy to chat.

Location: Eastern Europe Remote: Yes

Willing to relocate: Depending on the place

Technologies: Ruby on Rails, React.js/Redux, Rspec, Typescript, SQL, CSS;

Résumé/CV: https://www.linkedin.com/in/zernie/

Email: hnewsrails@boun.cr

Github: https://github.com/zernie

I'm currently working as a senior full-stack dev on a blockhain startup that has raised more than 3 million $ in investments. My hourly rates are reasonable and negotiable.

Location: Eastern Europe

Remote: Yes

Willing to relocate: Depending on the place

Technologies: Ruby on Rails, React.js/Redux, Rspec, Typescript, SQL, CSS;

Résumé/CV: https://www.linkedin.com/in/zernie/

Email: hnewsrails@boun.cr

Github: https://github.com/zernie

I'm currently working as a senior full-stack dev on a blockhain startup that has raised more than 3 million $ in investments. My hourly rates are reasonable and negotiable.

SEEKING WORK | Software Developer | Eastern Europe, Remote / visa sponsorship / travel possible

Skills: Ruby, Ruby on Rails, JavaScript, React.js, Redux,

Github: https://github.com/zernie LinkedIn Profile: http://linkedin.com/zernie

I have more than two years under my belt working as a remote Ruby on Rails/ React.js dev. Currently working on blockchain-based projects.

I use the following tools & technologies on a daily basis: Ruby on Rails (4-5), Rspec, Capistrano, Capybara, React.js, Redux, jQuery, Stimulus.js, MySQl, PostgreSQL, Boostrap, Semantic UI.

I prefer part-time positions with 20-30 of hours work per week.

Email: zergetaev[at]gmail.com