Performance differences between fdw and view+fdw
От | Elías David |
---|---|
Тема | Performance differences between fdw and view+fdw |
Дата | |
Msg-id | CANNE3r0pz+hOmHQd6EkvVtr3y+yXGx+vDkg12niOQw5iO-h9Lg@mail.gmail.com обсуждение исходный текст |
Список | pgsql-admin |
Hello all,
I'm trying to understand a behavior I'm currently seeing while testing mongo's fdw (using the mongo-c-driver 1.0 version).
Say I have a foreign table with 50 columns and 14000 rows, I also have a view that does basically the same thing as querying the foreign table directly except for a few castings.
Working with the foreign table directly, a query like select * from foreign_table takes like 7 seconds, doing the same query but against the view takes like 8.5 seconds
Another example, a select * from foreign_table where col = 'something' takes like 12 ms but doing the same against the view takes like 110ms.
The only thing I could put the blame on when using the view is that inside is the same query as working with the foreign table but I use casts for a few columns like select col::text from foreign_table...
I don't know if anyone has tried mongo_fdw or something similar but I would like to know if this behavior is normal and more importantly why the view seems inefficient compared to query the foreign table directly (and without casts)
Thanks in advance!!
В списке pgsql-admin по дате отправления: