On Fri, Jul 4, 2014 at 10:13 AM, hubert depesz lubaczewski <depesz@gmail.com> wrote:
How many rows do you plan on having in this table?
Currently, only around 10K, but there's expectation that the number will grow. It's hard to predict how much, hence the generous extra space.
Why this particular key range?
The requirements I've been given for the keys is that they be numeric, reasonably easy to type (hence, no 40-digit keys), never beginning with 0, and carrying no additional information content (or even suggesting it). Among the pieces of information that the key should not include is the relative time of entry into the DB (hence, the keys should be more or less evenly distributed over the 100K-1M range).
