Comment 3 for bug 1666547

Also Manila is effected. There are no indexes created for postgres, e.g.:

# MySQL
show index from share_instances;
+-----------------+------------+---------------------+--------------+----------------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
| Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment |
+-----------------+------------+---------------------+--------------+----------------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
| share_instances | 0 | PRIMARY | 1 | id | A | 0 | NULL | NULL | | BTREE | | |
| share_instances | 1 | si_share_fk | 1 | share_id | A | 0 | NULL | NULL | YES | BTREE | | |
| share_instances | 1 | si_share_network_fk | 1 | share_network_id | A | 0 | NULL | NULL | YES | BTREE | | |
| share_instances | 1 | si_share_server_fk | 1 | share_server_id | A | 0 | NULL | NULL | YES | BTREE | | |
| share_instances | 1 | si_az_id_fk | 1 | availability_zone_id | A | 0 | NULL | NULL | YES | BTREE | | |
| share_instances | 1 | si_st_id_fk | 1 | share_type_id | A | 0 | NULL | NULL | YES | BTREE | | |
+-----------------+------------+---------------------+--------------+----------------------+-----------+-------------+----------+--------+------+------------+---------+---------------+

# postgres
\d+ share_instances
                                      Table "public.share_instances"
         Column | Type | Modifiers | Storage | Stats target | Description
------------------------+-----------------------------+-----------+----------+--------------+-------------
 created_at | timestamp without time zone | | plain | |
 updated_at | timestamp without time zone | | plain | |
 deleted_at | timestamp without time zone | | plain | |
 deleted | character varying(36) | | extended | |
 id | character varying(36) | not null | extended | |
 share_id | character varying(36) | | extended | |
 host | character varying(255) | | extended | |
 status | character varying(255) | | extended | |
 scheduled_at | timestamp without time zone | | plain | |
 launched_at | timestamp without time zone | | plain | |
 terminated_at | timestamp without time zone | | plain | |
 share_network_id | character varying(36) | | extended | |
 share_server_id | character varying(36) | | extended | |
 availability_zone_id | character varying(36) | | extended | |
 access_rules_status | character varying(255) | | extended | |
 replica_state | character varying(255) | | extended | |
 share_type_id | character varying(36) | | extended | |
 cast_rules_to_readonly | boolean | not null | plain | |
Indexes:
    "share_instances_pkey" PRIMARY KEY, btree (id)