(word gist_trgm_ops);
VACUUM ANALYZE wrd;</PRE
><P>

    Now let's spell-check a word.  Using <TT
CLASS="LITERAL"
>file_fdw</TT
> directly:

</P><PRE
CLASS="PROGRAMLISTING"
>SELECT count(*) FROM words WHERE word = 'caterpiler';

 count 
-------
     0
(1 row)</PRE
><P>

    The plan is:

</P><PRE
CLASS="PROGRAMLISTING"
> Aggregate  (cost=4125.19..4125.20 rows=1 width=0) (actual time=26.013..26.014 rows=1 loops=1)
   -&#62;  Foreign Scan on words  (cost=0.00..4124.70 rows=196 width=0) (actual time=26.011..26