On 10/21/16 4:05 PM, Adam Brusselback wrote:
> My main point is that maybe the reason why most users use int4 pkeys
> (besides conventional wisdom) is because it gets the most support from
> features like this, and it may not be quite as skewed if that same
> support were given to other types.
I think it's a pretty safe bet that they're the most popular simply
because serial means int4 and not int8. I bet a fair number of users
don't even realize bigserial exists.
--
Jim Nasby, Data Architect, Blue Treble Consulting, Austin TX
Experts in Analytics, Data Architecture and PostgreSQL
Data in Trouble? Get it in Treble! http://BlueTreble.com
855-TREBLE2 (855-873-2532) mobile: 512-569-9461