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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general