Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1bxh3d-0002XP-8b for pgsql-hackers@arkaria.postgresql.org; Fri, 21 Oct 2016 21:08:53 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1bxh3c-0000sC-Jh for pgsql-hackers@arkaria.postgresql.org; Fri, 21 Oct 2016 21:08:52 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1bxh3a-0000qe-Jr for pgsql-hackers@postgresql.org; Fri, 21 Oct 2016 21:08:50 +0000 Received: from mail-sn1nam01on0060.outbound.protection.outlook.com ([104.47.32.60] helo=NAM01-SN1-obe.outbound.protection.outlook.com) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1bxh3X-0007Un-RJ for pgsql-hackers@postgresql.org; Fri, 21 Oct 2016 21:08:49 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=BlueTreble.onmicrosoft.com; s=selector1-bluetreble-com; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version; bh=AGEfoLYXC8me/arW4HLgukJzhzulWhkojLiBwMzqZQw=; b=Otxqmata6toXMBUanjSUb9x1YwdLF/0fxe63xmPwRjLo+28yLp7IucXSz49YSALWmd9fD7CNiC4P+3cqgnQufkRgoRUJO5qmqJ/tM8vRrkkSeEWg+TbHLOKvU4WVYbJTBkoi5vclUT+M5Jpck9oLHAdkPvZktuxNJzICGR/6wlA= Authentication-Results: spf=none (sender IP is ) smtp.mailfrom=Jim.Nasby@bluetreble.com; Received: from decina.local (70.113.18.142) by CY4PR11MB1637.namprd11.prod.outlook.com (10.172.71.13) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_CBC_SHA384_P384) id 15.1.669.12; Fri, 21 Oct 2016 21:08:45 +0000 Subject: Re: Indirect indexes To: Adam Brusselback References: <20161018182843.xczrxsa2yd47pnru@alvherre.pgsql> <69b6a285-9afc-c224-4b0a-eefee3d8a4e7@BlueTreble.com> CC: Robert Haas , Alvaro Herrera , Pg Hackers From: Jim Nasby Message-ID: Date: Fri, 21 Oct 2016 16:08:40 -0500 User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.11; rv:45.0) Gecko/20100101 Thunderbird/45.3.0 MIME-Version: 1.0 In-Reply-To: Content-Type: text/plain; charset="utf-8"; format=flowed Content-Transfer-Encoding: 7bit X-Originating-IP: [70.113.18.142] X-ClientProxiedBy: SN1PR01CA0030.prod.exchangelabs.com (10.165.224.40) To CY4PR11MB1637.namprd11.prod.outlook.com (10.172.71.13) X-MS-Office365-Filtering-Correlation-Id: 2ffcefa5-0396-410f-6901-08d3f9f67203 X-Microsoft-Exchange-Diagnostics: 1;CY4PR11MB1637;2:Czajvskbh5pjQlHElvj1n5cffMnmzTEOdUKjCAn/0XbIcJq4gPDjhnaVD8jxO01Wn3mI2DJhRJ4z/YyOI/jUMq9/Yi4L+p4/fC9qFM7ZpSZIqTQsLYuOFXbcdOhGWSqEYTcqWW9Z1/mIntJCXkmTtOmZnEljU7PDYJVPHUyk9RancazWAvlfXrZ9ZDPThyjqtKsphGqEKM+u7don3OZi4Q==;3:DfF6q9a8jC2sx+ayhkHlUBMVOknrT6dfg6DGPiS1T/k7msBBM79gEquHI563tgpNQfh+8LPHcXLhC04vz5ruevAzQtNFfNIK7j2UEUx9nbVVzIPE1JeqO5A+qVKSQ4n0Mymvo5Je1SIzsiaxH3YSYw==;25:LWh4LjgYt6WoM+fuo36cqFNV/glQKPM1J8nSVOIR388/Gecv/tqwGf/pj0q9S8SELfjOE1jWOjsjSOUgwJr6gFFnqVLW5fLlhDnfwt0SUKkR8XbphT4yWSBC4ebUI9990OC94/fwWYDiAf3/NXqGRM0Ttwth8OTrbk6VNnNbOCPsauBpdBEq7HSYBwrvjX5jcweV8IPOP+5NdXTJJQoe4HekDdd7ICGo9vuC84tmK8gUCS2e6+m+tQfdOYQ7HgPhywnCaCaqkIpfP19L5su/Dhs4IcnWCCSUQ+KkOXbapO+Bg28NPEP+m0EAWhCb20nFYWRJUpyClTd88TjZ4GCpVwiQP3KfmgH/CxLxqZpBGTRJQHcw65H1Vla7snPjkVWBE+BA8+lsiYJ3QC++WzQLHb7PK3eyopFh/0W0NBJ/5tckcPxwReiXdXxyYeL57Q2f X-Microsoft-Antispam: UriScan:;BCL:0;PCL:0;RULEID:;SRVR:CY4PR11MB1637; X-Microsoft-Exchange-Diagnostics: 1;CY4PR11MB1637;31:XYEaPvysoyR4dWCq/FfM63S2o+Ss20fCtSq3WWRQGMkxTTAj6PVQ8FfTuIMP7HXGMFT508ZFo9waGa8YiNL6fuRAUkL82jb7tTfrZsbMdW0a/CWGH1d0pTuFKV/LjsrnJpjKbeib6TWcsC8NAm2JQa6DBJGQT04MLF5tn12ytxmwtHZTrvvXWHxTluzwfcWBNtub1x0sTFCCdtRnnSnomnAGxVeh9mp1SovzpR3IM8yCTn4ocyzKnUM5eTZW+Fdv;4:PIA6sJL9ZfI83efCB3g8M9980ThfcpZ3WvmMddhmz40rZ6htCGgLP3arekCbi3n5IVB/K2odVkVCE1KyhkSLb4sYlPFXYuIOipE1rCoEm3ExQy3mCB2aOBRfe8T6xrhrN24gLZZwsOlWXFKbQ6QIVa65rPBuQPwQrDjV3QRRWeOyYw1asSim7J2hG19+OBt4n6MryiZsz7lQFP4j6TfGQG1gYq/6M2Rg3/6UYXk9GKDElbsMd7s+rpF3bxCL2oh59dYH1R7zo+jCpTPF/yO3ihPPc3u1tz1/5Xh0jAiN8IlPe21ObiArlmu+Cl6y2lRlo1jv19BZ3kasMPjz0+jg36TW+rWAPVCChBd13dYqtZLiU0TKla+gu/Mp3QZ7yydazU0UncPtllARNQm6nKU2oKpgbsaBjEmsRmh2hI8pUwJhmmQoKZlvdHuSdhAxuItB X-Microsoft-Antispam-PRVS: X-Exchange-Antispam-Report-Test: UriScan:; X-Exchange-Antispam-Report-CFA-Test: BCL:0;PCL:0;RULEID:(6040176)(601004)(2401047)(5005006)(8121501046)(3002001)(10201501046)(6042046)(6043046);SRVR:CY4PR11MB1637;BCL:0;PCL:0;RULEID:;SRVR:CY4PR11MB1637; X-Forefront-PRVS: 01026E1310 X-Forefront-Antispam-Report: SFV:NSPM;SFS:(10009020)(4630300001)(6009001)(7916002)(199003)(24454002)(189002)(377454003)(50466002)(31696002)(47776003)(19580395003)(105586002)(76176999)(106356001)(6116002)(50986999)(230700001)(66066001)(86362001)(23676002)(6666003)(81166006)(68736007)(42186005)(3846002)(1411001)(93886004)(8676002)(81156014)(33646002)(65826007)(110136003)(7736002)(65956001)(305945005)(7846002)(31686004)(5660300001)(92566002)(189998001)(16601075003)(54356999)(586003)(77096005)(2906002)(83506001)(64126003)(2950100002)(97736004)(101416001)(15975445007)(6916009)(4001350100001)(4326007)(65806001)(36756003)(85282002);DIR:OUT;SFP:1101;SCL:1;SRVR:CY4PR11MB1637;H:decina.local;FPR:;SPF:None;PTR:InfoNoRecords;A:1;MX:1;LANG:en; Received-SPF: None (protection.outlook.com: bluetreble.com does not designate permitted sender hosts) X-Microsoft-Exchange-Diagnostics: =?utf-8?B?MTtDWTRQUjExTUIxNjM3OzIzOis3YncwdVhMTGZNNXo5dGNiUnhHYnRkUHQr?= =?utf-8?B?K2RBejR4R0Y2M3c5MHA1dVFZYW82L09OQVAvY3dzKytUWTZLdkdwL1BPS3J0?= =?utf-8?B?dlRIT1QxMUNPVnBBU3J6TUZjcEhmRlFXUE1JSU9uT3NyTjBsaXF6RElZZ3Jk?= =?utf-8?B?WnJ4M1RRZDIwQ0JDMHRlc1hSNEFIZ1AzOUpleW1HaFJrV2JvWHdyNmQ1N3Bi?= =?utf-8?B?azc0bDZURDMvWi9WOVZCcDdhekRPdWhMSWtSQmdiZjNENDRLTEtMUmpVVGdz?= =?utf-8?B?bnBIOC9ENEVETFRYNVJYekRFRnRQMGdZTThZakd6ekY0L1ByNzlXL3BPRy8r?= =?utf-8?B?TWVUbHdaeXNIWFR6WWgvTzRaMEl0WHljRVV1d1crN3ZwbHpWZUFwUjVNeExk?= =?utf-8?B?U3RsM3hpWFpQZ2kwc3lUT2tNOEpITzhjblVxU0lXeFZPaTkyV2lKeHVqUnhE?= =?utf-8?B?Z3AyMGNOai9LTGp6TDAvbGRlYm1VVXNwS0pObmhmZ2YxL1g1NGZsdTg3Myt6?= =?utf-8?B?eDFVYWZ3YWZFS2I3MUtXMUcycjVwcG5DTU1KUG9zRGlOZTFDVE5rbnBLckFT?= =?utf-8?B?WEs4Z2R1enZhT1B4c2dGQStVbDBlVjQxYU5PVkxpUWh1cFdhZGl3NXVJYXhQ?= =?utf-8?B?ZUlaOHFoanppRFdQV2E0ZTM4RWRvL0hWcUpJbm1sTkRTWGdRc1A2NHhReTV3?= =?utf-8?B?Uis3Z2R3Qm82RkQ1WVRIRzB5bHlSR3F0dXVTSEJ3akRPYitFYWhEKzBlMGpJ?= =?utf-8?B?L3IrRWJSWi9CUndYa204c0pDOVEwc2lNRHZSbXRweFBGMFhNUzI0NEZuMTlq?= =?utf-8?B?WDcrOTU5cFFiY1ROdkpiR0tQdjNGQ1JiTFk1U2t2cUJobkowRnBsN0lENnpj?= =?utf-8?B?clRBbmt6SXJDSGdoeG9xcnd1TW41WE9LOU85VmFKSGFRNXduekdKUmdtSllh?= =?utf-8?B?ay9xU0VnazArNHprdElqWGFCbWxHTFd6Uk5FbjVFY0dPcGJpbEtRQzZ6ZUJj?= =?utf-8?B?TW43a1FZcFNsUFVwak1qOERzT3p5WUFjRDZ1UmZsVHlYbWZKaG9TMmhIWUtI?= =?utf-8?B?TUxobERpVWdCR3VSUUpXUDk1WDVBdHBobGJoRHhkRnRHN2VzeDZCQ0JiUUsr?= =?utf-8?B?R3VkME5xY3hlT2ZuOFhnNUhTMGJqRS9SMXRydlVDVEJMTzV0U25KdkZwTGM0?= =?utf-8?B?K3hDZkpCWUJMeEh4aGI3aytWaFVoQmpGS1p6U2JxZEc2WFRSSFNxbkw1ZDgz?= =?utf-8?B?aVZiVVE5NWFRT1VhMVE0MDF0NExGdUw2ekZJOGkxYVY3Q1BGRHJmRE5jSC8r?= =?utf-8?B?T2cxOXNQSjIvQmZIM1NvaDFqck91NEloZjV1dW5zNk5pODR1cW1Qbm5pVm82?= =?utf-8?B?QVg4T2dkbWRoS0NPdUlyTTNtbkYzUit6NmZEdFFGaDBQVVl3TnlDK3NPSDdO?= =?utf-8?B?MS91TlZyVmFHa01HQTRLcUJSRDZFM0g3REpLelYwYTgwMjZ1Y2lJbFl5N0oy?= =?utf-8?B?VUttM1hBRlpMakZ3Uk9ONStkR3loMElvanl3RmlETHZTZGNGK2llSnkxQmUv?= =?utf-8?B?eTNGWVM5d0I1V04zUm5KT2dNdkJwbkJCNHZWQ0xnZVB4WHJaYlNNZ3RoNDM4?= =?utf-8?B?WkFTODE2WnhnQmVoNWY2Z1F4MFRaR3hMSFc4UUU4WEs3SDFOOFhVblRuZU5v?= =?utf-8?B?N3owMGpJS2xBMUZoWHNhS1ZCSzd4eVluNDN2MlhUMGxQdWxLSmxqK1ZORUt3?= =?utf-8?B?c1FzUldkOTJLL1NjN0svQ1MvYVkxdmNyZjR6alM3WGlWU2daUU9PTUJYN3hs?= =?utf-8?B?a2lRMm1RbDNmSWdtWGg1S3YwWkRuaEdFRU9wOTFHREpGMVg0OGFVelU1S1dC?= =?utf-8?Q?Jqqwcq3URZXjEdSvAtnedEmADuC1Y3dj?= X-Microsoft-Exchange-Diagnostics: 1;CY4PR11MB1637;6:xW2D9aKTZoctZk/d311VT7xiW+hBUwPKVqCGmYwR4CxWdcWNYnRO8XhoOqgR+o1sCMNms0Q8Y21v/9TobM76njcudV51Z2nX9GiKPm/gkjzjKDS8IrrjUGzHgfsgBBY+9tecyX7Bd/A8edsAZsfizyk6G7Q30qUlAxgyBFX5cMP1RRMHi8AVUYCpyTwmu49Ha1Vr7+lkE+0uSSTU+/o4E+GXf/gmpJMB0l2o8rvu7vEH4boMkVE4FHRhqeoo6tnz2bVb4xYICLjILKqh4m5CKP5zf3+waen+Dnh4iMI9uRsvHGna1enlvo4JXyETXMdKgN0pXZYddoheW8R/knCfAA==;5:hp+NsgY5iM9N7gsW9n6fK3l0Deqgpj1O40I7HCgQPNmO8T/gLYj8iUmeTaY6LLTy32vlQqiiJ1FdetsB5MrsaPAo0RrxETBSNtpdeClPu3HoaaCOr3Euvbhr2zIiLrnnTj5f3gE9A2MH1F7JS21mjbF//amBcwcwda4VIA/fzQA=;24:W3KS1g+89zJCDphNOmkjEW8rqmDzkNA2xeS0HPQlQYDnfSFHfwKdAoCoNX1ZoktZZSdiMJMrZ+Odh5Y3QBAqTTem9GZY8vc8d5RrO6zX9o0= SpamDiagnosticOutput: 1:99 SpamDiagnosticMetadata: NSPM X-Microsoft-Exchange-Diagnostics: 1;CY4PR11MB1637;7:0LjJAlEyKaJ9u13VtEnG8hBhOEAk2cm13zkm2lyym9nmQ4PDHb6FJVR/eN2qRaBsE5SkwyhH2PutiHv5jyImDKBFp8NfiuvR+qIn8z2Ty8jLwEpJsh3A4ArijqJyyiNCzHJ0oI44e8zgQ13zBe3mse4GFcWFI0W/sGq0aNswJRJuUlvqi8pW2aF7CKUbenurWlDYv2JhTzmxFJgc7OWxcknnlVLlYacwHIGDMdCi9RCtFu47VV7/m6Z8vzJ5YEfh9P/83N4ERwzYsaESzB5EgKplLM5I8eF3S4FOndXJkURH25GdNknkZSrrZ1hBXo60oATXz5SZ/PCQEdm8fYAEWkEjsUMJTJ8tHhHICr81An8= X-OriginatorOrg: bluetreble.com X-MS-Exchange-CrossTenant-OriginalArrivalTime: 21 Oct 2016 21:08:45.5816 (UTC) X-MS-Exchange-CrossTenant-FromEntityHeader: Hosted X-MS-Exchange-Transport-CrossTenantHeadersStamped: CY4PR11MB1637 X-Pg-Spam-Score: -1.9 (-) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-hackers Precedence: bulk Sender: pgsql-hackers-owner@postgresql.org 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 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers