News for hackers. Stuff that matters.

A comment on Our Journey to PostgreSQL 12. Parent comment

Re:Our Journey to PostgreSQL 12 by stickfigure on Monday January 25, 2021 @11:27PM (#25912546)
That's an incredibly large amount per user? I have worked on a couple online dating sites, including one that was fairly popular (Let's Date - which stiffed me for my last invoice before they went belly up grrr). Unless you're storing images in the database, it's really hard to generate 600k for a dating workload - even with indexes.

The only thing I can imagine generating 600k per user is putting something like "hit tracking" in the database. Which I've done - yes it adds up - but it's also relatively easy to move to some other kind of store.

[ Parent | on HN ]
Re:Our Journey to PostgreSQL 12 by curryst on Tuesday January 26, 2021 @10:20AM (#25916728)
If messages between users go into their main database, then that would be a pretty reasonable amount.
[ Parent | on HN ]
Re:Our Journey to PostgreSQL 12 by stickfigure on Tuesday January 26, 2021 @11:03AM (#25917342)
600k is a sizable book. The Adventures of Huckleberry Finn is 600k. And that's the average per-user; most users will never send or receive messages.

The only thing I can imagine is that they do an incredible amount of activity tracking.

[ Parent | on HN ]