AFAIK, the PostGIS driver does not create an index upon layer creation, but there is a layer creation option proposed in #959 that might make it in if there is time.