On 02/10/12 12:44, David Johnston wrote:
On Oct 1, 2012, at 22:33, Toby Corkindale <toby.corkindale@xxxxxxxxxxxxxxxxxxxx> wrote:
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
Have you tried?
With v1 as (), v2 as () select v1 join v2
Hi David,
I just tried that now, and it ran in 350ms; much faster than even the
temporary-table-creating method.
thanks!
Toby
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
