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 David J. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
