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 B3B1AD9FA7 for ; Mon, 21 Nov 2005 12:14:27 -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 45346-04 for ; Mon, 21 Nov 2005 16:14:25 +0000 (GMT) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from xproxy.gmail.com (xproxy.gmail.com [66.249.82.197]) by svr1.postgresql.org (Postfix) with ESMTP id 1B9EDD9F85 for ; Mon, 21 Nov 2005 12:14:18 -0400 (AST) Received: by xproxy.gmail.com with SMTP id h31so641195wxd for ; Mon, 21 Nov 2005 08:14:18 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:mime-version:content-type; b=GPH3pwPCDE1r3ZHIz/EBFCy/p9YNWyvEh9VAZu0T3R+q+tVLCDQ0gf/W0ds37EfPrGUQ4EiSfxkzA3g/Iu5VKth9SGiJSasZEIKxiFdkzV8QpPFPEyy6xB1gklj7xnNUmM10/7/XlGGg1GEPuRb1mLp3/dnX/QypUfybnBKetx8= Received: by 10.64.201.14 with SMTP id y14mr3113010qbf; Mon, 21 Nov 2005 08:14:17 -0800 (PST) Received: by 10.64.243.11 with HTTP; Mon, 21 Nov 2005 08:14:17 -0800 (PST) Message-ID: <38242de90511210814p62c88ad4w2a316b3fd1c7569f@mail.gmail.com> Date: Mon, 21 Nov 2005 09:14:17 -0700 From: Joshua Marsh To: pgsql-admin@postgresql.org Subject: Indexing array columns. MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_40504_24654995.1132589657945" X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=1.139 required=5 tests=[AWL=0.194, HTML_10_20=0.945, HTML_MESSAGE=0.001] X-Spam-Score: 1.139 X-Spam-Level: * X-Archive-Number: 200511/280 X-Sequence-Number: 19653 ------=_Part_40504_24654995.1132589657945 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline I've been searching the manual looking for information about the effects of indexing an array column but haven't found any information as of yet. Does anyone have any information on how the indexes work for arrayed columns? Does/Can the index track each element in the array, or does it track only the array as a whole? How can I increase the speed of a query like: SELECT * FROM table WHERE 123 =3D ANY(array_of_ints); ? Thanks, Josh ------=_Part_40504_24654995.1132589657945 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline I've been searching the manual looking for information about the effects of indexing an array column but haven't found any information as of yet. 

Does anyone have any information on how the indexes work for arrayed column= s? 

Does/Can the index track each element in the array, or does it track only t= he array as a whole? 

How can I increase the speed of a query like: SELECT * FROM table WHERE 123= =3D ANY(array_of_ints); ?

Thanks,

Josh

------=_Part_40504_24654995.1132589657945--