Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id D163464FD67 for ; Thu, 21 Aug 2008 04:03:58 -0300 (ADT) Received: from postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 38379-01 for ; Thu, 21 Aug 2008 04:03:51 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from ti-out-0910.google.com (ti-out-0910.google.com [209.85.142.184]) by postgresql.org (Postfix) with ESMTP id 29C3F64FD1E for ; Thu, 21 Aug 2008 04:03:52 -0300 (ADT) Received: by ti-out-0910.google.com with SMTP id y8so601324tia.5 for ; Thu, 21 Aug 2008 00:03:51 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from:to :subject:cc:in-reply-to:mime-version:content-type:references; bh=WzertZEX0so4ivAi7nEbnbNI4tOEVrSZhaoZTZmTNUQ=; b=sdkuyG2Vnw7FgMYyNnD90h/8/QxUgI0p6fb1ynJfBsBfPIVqSGG0iTK9puBTmf80jv Nd/JUi80sp4V8bte4XF6pmma+ZWzsmwB2juf9+eBeGHDQtyIRO19dqKn6yWNYWQU0bsz frZfr+vzc029QSoxIB7QC5W37+iZ1KaYrb3RI= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:to:subject:cc:in-reply-to:mime-version :content-type:references; b=T+wSSuEewJ9o2fvjcPhDXFsNAlQiO0HPt1At0kAWXQwtYnv9adfTlnCPNMJxayB0ah HQGqi6gTwAJ2csPu0kRrqrQ7iZERHw13zQqaVtw/Y9YxZJlQqTSHBN/DUjOjyvAQSOGl 3qbRT62GW8HxuELx4hrBmvn868ZxYpAyk0f7U= Received: by 10.110.14.12 with SMTP id 12mr1114846tin.19.1219302228062; Thu, 21 Aug 2008 00:03:48 -0700 (PDT) Received: by 10.110.8.20 with HTTP; Thu, 21 Aug 2008 00:03:47 -0700 (PDT) Message-ID: <4478b4ac0808210003x163e3d22u7fda12bd0e0ffeba@mail.gmail.com> Date: Thu, 21 Aug 2008 12:33:47 +0530 From: "=?WINDOWS-1252?Q?Kranti_K_K_Parisa=99?=" To: "Matthew Wakeling" Subject: Re: PostgreSQL+Hibernate Performance Cc: pgsql-performance@postgresql.org In-Reply-To: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_102405_21311022.1219302228070" References: <4478b4ac0808200525ia6eabe8q886ac7fbba53ff05@mail.gmail.com> <1219242910.7023.94.camel@archimedes.mir3.com> <4478b4ac0808200810p7eb1f0b2ga307d858a8d94e60@mail.gmail.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.001 tagged_above=0 required=5 tests=HTML_MESSAGE=0.001 X-Spam-Level: X-Archive-Number: 200808/241 X-Sequence-Number: 31122 ------=_Part_102405_21311022.1219302228070 Content-Type: text/plain; charset=WINDOWS-1252 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline Thanks Matthew, does that mean i can just have index1, index3, index4? On Wed, Aug 20, 2008 at 8:54 PM, Matthew Wakeling wrot= e: > On Wed, 20 Aug 2008, Kranti K K Parisa=99 wrote: > >> creating multiple indexes on same column will effect performance? >> for example: >> >> index1 : column1, column2, column3 >> index2: column1 >> index3: column2, >> index4: column3 >> index5: column1,column2 >> > > The sole purpose of indexes is to affect performance. > > However, if you have index1, there is no point in having index2 or index5= . > > Matthew > > -- > Isn't "Microsoft Works" something of a contradiction? > -- > Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org= ) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-performance > --=20 Best Regards Kranti Kiran Kumar Parisa M: +91 - 9391 - 438 - 738 +91 - 9849 - 625 - 625 ------=_Part_102405_21311022.1219302228070 Content-Type: text/html; charset=WINDOWS-1252 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline
Thanks Matthew,

does that mean i can just have inde= x1, index3, index4?

On Wed, Aug 20, 2008 = at 8:54 PM, Matthew Wakeling <matthew@flymine.org> wrote:
On Wed, 20 Aug 2008, Kranti K K Parisa=99 wrote:
creating multiple indexes on same column will effect performance?
 for example:

index1 : column1, column2, column3
index2: column1
index3: column2,
index4: column3
index5: column1,column2

The sole purpose of indexes is to affect performance.

However, if you have index1, there is no point in having index2 or index5.<= br>
Matthew

--
Isn't "Microsoft Works" something of a contradiction?
--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance



--

Best Re= gards
Kranti Kiran Kumar Parisa
M: +91 - 9391 - 438 - 738
+91 - 9= 849 - 625 - 625

------=_Part_102405_21311022.1219302228070--