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


--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance

Reply via email to