Re: Does PostgreSQL ever create indexes on its own?

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