| From: | Elías David <elias(dot)moreno(dot)tec(at)gmail(dot)com> |
|---|---|
| To: | pgsql-admin <pgsql-admin(at)postgresql(dot)org> |
| Subject: | Performance differences between fdw and view+fdw |
| Date: | 2015-08-03 03:46:57 |
| Message-ID: | CANNE3r0pz+hOmHQd6EkvVtr3y+yXGx+vDkg12niOQw5iO-h9Lg@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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!!
| From | Date | Subject | |
|---|---|---|---|
| Next Message | jkilborn | 2015-08-04 12:46:37 | postgres not deleting trigger file |
| Previous Message | John Scalia | 2015-07-31 12:40:33 | Re: Autovacuum behavior |