Postgres Pro
Downloads
Home   >   mailing lists

Re: index question - Mailing list pgsql-general

From Melvin Davidson
Subject Re: index question
Date
Msg-id CANu8Fiw+c6AzOZjuCSWLr8S9kQ2prEP4ucMicmdrjaG4QD2owQ@mail.gmail.com
Whole thread Raw
In response to Re: index question  ("David G. Johnston" <david.g.johnston@gmail.com>)
Responses Re: index question
List pgsql-general
Tree view


On Sun, May 1, 2016 at 6:31 PM, David G. Johnston <david.g.johnston@gmail.com> wrote:
On Sunday, May 1, 2016, Melvin Davidson <melvin6925@gmail.com> wrote:

Your index is based on split_part function
but the WHERE clause is specific to full_path, so the planner cannot find a valid index




David J.

>This sentence is even less useful than the questions that you asked...
Your comments are antagonistic at best, but perhaps you should take a course in english.

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.


--
Melvin Davidson
I reserve the right to fantasize.  Whether or not you
wish to share my fantasy is entirely up to you.

pgsql-general by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: index question
Next
From: "drum.lucas@gmail.com"
Date:
Subject: Re: index question