Received: from localhost (maia-2.hub.org [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id 3BD1D9FA31E for ; Tue, 16 Jan 2007 11:48:52 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-new, port 10024) with ESMTP id 87346-02 for ; Tue, 16 Jan 2007 11:48:26 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from myemma.com (db1.e2ma.net [66.179.147.163]) by postgresql.org (Postfix) with ESMTP id 33DF99FB2EF for ; Tue, 16 Jan 2007 11:48:39 -0400 (AST) Received: from localhost (localhost.localdomain [127.0.0.1]) by myemma.com (Postfix) with ESMTP id 975DE23CFF; Tue, 16 Jan 2007 09:48:32 -0600 (CST) Received: from myemma.com ([127.0.0.1]) by localhost (velma [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 11650-08; Tue, 16 Jan 2007 09:48:30 -0600 (CST) Received: from [10.0.23.77] (unknown [209.149.59.218]) by myemma.com (Postfix) with ESMTP id D867D23CDF; Tue, 16 Jan 2007 09:48:29 -0600 (CST) Message-ID: <45ACF3CC.4030903@myemma.com> Date: Tue, 16 Jan 2007 09:48:28 -0600 From: Erik Jones User-Agent: Thunderbird 1.5.0.7 (Windows/20060909) MIME-Version: 1.0 To: Mario Behring Cc: Alvaro Herrera , pgsql-sql@postgresql.org Subject: Re: Droping indexes References: <40081.83800.qm@web30012.mail.mud.yahoo.com> In-Reply-To: <40081.83800.qm@web30012.mail.mud.yahoo.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new-20030616-p10 (Debian) at myemma.com X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200701/56 X-Sequence-Number: 27208 Mario Behring wrote: > Hi Alvaro, > > Thank you for your advise..............I was thinking about doing > exactly that, I wasn't sure on how to do it though, meaning, > considering the info below, how should I use the CREATE INDEX command > to create these indexes?? Have you read the documentation? http://www.postgresql.org/docs/8.2/interactive/sql-createindex.html -- erik jones software development emma(r)