| From: | Kranti K K Parisa™ <kranti(dot)parisa(at)gmail(dot)com> |
|---|---|
| To: | "Matthew Wakeling" <matthew(at)flymine(dot)org> |
| Cc: | pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: PostgreSQL+Hibernate Performance |
| Date: | 2008-08-21 07:03:47 |
| Message-ID: | 4478b4ac0808210003x163e3d22u7fda12bd0e0ffeba@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
Thanks Matthew,
does that mean i can just have index1, index3, index4?
On Wed, Aug 20, 2008 at 8:54 PM, Matthew Wakeling <matthew(at)flymine(dot)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(at)postgresql(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Moritz Onken | 2008-08-21 07:03:53 | Re: Slow query with a lot of data |
| Previous Message | Kranti K K Parisa™ | 2008-08-21 06:59:38 | Re: PostgreSQL+Hibernate Performance |