On 03.03.2013 20:06, Kevin Grittner wrote:
The question remains the same, though ... document this usage?
Seems like a good thing to put in an example somewhere.
- Heikki
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.po
Kevin Grittner wrote:
> test=# explain analyze select word from words order by word <-> 'caterpiler'
> limit 10;
> Foreign Scan on words
> Total runtime: 218.966 ms
> test=# explain analyze select word from wrd order by word <-> 'caterpiler'
> limit 10;
> Index Scan using wrd_trgm on wrd
> T
In final testing and documentation today, it occurred to me to test
a materialized view with foreign data wrapper. I picked the
file_fdw for convenience, but I think this should work as well with
any other FDW. The idea is to create an MV which mirrors an FDW so
that it can be indexed and quickly
