Re: cannot get stable function to use index - Mailing list pgsql-general

From Tom Lane
Subject Re: cannot get stable function to use index
Date
Msg-id 12243.1451490788@sss.pgh.pa.us
Whole thread Raw
In response to Re: cannot get stable function to use index  (Andy Colson <andy@squeakycode.net>)
Responses Re: cannot get stable function to use index  (Andy Colson <andy@squeakycode.net>)
List pgsql-general
Andy Colson <andy@squeakycode.net> writes:
> Here are my results, if there are any others you'd like to see please
> let me know.  Thanks Tom.

For comparison, could we see the results for the non-partial case, ie

explain analyze
select *
from search
where search_vec @@ to_tsquery('213 & E & 13 & ST & N');

            regards, tom lane


pgsql-general by date:

Previous
From: Andy Colson
Date:
Subject: Re: cannot get stable function to use index
Next
From: Andy Colson
Date:
Subject: Re: cannot get stable function to use index