Re: how many index can have???? - Mailing list pgsql-performance

From Dave Cramer
Subject Re: how many index can have????
Date
Msg-id FB68F787-963E-4950-85FF-7723FD90EA9D@fastcrypt.com
Whole thread Raw
In response to how many index can have????  ("petchimuthu lingam" <spmlingam@gmail.com>)
List 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


pgsql-performance by date:

Previous
From: "sathiya psql"
Date:
Subject: list user created triggers
Next
From: Matthew
Date:
Subject: Re: count * performance issue