Postgres Pro
Downloads
Home   >   mailing lists

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

From Thomas Kellerer
Subject Re: Does PostgreSQL ever create indexes on its own?
Date
Msg-id n24f7c$fn5$1@ger.gmane.org
Whole thread Raw
In response to Re: Does PostgreSQL ever create indexes on its own?  (Albe Laurenz <laurenz.albe@wien.gv.at>)
Responses Re: Does PostgreSQL ever create indexes on its own?
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: Albe Laurenz
Date:
Subject: Re: can postgres run well on NFS mounted partitions?
Next
From: Jeremy Harris
Date:
Subject: Re: Does PostgreSQL ever create indexes on its own?