Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1bxgjo-0000xu-Fi for pgsql-hackers@arkaria.postgresql.org; Fri, 21 Oct 2016 20:48:24 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1bxgjo-0004jR-2O for pgsql-hackers@arkaria.postgresql.org; Fri, 21 Oct 2016 20:48:24 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1bxgiQ-0002r4-Hh for pgsql-hackers@postgresql.org; Fri, 21 Oct 2016 20:46:58 +0000 Received: from mail-by2nam03on0078.outbound.protection.outlook.com ([104.47.42.78] helo=NAM03-BY2-obe.outbound.protection.outlook.com) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1bxgiM-0007xg-IW for pgsql-hackers@postgresql.org; Fri, 21 Oct 2016 20:46:57 +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=TOhdCXaGXWUQeEtIDLIuvFwjsleR7IVQjgey45tpQno=; b=L0m1KKeyd3IzE0hWd67my59rNHGTO9UcIQgcJME+RPvl5OE7Bsgb0q9gIvxkc1ooOim9U3v469a8EeihfgEQjYbTSjtqZxTgFUypU/bfY0xZFOCYh1zAvQKvh6PHwr1YA+yR0++7kHKUgCmbDh5Tp5oD8QIvTDUyR8gnscNaeyo= 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 20:46:50 +0000 Subject: Re: Indirect indexes To: Robert Haas , Alvaro Herrera References: <20161018182843.xczrxsa2yd47pnru@alvherre.pgsql> CC: Pg Hackers From: Jim Nasby Message-ID: <69b6a285-9afc-c224-4b0a-eefee3d8a4e7@BlueTreble.com> Date: Fri, 21 Oct 2016 15:46: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: DM5PR17CA0044.namprd17.prod.outlook.com (10.173.128.158) To CY4PR11MB1637.namprd11.prod.outlook.com (10.172.71.13) X-MS-Office365-Filtering-Correlation-Id: e155099e-59db-443c-d8dd-08d3f9f36211 X-Microsoft-Exchange-Diagnostics: 1;CY4PR11MB1637;2:VVmSdZk2eVpMKEgLWBVLqg1g2WZ2s8L9vVoIlejw1QcGs9xNPTIDqZfeYUBVthBPTyOO+pOP0Kh4anl0904cbwnOs6qrT1rY6ck1T/g1RtO7+Ba+ZVhLBSAs4Kq4inSshQZII59JNmVB3d/T10bFu2ZtGdgBZWLeVro3CxzhZnCpk0wsG08Sgry99tKNoIdIbafUUOL0VSABQ/pM1GOcwg==;3:YFGZjRRCPdOw8HbdUqW2y+zezXPLEJ5+Wgs1REw8GpWJkdIUYZ6otuepdBoG+v+UyWC8PCX40HwNjqOAT0xnUqdRVMpo+5EKm75gDY+DsOb0nTT0F9UxJM8kUBYoShmTjwB/WGzKVEttG8XtEaEMBg==;25:OxWOsUWDnevpY8t0JJ20nnDsokCOCZrEG5w7fjFP4obdA5RdKy8Xyi4jkPLsH1F3/zOS6B+7jT7FtRlJ9gcM/pAxlmvaYow0Aj68yxr+GZxT3bmhLFkqcsbm2rtuvJBCnrKDxX0UuONhfH1jkUqnGMOnaNWdfR5ml7TyKUK1W7kB6kTFJPjeyhzUJjYLFOq1A7+NUsOvT9y3jtgQvZNUywWiY7ynr8SBL+Z05YKdcvAsG8gjekRob5w75y/X8+AJKm1XCAq8JiXcgVJ0Zq6Zxlr4tDBEBDW8ivjhq511V+vrrV8O+dKN25c6znz+yUG4yXqDkjvRP7RWzbairx085pDN3m0eVJYOzDt2oEfr/kQBzmhxE6HvysWYt8znaF+G3hhhhlmri/XiboN3qX6w4CxDqvTJBM4peENufu4jRzwLfJhMfsV+MOqfmvhTqleX X-Microsoft-Antispam: UriScan:;BCL:0;PCL:0;RULEID:;SRVR:CY4PR11MB1637; X-Microsoft-Exchange-Diagnostics: 1;CY4PR11MB1637;31:VLhN6SSimv7gIESzF1TbPtd15vOLjKKYwrOfhbguN+ptP69c1JGgSXFAAW31JU8ut0b+X3SsSndFH4iVbOM5/g807mmkazGkztaS+aWJeVsYrByVSZmG65MigQrgjQ5nJOpnKFBp9a55uSppoJXIEiZqxces51N9QUe5Hk6nPGJ/WRWLHKd3ukkphE/Ae1wBBUJA9/m9CN8WHrUHFyu/EPgCmuEbY1Bysi1DTy4lr6TavCcZWKVAs+BOF1Gkmm4P;4:TvrwePQaIpLkZtnZERDPaSK4VBhmnxPFHFfRJM8fDUrIO57x6ORsi3kaBcf6NdwVb23OyU0ZIhjf2nV/CvsobXfdlqHNJlALsHm3okd3G9bUM2NU2tkjb2hvO/ZYgHIdTc6qN09q18vOHusLjfFSs1r+XIp0UBB5MJY+ipQjR4AaSIP7VPnY+MZGyR4thcbzMuBjYCpGKYnCgResMdNSYjWs8DqDJofssB5HuGa0evrwl347QYbnhJq6i2pVTJXTrqj202O+Ut+FSot1qL2r5V0xY60Hr6ZOfDbPMBxdln/0WsAeVEYqeTDC2rfriUyqVMWELdUYXFC91vqEWQKY1x/xtBQ09XlyhsajdQXIzIz84DrP835Ao1w0MsE0P5SyhyR2Cn1JDiZhedDP7/VEzKPPVaNXO0tbf6OHDjmXOkN0rZQVOTW2lD3LEboluOTt X-Microsoft-Antispam-PRVS: X-Exchange-Antispam-Report-Test: UriScan:; X-Exchange-Antispam-Report-CFA-Test: BCL:0;PCL:0;RULEID:(6040176)(601004)(2401047)(8121501046)(5005006)(10201501046)(3002001)(6043046)(6042046);SRVR:CY4PR11MB1637;BCL:0;PCL:0;RULEID:;SRVR:CY4PR11MB1637; X-Forefront-PRVS: 01026E1310 X-Forefront-Antispam-Report: SFV:NSPM;SFS:(10009020)(4630300001)(6009001)(7916002)(377454003)(199003)(51444003)(189002)(24454002)(189998001)(16601075003)(54356999)(92566002)(5660300001)(586003)(31686004)(7736002)(65956001)(33646002)(65826007)(7846002)(305945005)(65806001)(4326007)(4001350100001)(36756003)(64126003)(2950100002)(2906002)(77096005)(83506001)(97736004)(15975445007)(101416001)(5001770100001)(6116002)(105586002)(76176999)(106356001)(230700001)(50986999)(50466002)(47776003)(31696002)(19580395003)(8676002)(81156014)(23676002)(6666003)(86362001)(81166006)(66066001)(3846002)(42186005)(68736007)(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?MTtDWTRQUjExTUIxNjM3OzIzOkZzUUNaOWdCVmFmU2RmY213MTN1QzdwdEl1?= =?utf-8?B?dXdjalQ0UGJGNmVVdTZEdnJ5RHBJdDJpMEo1QzFoMHc2dlgwcnRNeUpiVjhn?= =?utf-8?B?SWZGZW9KTnFjaldJaHQ2dDMxSmJMMHJzdTVNcUFVV29kRVFWUHYrdWFmUUdD?= =?utf-8?B?WmcrWVQvRG9HKzlWZXIzcldHcHp0dTBYMWQydks1SDY0L0wyTXNKTkRJaU8y?= =?utf-8?B?M3BmdEU0TWtVSXhJSVk3bmFJNnNmeThici9CdktTMFhxemZoVlQ0bmh6QUFZ?= =?utf-8?B?MGFLQ2RXTEdmcGR1REdIeUxFMldLY0o1eW0zRFJRZmExZFE2R25CRXM5TzdC?= =?utf-8?B?VUF6cFBKcUwzeVpYZUpCZjlRdk56WFZkVjlTNzA2TU0xZEUzR0hNMVZFaHJN?= =?utf-8?B?OWFmdEUwSXV1SmpidVFsb0lhS1ZWY3pXZWgwR3NEdEFCdU55a2xlWGxIRjdH?= =?utf-8?B?T2FyREJDeUwzVy9pRXB0cklJQ2lOSXgxQ25oU2M5WVFMNDJaa2xlVzVDWWts?= =?utf-8?B?UERIOENzZ0V0RityV2REbGNvMk50ZDY5VnlFaTZUdUsrTGpuTy83VnVuQUR4?= =?utf-8?B?VVA2NkwweC9EdkNaU1hDakVKcTQvdlhvTWwxZjRxU3dqT21nQjdnakQvNzBP?= =?utf-8?B?bFpRbnJaSjlZUkMvTVZuak80eE1SRFF3dVNUS0FGV2dPYVozcjFlU1NncWY2?= =?utf-8?B?RDFhOEZVdXVyREtkZDNvVC9nL3JWL0pGb2RtOEpzZEZzVFpPVkdxVThDY0tW?= =?utf-8?B?ekEzNFNjN2R2TE1zQXExZjZ2YWNLekwxQ2Q3TlNBMyt1djJjWEVGWmJUVjJQ?= =?utf-8?B?cW1KZnB3aG1QQkZ3bjNXd2J3TEUyaERlK0krK1F6OTFFYkpsOWtqQjVyUE5v?= =?utf-8?B?V0U0eU1hNXFRVURYWlR6a3ByZk10c0ZwZkNXaUhCeitDYUtIVmFxYW85WVZ5?= =?utf-8?B?UVp4dDZocWVDUCtXbTZ5eElYUmlteG5PbkhvMldmcmRUNnY2QlQ3aDRMY0k0?= =?utf-8?B?UHQyZEx4bGhhWEFCMjlaU3hwemFrTXR5UFZtdnVTazIxY2gvbE1EanBLcmtn?= =?utf-8?B?N1BlQ0U4OGd3Tk5iZG5WQXdxbDFsZ2xScEZtZjZIcjVobGFtS3RLZ0ZHUDd3?= =?utf-8?B?aC9Dd0lSbkhpM1hWSGNDcEljaWxIMzFGNTQzY0dvbDQ0T0JXRGw0dWkvWkhk?= =?utf-8?B?MDZtUHpoUW16Rk5TNE56MUxFVmgvS05NK2wwc1BVcUtDc3plUWxsVzFua3pE?= =?utf-8?B?Sk1SeWVaUlhsSm9OUGVFQ1lHVi9uakNvV3pweWhHejltS0ZGZDlDYWNOcGxw?= =?utf-8?B?WVN6RnBQVnAxMWwwVWgwR3J5REtZWUJvTjFab0c0TVNBRVhlZTF3Q0Y3Mnd0?= =?utf-8?B?T29FYm9LcTUyTXFGVWRhQS9scE5Id09ZUVNmMGFBUlhiZUtjVHZWcm1sNU4w?= =?utf-8?B?ekg3NTBFV2Z1VXB6ejJtc3c1RFhvY094L1Ezcmp4anZRYWZZbVBSdXdwdi9h?= =?utf-8?B?bXRjbVZlY1I1clZCNUt4clE0aTlvZUFoT3dtNmVFSWN4Nytva095bE1XbDhD?= =?utf-8?B?emx1bWpGWFRGcmxyc3pvT3pTekxheGd0aFBUaVR5U1ZuNEw0dDRsYWl3MHZr?= =?utf-8?B?d3dyT1o4cHRQZlpHakxEemMwNnpkdmN2ZUwxbWZhbHl2UVhvQmd6UlhMbHcr?= =?utf-8?B?SEFJMGxVVllQSjUvMUxtYklGVlIwNlk4bkVQakFiZUwxek42a2JtSHBOaVVF?= =?utf-8?B?OHVQTDhrZGU2WmR1ZVl4Z01QQ2VvUDJhRFdscVMyN09QN3pZRG5VWWhXV2l3?= =?utf-8?B?QlRnSTJqVEl5VlZHTUZnVGJKcW5wekVLRDMzUWhRZ081bHVIN0tMeWErZldk?= =?utf-8?Q?LsyFQEDSdY4=3D?= X-Microsoft-Exchange-Diagnostics: 1;CY4PR11MB1637;6:syrivnLK3R6HpxiEjux/SL2dH91DjE6bbJmHBoCgVVRRvHr8xukEy+02uR8d/58YZ+yV7XwbmLn1S24R9UwiSKj5q50NPhGck0V3OPyJG0z8GQpJ1sMEEFgCpvSCoE9/9f3dnmxPDROxduEDnJ/3jYzQTm+QXtURX5A6UwHYBUZi2f+RyPgOn/+7mjHdwDyhDWbtZErnMsPBdvo7YdWYD50DddgNLwM+s3kpQp48l2MAiOC8DcFGW7TxIJpLOkNdt11v2bSGRXH/kojyhV8LpzqP6MIo2vRjKhqDe0kUjytAmU6KeH+j8GyGYt9AoJF+hrSNxED4QYfsFinLaaw/BA==;5:H02qRIMmoFHjezgLVenS+MUiVyxPxX7rxpJ7s/Ql6UvI3tb+5XrgNP/1S8uMyVVSsrfuy3hX+6GcjnuAv40P89MqxxipPEr28EpMoMwnhCLWqDnhkh3XORlUgIICahBHHLu3E9ySW0idoLzDyWJ/5gGL6JdB8J1JypoYKQyr9so=;24:m3urUp5aYIyifXSZlh/PA/f/DI+yza08GOoWywaaqr3l3U41VkPGuy0I7rDI5YyMuogZqIU/W3F5jhtOfeEELmHjHMjbDqg24m8AUiIWL88= SpamDiagnosticOutput: 1:99 SpamDiagnosticMetadata: NSPM X-Microsoft-Exchange-Diagnostics: 1;CY4PR11MB1637;7:HyTCwg4zYDlLWj/4XnTUGSvOrp+DeGsTK8VxhW7v0w4tq63yhLkdPh2dZp2AVl9NxjRLDG3dH0LqUh7oUfh9PpE1x66bCn0dPhlWW5Lfv807yLtBIfLH2ryRKYZrW8A4jfejEncomlATlwU5k1DZ7ber5Di52nHh8qrINhUw7T2BL4DoXUoZbnkRhpLRbqyxIgCHjo+pTHw2BQimL17oYq0lEmJujQAMb6ZcwVpA2Y6DCKnEnVfFADazK7hTx95UESOtb7xCrZh6ADFMuF7I1XBIk0kEshHfZY86ssvoYNwTjUkAijiygsoweaOCM+NcKJoH+m85omU8Z+42xOVf+VoVSjPOsD0Y0kMvLrX7qc8= X-OriginatorOrg: bluetreble.com X-MS-Exchange-CrossTenant-OriginalArrivalTime: 21 Oct 2016 20:46:50.4605 (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/19/16 7:52 AM, Robert Haas wrote: > So, I think that this is a really promising direction, but also that > you should try very hard to try to get out from under this 6-byte PK > limitation. That seems really ugly, and in practice it probably means > your PK is probably going to be limited to int4, which is kind of sad > since it leaves people using int8 or text PKs out in the cold. My impression is that int4 is by far the most popular PK type. Even if the initial implementation is limited to that I think it'd have a lot of potential. -- 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