> https://github.com/arp242/goatcounter/blob/master/db/schema.... - number of IDs is actually 7, not 6.
the point is that some/many of those ids are not timezone and country, and potentially can grow high in cardinality.
No, my point is you accused me of lying at the drop of a hat for no good reason, and that this is demonstrably not true. Don't try and spinelessly slime your way out of that. And no, they I won't run out of IDs for them. "Potentially" anything can happen, but it won't happen here. After five year the furthest sequence is 0.86% on its way of being full.
> my point is you accused me of lying at the drop of a hat for no good reason
I said you described fictional scenario, and it appears to be true, your table ID fields are very different than timezone, country and user_id.
What an incredibly rude and dismissive accusation. Here's my table: https://github.com/arp242/goatcounter/blob/master/db/schema.... – number of IDs is actually 7, not 6.
I can give a lot more details and context on all of that and why it works the way it works and the savings are certainly not insignificant and theoretical, but save me real money in server costs every month. But I have little interest in talking to you further since you're just going to insult everyone who tries to inject the slightest nuance into "always use bigserial"-extremism. So good day to you.