.011 rows=0 loops=1)
         Filter: (word = 'caterpiler'::text)
         Rows Removed by Filter: 99171
         Foreign File: /etc/dictionaries-common/words
         Foreign File Size: 938848
 Total runtime: 26.081 ms</PRE
><P>

    If the materialized view is used instead, the query is much faster:

</P><PRE
CLASS="PROGRAMLISTING"
> Aggregate  (cost=4.44..4.45 rows=1 width=0) (actual time=0.074..0.074 rows=1 loops=1)
   -&#62;  Index Only Scan using wrd_word on wrd  (cost=0.42..4.44 rows=1 width=0) (actu