Postgresql indexing array of strings column type
Is is possible to create an index on a column whose type is **array of strings**. Tried using **GIN indexes**. But queries does not seem to be using those indexes.

    Example
    
    CREATE TABLE users (
     name VARCHAR(100),
     groups text[],
    );
    
    Query: SELECT name FROM users WHERE ANY(groups) = 'Engineering'.

Also what is the best way to perform GROUP BY on 'groups' column efficiently so that it can give 'groups' and count.
Postgresql indexing array of strings column type
===

Is is possible to create an index on a column whose type is **array of strings**. Tried using **GIN indexes**. But queries does not seem to be using those indexes.

    Example
    
    CREATE TABLE users (
     name VARCHAR(100),
     groups text[],
    );
    
    Query: SELECT name FROM users WHERE ANY(groups) = 'Engineering'.

Also what is the best way to perform GROUP BY on 'groups' column efficiently so that it can give 'groups' and count.