Re: redundants indexes can be created

Поиск
Список
Период
Сортировка
От Cyril SCETBON
Тема Re: redundants indexes can be created
Дата
Msg-id 486E2C34.4080105@echo.fr
обсуждение исходный текст
Ответ на Re: redundants indexes can be created  (Bernd Helmle <mailings@oopsware.de>)
Список pgsql-general

Bernd Helmle wrote:
> --On Freitag, Juli 04, 2008 11:26:31 +0100 Richard Huxton
> <dev@archonet.com> wrote:
>
>> You ask for a particular index, it creates the index. Why complicate the
>> code checking for possible duplicate indexes if it's not a problem
>> people
>> tend to encounter?
>
> And what would characterize a "duplicate" index? Think about partial
> indexes, where we actually _want_ to have multiple indexes for certain
> ranges on the same column.
this case is not included in duplicate index for me.

--
Cyril SCETBON - Ingénieur bases de données
AUSY pour France Télécom - OPF/PORTAILS/DOP/HEBEX

Tél : +33 (0)4 97 12 87 60
Jabber : cscetbon@jabber.org
France Telecom - Orange
790 Avenue du Docteur Maurice Donat
Bâtiment Marco Polo C2 - Bureau 202
06250 Mougins
France

***********************************
Ce message et toutes les pieces jointes (ci-apres le 'message') sont
confidentiels et etablis a l'intention exclusive de ses destinataires.
Toute utilisation ou diffusion non autorisee est interdite.
Tout message electronique est susceptible d'alteration. Le Groupe France
Telecom decline toute responsabilite au titre de ce message s'il a ete
altere, deforme ou falsifie.
Si vous n'etes pas destinataire de ce message, merci de le detruire
immediatement et d'avertir l'expediteur.
***********************************
This message and any attachments (the 'message') are confidential and
intended solely for the addressees.
Any unauthorised use or dissemination is prohibited.
Messages are susceptible to alteration. France Telecom Group shall not be
liable for the message if altered, changed or falsified.
If you are not recipient of this message, please cancel it immediately and
inform the sender.
************************************


В списке pgsql-general по дате отправления:

Предыдущее
От: Bernd Helmle
Дата:
Сообщение: Re: redundants indexes can be created
Следующее
От: "Long Cui"
Дата:
Сообщение: Re: simple installation problem in windows system