PostgreSQL Statistics, Indexes, and Pareto Data Distributions

  • Well, what came to my head pretty quickly when reading this was "there should be separate tables";) Thank you for the article, I didn't know about the statistic configuration in postgres. I can use your lesson straight away, as I'm desining a database for online gaming platform and now I'm sure that there should be separate tables for currently running and finished games:)

    Also: very clear and easy to follow language, props to the author. Cheers.

  • Hi HN community, author of the post here. Let me know please if you have any questions, comments, or feedback!

  • It’s amazing how many of those types of problems are easily avoided or solved with event sourcing and CQRS.