Postgres Pro
Downloads
Home   >   mailing lists

Re: Does PostgreSQL ever create indexes on its own? - Mailing list pgsql-general

From Jeremy Harris
Subject Re: Does PostgreSQL ever create indexes on its own?
Date
Msg-id 5645C2FF.2000003@wizmail.org
Whole thread Raw
In response to Re: Does PostgreSQL ever create indexes on its own?  (Thomas Kellerer <spam_eater@gmx.net>)
Responses Re: Does PostgreSQL ever create indexes on its own?
List pgsql-general
Tree view 
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 by date:

Previous
From: Thomas Kellerer
Date:
Subject: Re: Does PostgreSQL ever create indexes on its own?
Next
From: Albe Laurenz
Date:
Subject: Re: Does PostgreSQL ever create indexes on its own?