Hacker News Reader

My telemetry table is >2B rows and growing. 5B is starting to worry me; .5B, not so much. This is even backed by ( not much ) spinning rust.

Hopefully you don't have an auto-increment int (2^31) as a PK, or you'll be worrying sooner than you think.

That's one reason why switching auto-increments to bigint does help (a lot):

That is interesting to know, I have been setting my index's to bigint for a long time.

Ugh. No. This uses a multi-column natural key. I have a tendency to avoid synthetic keys when I can.