Could I write foreign wrapper in postgresql to enable it use third party index?

Question

I have created a foreign data wrapper to extend datatype of PostgreSQL, the data are retrieved from third party sdk and there exists index for the data, could I use the index directly ? thanks.

Closevoted "unclear what you're asking". This is too vague and general to be possible to answer usefully. Please describe in detail what the "third party sdk", the "index" that exists there, etc are, what the data is, what form you want to retrieve it in, etc. I think what you might be asking is When a user queries a foreign table with my FDW and supplies a WHERE clause that matches an index on the remote end, can my foreign data wrapper find out what the WHERE predicate is and execute it on the remote end?. That's a WAG though. — Craig Ringer
– Craig Ringer, Commented Jul 24, 2014 at 1:57
@Craig Ringer, this is exactly what I mean, I have such idea but do not know how to realize it, could you please provide some steps or documents about this? thanks, — user3419945
– user3419945, Commented Aug 1, 2014 at 8:08

Str. · Accepted Answer · 2014-07-23 20:59:13Z

1

An index is no value in itself, it points to the data. So I would say: wrong idea.

Unless there is something very special in third party sdk (?).

answered Jul 23, 2014 at 20:59

Str.

1,43911 silver badges14 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Could I write foreign wrapper in postgresql to enable it use third party index?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related