user1322133
Reputation:
Creating Index on Foreign Table of file_fdw in PostgreSQL
I have created a foreign table for file_fdw in PostgreSQL to access 100m dataset. I saw that there is no way to create an index on the foreign table.
Is there any way to speed up the query on the foreign table like indexing? thanks.
Upvotes: 1
Views: 892
Answers (1)
Laurenz Albe
Reputation: 247235
No. What you can do it create a materialized view (which is a copy in a PostgreSQL table) and index that.
Upvotes: 1
Related Questions
- How to use index in foreign table SELECT MAX(id) query in PostgreSQL?
- Create foreign table on file_fdw as non-superuser
- How to create an index in postgresql on joined tables?
- Indexing all columns which are foreign key to a table
- How would you create a unique index on a foreign table?
- Join on file_fdw foreign table and postgres_fdw foreign table
- Create index on foreign table PostgreSQL
- PostgreSQL: How to index all foreign keys?
- Index inside a table postgreSQL
- postgres create an index