(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
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
