Re: multiple indexes on the same column

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: multiple indexes on the same column
Дата
Msg-id 2157.1555088856@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: multiple indexes on the same column  (Andres Freund <andres@anarazel.de>)
Ответы Re: multiple indexes on the same column  (Tiffany Thang <tiffanythang@gmail.com>)
Список pgsql-general
Andres Freund <andres@anarazel.de> writes:
> On 2019-04-12 09:51:51 -0400, Tom Lane wrote:
>> Tiffany Thang <tiffanythang@gmail.com> writes:
>>> Can someone explain the use of creating multiple indexes on the same
>>> column?

>> There is none, unless the indexes have different properties (e.g.
>> different opclasses and/or index AMs).

> Well, it can be beneficial to create a new index concurrently, and then
> drop the old one concurrently.

Right, but in that situation there's no intent to keep both indexes
in place.  You're just putting up with extra overhead temporarily
as a means to avoid taking an exclusive lock.

            regards, tom lane



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

Предыдущее
От: Andres Freund
Дата:
Сообщение: Re: multiple indexes on the same column
Следующее
От: Paul van der Linden
Дата:
Сообщение: Safe to delete files?