On Sun, Jul 26, 2009 at 1:02 AM, Greg Caulton wrote:
> Hello,
>
> It seems to me that the following query should be a lot faster. This runs
> in 17 seconds (regardless how many times I run it)
>
> select ac.* from application_controls_view ac, refs r where
> ac.cus
Hello,
It seems to me that the following query should be a lot faster. This runs
in 17 seconds (regardless how many times I run it)
select ac.* from application_controls_view ac, refs r where
ac.custom_controller_ref_id = r.ref_id and r.ref_key like '%XYZ%';
if I do not use the view the query r
btree
(term_index );
thanks again
Greg
On Mon, Oct 6, 2008 at 7:59 PM, Kevin Grittner
<[EMAIL PROTECTED]> wrote:
>>>> "Greg Caulton" <[EMAIL PROTECTED]> wrote:
>
>> but I get a sequential scan when I do where term_index like
>>
>> select *
Hi,
I have a table sct_descriptions which I have vacuumed, analyzed and
reindexed. The index is on term_index
INFO: analyzing "public.sct_descriptions"
INFO: "sct_descriptions": scanned 3000 of 22861 pages, containing
91877 live rows and 0 dead rows; 3000 rows in sample, 700133 estimated
total
