Re: Does PostgreSQL ever create indexes on its own?

From: Thomas Kellerer <spam_eater(at)gmx(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Does PostgreSQL ever create indexes on its own?
Date: 2015-11-13 10:49:16
Message-ID: n24f7c$fn5$1@ger.gmane.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Albe Laurenz schrieb am 13.11.2015 um 11:23:
>> My questions is whether these “index_*” indexes could have been created by postgresql or whether I
>> have an errant developer using some kinda third-party tool?
>
> 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.

Thomas

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jeremy Harris 2015-11-13 11:01:19 Re: Does PostgreSQL ever create indexes on its own?
Previous Message Albe Laurenz 2015-11-13 10:27:31 Re: can postgres run well on NFS mounted partitions?