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

From Etsuro Fujita
Subject Re: Proposal: Create index on foreign table
Date
Msg-id 4F66C5B5.9030208@lab.ntt.co.jp
Whole thread Raw
In response to Re: Proposal: Create index on foreign table  (David Fetter <david@fetter.org>)
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


pgsql-hackers by date:

Previous
From: Etsuro Fujita
Date:
Subject: Re: Proposal: Create index on foreign table
Next
From: Dimitri Fontaine
Date:
Subject: Re: Command Triggers, patch v11