Re: how many index can have????

Поиск
Список
Период
Сортировка
От Dave Cramer
Тема Re: how many index can have????
Дата
Msg-id FB68F787-963E-4950-85FF-7723FD90EA9D@fastcrypt.com
обсуждение исходный текст
Ответ на how many index can have????  ("petchimuthu lingam" <spmlingam@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: "sathiya psql"
Дата:
Сообщение: list user created triggers
Следующее
От: Matthew
Дата:
Сообщение: Re: count * performance issue