Re: Proposal: Create index on foreign table - Mailing list pgsql-hackers

(2012/03/17 2:07), David Fetter wrote:
> On Fri, Mar 16, 2012 at 11:58:29AM +0200, Heikki Linnakangas wrote:
>> On 16.03.2012 10:44, Etsuro Fujita wrote:

>>> For a flat file, CREATE INDEX constructs
>>> an index in the same way as an index for a regular table.

>> For starters, how would you keep the index up-to-date when the flat
>> file is modified?

> One way is to poll the remote source for evidence of such changes
> during auto_vacuum or with similar daemon processes.  Another is by
> waiting for a signal from an external source such as a NOTIFY.  Which
> is more appropriate will again depend on circumstances.

I think that's a good idea.  I'd like to work on it in the future.

Best regards,
Etsuro Fujita