PostgreSQL 9.1 index over arrays

Question

What index will enhance database performance for table

CREATE TABLE my_table (
    word_set text[]
)

for requests with WHERE my_table.word_set @> '<some word>'

Check [this topic][1], same sort of issue. [1]: stackoverflow.com/questions/4058731/… — Frank Heikens
– Frank Heikens, Commented Jul 25, 2012 at 11:40

Frank Heikens · Accepted Answer · 2012-07-25 11:43:56Z

2

CREATE INDEX idx_test on my_table USING GIN (word_set);

Check EXPLAIN ANALYZE to see if the index is used. Turn enable_seqscan off when your table is almost empty or doesn't have enough unique data. Having an index doesn't mean the database will always use that index: Using an index might be slower than a sequential disk scan. It all depends.

answered Jul 25, 2012 at 11:43

Frank Heikens

129k26 gold badges157 silver badges153 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

PostgreSQL 9.1 index over arrays

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related