Re: Does PostgreSQL ever create indexes on its own?

Поиск
Список
Период
Сортировка
От Jeremy Harris
Тема Re: Does PostgreSQL ever create indexes on its own?
Дата
Msg-id 5645C2FF.2000003@wizmail.org
обсуждение исходный текст
Ответ на Re: Does PostgreSQL ever create indexes on its own?  (Thomas Kellerer <spam_eater@gmx.net>)
Ответы Re: Does PostgreSQL ever create indexes on its own?  (Albe Laurenz <laurenz.albe@wien.gv.at>)
Список pgsql-general
On 13/11/15 10:49, Thomas Kellerer wrote:
>> These indexes were *not* created by PostgreSQL.
>> We are not Oracle.
>
> Well, Oracle does not create indexes on its own either - it has the same strategy as Postgres:
> Indexes are only created automatically for primary keys and unique constraints.

Given that indices are an implementation wart on the side of the
relational model, it'd be nice if RDBMS' did create them for one.
--
Cheers,
  Jeremy




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

Предыдущее
От: Thomas Kellerer
Дата:
Сообщение: Re: Does PostgreSQL ever create indexes on its own?
Следующее
От: Albe Laurenz
Дата:
Сообщение: Re: Does PostgreSQL ever create indexes on its own?