Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Question: advice on using qual in my foreign data wrapper #188

Open
frbsfri opened this issue Jun 27, 2017 · 0 comments
Open

Question: advice on using qual in my foreign data wrapper #188

frbsfri opened this issue Jun 27, 2017 · 0 comments

Comments

@frbsfri
Copy link

frbsfri commented Jun 27, 2017

I wrote a foreign data wrapper for HDF5 files, I can perform any query on data. However, some queries are really slow.
for example this query takes Time: 12388,885 ms:

select "printerId", date,"ZPosition" from myforeigntable where ullid=54077217821;

printerId   |   date   | ZPosition
--------------+----------+------------------
FER921002231 | 20130102 |   -6
(1 row)

How should I write quals in my code? please give me an example of using quals and a good description.

Thanks,

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant