Re: how many index can have????

From: Dave Cramer <pg(at)fastcrypt(dot)com>
To: petchimuthu lingam <spmlingam(at)gmail(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: how many index can have????
Date: 2008-03-11 13:46:08
Message-ID: FB68F787-963E-4950-85FF-7723FD90EA9D@fastcrypt.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance


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

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Matthew 2008-03-11 13:57:03 Re: count * performance issue
Previous Message sathiya psql 2008-03-11 13:38:33 list user created triggers