Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 7171E2E3060 for ; Tue, 11 Mar 2008 10:47:04 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 89028-01-6 for ; Tue, 11 Mar 2008 10:46:31 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from beaver.fastcrypt.com (beaver.fastcrypt.com [64.7.141.17]) by postgresql.org (Postfix) with ESMTP id A9CC12E3125 for ; Tue, 11 Mar 2008 10:46:13 -0300 (ADT) Received: from [192.168.1.14] (dcdsl.ebox.com [64.7.143.116]) by beaver.fastcrypt.com (Postfix) with ESMTP id 955E21580370; Tue, 11 Mar 2008 09:51:43 -0400 (EDT) Cc: pgsql-performance@postgresql.org Message-Id: From: Dave Cramer To: petchimuthu lingam In-Reply-To: Content-Type: text/plain; charset=US-ASCII; format=flowed; delsp=yes Content-Transfer-Encoding: 7bit Mime-Version: 1.0 (Apple Message framework v919.2) Subject: Re: how many index can have???? Date: Tue, 11 Mar 2008 09:46:08 -0400 References: X-Mailer: Apple Mail (2.919.2) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200803/229 X-Sequence-Number: 29183 On 11-Mar-08, at 8:28 AM, petchimuthu lingam wrote: > I have one table with 30 fields, i have more then 60 million > records, if i use more no of indexes will it affect the insertion > performance? and select performance? > Yes, and yes, but without more information about what you are trying to do, those answers are useless. > Shall i have more then one partial index for same field, ???? > > -- > With Best Regards, > Petchimuthulingam S