Re: Does PostgreSQL ever create indexes on its own?

From: Jeremy Harris <jgh(at)wizmail(dot)org>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Does PostgreSQL ever create indexes on its own?
Date: 2015-11-13 11:01:19
Message-ID: 5645C2FF.2000003@wizmail.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Albe Laurenz 2015-11-13 11:49:09 Re: Does PostgreSQL ever create indexes on its own?
Previous Message Thomas Kellerer 2015-11-13 10:49:16 Re: Does PostgreSQL ever create indexes on its own?