Re: [Sqlgrey-users] Congratulations & PostgreSQL issue

[Jean-Michel P. - G. <jm...@go...>]

Le mercredi 12 août 2015 à 14:52 +0200, Lionel Bouton a écrit :
> You don't need these indexes and switching from the from_awl_pkey to
> these indexes would slow SQLgrey. Run EXPLAIN on any query done by
> SQLgrey and you should see that it uses the from_awl_pkey index (if 
> it's
> not, your database is probably not in a sane state).

Okay, thanks. I am not sure that an index on several columns is useful as a primary index."from_awl_pkey" PRIMARY KEY, btree (src, sender_domain, sender_name)
This is not the same as three indexes and can be very fast when a query is being run on all those three columns. Otherwize, it should be slow.
I will try to create a fake database and will report later.
Kind regards,Jean-Michel