Re: Disallow redundant indexes

Поиск
Список
Период
Сортировка
От Nathan Bossart
Тема Re: Disallow redundant indexes
Дата
Msg-id aA_-XAZCAAnu3rzn@nathan
обсуждение исходный текст
Ответ на Re: Disallow redundant indexes  (Sami Imseih <samimseih@gmail.com>)
Ответы Re: Disallow redundant indexes
Список pgsql-hackers
On Mon, Apr 28, 2025 at 01:12:18PM -0500, Sami Imseih wrote:
> If I had a dollar for every time I asked a user to check for duplicate
> indexes :) So
> I think it's a good idea to provide some way to detect these ( besides
> a query in the
> Wiki ), but I don't think we should prevent it.
> 
> While a WARNING will be a good to have, it could easily go unnoticed,
> but it's still good to have.

I don't doubt that this is a problem in the field, but I'm not sure I'm
convinced it's worthwhile to emit a warning that only appears for exact
duplicates and is very easily missed, not to mention that the user could be
intentionally creating the index.

-- 
nathan



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