Re: [Sqlgrey-users] Congratulations & PostgreSQL issue

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

Another issue about:
CREATE INDEX connect_idx
  ON "connect"
  USING btree
  (src , sender_domain , sender_name);

This is an index on three columns. It is effective only if the SQL
query includes these three columns. It can be very fast, but it should
not be considered the same as THREE different indexes. I agree it is
not very well documented in PostgreSQL documentation, but all databases
work the same and this is only effective in a limited number of
queries.

Anyway, I don't have enough data to start a performance test. I will
write another message on the list to launch a small testing project.


Kind regards,
Jean-Michel