From: Kranti K K Parisa™ <kranti.parisa@gmail.com>
To: Matthew Wakeling <matthew@flymine.org>
Cc: pgsql-performance@postgresql.org
Subject: Re: PostgreSQL+Hibernate Performance
Date: Thu, 21 Aug 2008 12:33:47 +0530
Message-ID: <4478b4ac0808210003x163e3d22u7fda12bd0e0ffeba@mail.gmail.com> (raw)
In-Reply-To: <alpine.DEB.1.10.0808201621340.4454@aragorn.flymine.org>
References: <4478b4ac0808200525ia6eabe8q886ac7fbba53ff05@mail.gmail.com>
<1219242910.7023.94.camel@archimedes.mir3.com>
<4478b4ac0808200810p7eb1f0b2ga307d858a8d94e60@mail.gmail.com>
<alpine.DEB.1.10.0808201621340.4454@aragorn.flymine.org>
Thanks Matthew,
does that mean i can just have index1, 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™ 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
>
--
Best Regards
Kranti Kiran Kumar Parisa
M: +91 - 9391 - 438 - 738
+91 - 9849 - 625 - 625
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: kranti.parisa@gmail.com, matthew@flymine.org
Subject: Re: PostgreSQL+Hibernate Performance
In-Reply-To: <4478b4ac0808210003x163e3d22u7fda12bd0e0ffeba@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox