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@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
