Hi,
Is there any way to force the query planner to do a materialisation stage?
I have a query that joins two views, and takes 28 seconds to run.
However if I create temporary tables that contain the contents of each
view, and then join them, the total time is 1.3 seconds.
Is there a way to hint to the query planner that it should be taking
that approach?
Thanks,
Toby
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
