Horton

Re: Indirect indexes

Jim Nasby <jim.nasby@bluetreble.com>

View thread View on postgr.es
From: Jim Nasby <Jim.Nasby@BlueTreble.com>
To: Adam Brusselback <adambrusselback@gmail.com>
Cc: Robert Haas <robertmhaas@gmail.com>, Alvaro Herrera <alvherre@2ndquadrant.com>, Pg Hackers <pgsql-hackers@postgresql.org>
Date: 2016-10-21T21:08:40Z
Lists: pgsql-hackers 
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

Commits

  1. Change some test macros to return true booleans