Should duplicate indexes on same column and same table be allowed?

Поиск
Список
Период
Сортировка
Искать
От
Rajesh Kumar Mallah
Тема
Should duplicate indexes on same column and same table be allowed?
Дата
Msg-id
a97c77030612082203j5b1dac19i96ef9932d60f375e@mail.gmail.com
Список
Дерево обсуждения
Should duplicate indexes on same column and same table be allowed? "Rajesh Kumar Mallah" <mallah.rajesh@gmail.com>
Re: Should duplicate indexes on same column and same table be allowed? Tom Lane <tgl@sss.pgh.pa.us>
Re: Should duplicate indexes on same column and same table be allowed? "Rajesh Kumar Mallah" <mallah.rajesh@gmail.com>
Re: Should duplicate indexes on same column and same table be allowed? "Rajesh Kumar Mallah" <mallah.rajesh@gmail.com>
Re: Should duplicate indexes on same column and same table be allowed? Tom Lane <tgl@sss.pgh.pa.us>
Re: Should duplicate indexes on same column and same tablebe allowed? "Simon Riggs" <simon@2ndquadrant.com>
Simple Unload Naomi Walker <nwalke@eldocomp.com>
Re: Simple Unload Bricklen Anderson <banderson@presinet.com>
Re: Should duplicate indexes on same column and same table be allowed? "Rajesh Kumar Mallah" <mallah.rajesh@gmail.com>
Re: Should duplicate indexes on same column and same table Daniel Cristian Cruz <danielcristian@gmail.com>
Re: Should duplicate indexes on same column and same Bruce Momjian <bruce@momjian.us>
Re: Should duplicate indexes on same column and same "Joshua D. Drake" <jd@commandprompt.com>
Re: Should duplicate indexes on same column and same Tom Lane <tgl@sss.pgh.pa.us>
Re: Should duplicate indexes on same column and same "Joshua D. Drake" <jd@commandprompt.com>
Re: Should duplicate indexes on same column and same table be allowed? "Rajesh Kumar Mallah" <mallah.rajesh@gmail.com>
Hi,

Some of our tables have duplicate indexes on same column by different
index names.
Should the database server  check for the existance of (effectively)
same index in
a table before creating a new one.

Regds
Mallah.
В списке pgsql-admin по дате отправления
От: Andy Shellam (Mailing Lists)
Дата:
От: Tom Lane
Дата:
FAQ