Hacker News Board Hacker News, browsed like a classic message board
Live data from Hacker News

PostgreSQL Statistics, Indexes, and Pareto Data Distributions

making.close.com

Post reply on HN
Print view View original

1–9 of 9 posts

Re: PostgreSQL Statistics, Indexes, and Pareto Data Distributions

#3

Post by r34 »

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.

Re: PostgreSQL Statistics, Indexes, and Pareto Data Distributions

#5

Post by wojcikstefan »

shinzui wrote: post #4

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

Agreed, event sourcing is a pretty good match for call flows. You could first store every call leg / conference / recording / etc. webhook Twilio sends you as an event and then derive the state of the final "call" concept from those pieces of data.

Re: PostgreSQL Statistics, Indexes, and Pareto Data Distributions

#6

Post by wojcikstefan »

r34 wrote: post #3

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…

Good intuition and thank you! :) Not sure if this is a good fit for you, but you could consider using the partitioning built into Postgres to split one large logical table with all your games into a "hot" partition containing the currently running games and a "cold" partition containing your finished games.

https://www.postgresql.org/docs/current/ddl-partitioning.htm...

Re: PostgreSQL Statistics, Indexes, and Pareto Data Distributions

#8

Post by wojcikstefan »

azurelake wrote: post #7
wojcikstefan wrote: post #2

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

One of the best articles I've seen on here this year! I didn't know about the existence of `pg_hint_plan`.

Thank you very much! :) I still advise that you try really, really hard to avoid using `pg_hint_plan` if you can, but it's nice that it exists if all else fails or if you need temporary relief at a time of crisis.

Re: PostgreSQL Statistics, Indexes, and Pareto Data Distributions

#9

Post by r34 »

wojcikstefan wrote: post #6
r34 wrote: post #3

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…

Good intuition and thank you! :) Not sure if this is a good fit for you, but you could consider using the partitioning built into Postgres to split one large logical table with all your games into a "hot" partition containing the currently running games and a "cold" partition containing your finished games. https://www.postgresql.org/docs/current/ddl-partitioning.htm...

I will take a look, thanks :)
Post reply on HN