Postgres Pro
Downloads
Home   >   mailing lists

Re: index question - Mailing list pgsql-general

From drum.lucas@gmail.com
Subject Re: index question
Date
Msg-id CAE_gQfWnB5z7WJnbyOHJUi8PtkaprpmeouL1tjbJNO=p5Bi6qg@mail.gmail.com
Whole thread Raw
In response to Re: index question  (Melvin Davidson <melvin6925@gmail.com>)
Responses Re: index question  (Melvin Davidson <melvin6925@gmail.com>)
List pgsql-general
Tree view
To clarify, the index is based on a function called "split_part(....)
The WHERE clause is only referencing the full_part column, so the planner cannot associate the index with the full_part column.

Thanks for the explanation, Melvin.

It would be simple like:

CREATE INDEX CONCURRENTLY ON gorfs.inode_segments USING btree ("full_path");

?

Thanks again.
Lucas

pgsql-general by date:

Previous
From: Melvin Davidson
Date:
Subject: Re: index question
Next
From: Melvin Davidson
Date:
Subject: Re: index question