Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1UJDBh-0003Cs-AQ for pgsql-performance@arkaria.postgresql.org; Sat, 23 Mar 2013 01:24:01 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.72) (envelope-from ) id 1UJDBg-0003QA-M7 for pgsql-performance@arkaria.postgresql.org; Sat, 23 Mar 2013 01:24:00 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1UJDBe-0003Ov-Tt for pgsql-performance@postgresql.org; Sat, 23 Mar 2013 01:23:58 +0000 Received: from outmail149106.authsmtp.co.uk ([62.13.149.106]) by magus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1UJDBW-0006pV-5z for pgsql-performance@postgresql.org; Sat, 23 Mar 2013 01:23:58 +0000 Received: from mail-c232.authsmtp.com (mail-c232.authsmtp.com [62.13.128.232]) by punt14.authsmtp.com (8.14.2/8.14.2/) with ESMTP id r2N1NlrA048952; Sat, 23 Mar 2013 01:23:47 GMT Received: from [172.47.23.103] (70-36-143-10.dsl.dynamic.sonic.net [70.36.143.10]) (authenticated bits=0) by mail.authsmtp.com (8.14.2/8.14.2/) with ESMTP id r2N1NiHb034715; Sat, 23 Mar 2013 01:23:45 GMT Message-ID: <514D041F.1080108@agliodbs.com> Date: Fri, 22 Mar 2013 18:23:43 -0700 From: Josh Berkus Organization: PostgreSQL Experts Inc. User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:17.0) Gecko/20130308 Thunderbird/17.0.4 MIME-Version: 1.0 To: Heikki Linnakangas CC: Tom Lane , "pgsql-performance@postgresql.org" , Jeff Davis Subject: Re: Index usage for tstzrange? References: <514A5088.6060101@agliodbs.com> <1326.1363838330@sss.pgh.pa.us> <514BA04B.3040609@agliodbs.com> <514CE0DA.5040109@vmware.com> In-Reply-To: <514CE0DA.5040109@vmware.com> X-Enigmail-Version: 1.5.1 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 7bit X-Server-Quench: 4e9a498f-9358-11e2-b10b-0025903375e2 X-AuthReport-Spam: If SPAM / abuse - report it at: http://www.authsmtp.com/abuse X-AuthRoute: OCdyZgscClZXSx8a IioLCC5HRQ8+YBZL BAkGMA9GIUINWEQN c1AAdR12OUdbHwkA AHYLWl5WU1d1XC1y axRSaxtcZklQXgV1 UktWQhwQFntpf0V5 VB4dVh5zcktFcHZw K0I3VyFfVUwsaE9+ R0ZJFGxTZ3oyaWBN TUBYdQZdcABJeRoQ aB4dAXkdCgVyBAwf JSoGdxE3MThPYDlO Sw4AZVwVWw4XBSIu XRkEEjh4dQAA X-Authentic-SMTP: 61633136333939.1019:706 X-AuthFastPath: 0 (Was 255) X-AuthSMTP-Origin: 70.36.143.10/23 X-AuthVirus-Status: No virus detected - but ensure you scan with your own anti-virus system. X-Pg-Spam-Score: -2.6 (--) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-performance Precedence: bulk Sender: pgsql-performance-owner@postgresql.org > We should do this automatically. Or am I missing something? Aside from the need to support @> as well, not that I can see. -- Josh Berkus PostgreSQL Experts Inc. http://pgexperts.com -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance