X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id A3CE3DA2AC for ; Mon, 21 Nov 2005 15:15:55 -0400 (AST) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 00749-02 for ; Mon, 21 Nov 2005 19:15:55 +0000 (GMT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from joeconway.com (wsip-68-15-9-201.sd.sd.cox.net [68.15.9.201]) by svr1.postgresql.org (Postfix) with ESMTP id A37D1DA259 for ; Mon, 21 Nov 2005 15:15:52 -0400 (AST) Received: from [206.19.64.3] (account jconway HELO [172.16.1.115]) by joeconway.com (CommuniGate Pro SMTP 4.1.8) with ESMTP-TLS id 3281825; Mon, 21 Nov 2005 11:20:40 -0800 Message-ID: <43821CE7.4070508@joeconway.com> Date: Mon, 21 Nov 2005 11:15:51 -0800 From: Joe Conway User-Agent: Mozilla/5.0 (X11; U; Linux x86_64; en-US; rv:1.7.12) Gecko/20050923 Fedora/1.7.12-1.5.1 X-Accept-Language: en-us, en MIME-Version: 1.0 To: Joshua Marsh CC: pgsql-admin@postgresql.org Subject: Re: Indexing array columns. References: <38242de90511210814p62c88ad4w2a316b3fd1c7569f@mail.gmail.com> In-Reply-To: <38242de90511210814p62c88ad4w2a316b3fd1c7569f@mail.gmail.com> Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0 required=5 tests=[none] X-Spam-Score: 0 X-Spam-Level: X-Archive-Number: 200511/284 X-Sequence-Number: 19657 Joshua Marsh wrote: > Does/Can the index track each element in the array, or does it track > only the array as a whole? Built in index support works on the array as a whole, not the individual elements. > How can I increase the speed of a query like: SELECT * FROM table WHERE > 123 = ANY(array_of_ints); ? See contrib/intarray. Joe