From: | Andy Colson <andy(at)squeakycode(dot)net> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: cannot get stable function to use index |
Date: | 2015-12-30 16:02:01 |
Message-ID: | 5683FFF9.6070904@squeakycode.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On 12/30/2015 9:55 AM, Andy Colson wrote:
> On 12/30/2015 9:53 AM, Tom Lane wrote:
>> Andy Colson <andy(at)squeakycode(dot)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
>>
>
> QUERY PLAN
> -------------------------------------------------------------------------------------------------------------------
>
> Bitmap Heap Scan on search (cost=6.00..7.02 rows=1 width=100) (actual
> time=0.029..0.029 rows=0 loops=1)
> Recheck Cond: (search_vec @@ to_tsquery('213 & E & 13 & ST & N'::text))
> -> Bitmap Index Scan on search_key (cost=0.00..6.00 rows=1
> width=0) (actual time=0.025..0.025 rows=0 loops=1)
> Index Cond: (search_vec @@ to_tsquery('213 & E & 13 & ST &
> N'::text))
> Total runtime: 0.060 ms
> (5 rows)
>
>
>
>
Oh! I just realized... this is on my test box and I just blew away that
table to rebuild it. And I have to run off to a meeting, so if this
analyze makes no sense, that's why.
I'll re-re-do it within the hour. Sorry about that.
-Andy
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2015-12-30 16:09:50 | Re: cannot get stable function to use index |
Previous Message | Andy Colson | 2015-12-30 15:55:38 | Re: cannot get stable function to use index |