Hi, On 2 October 2012 12:33, Toby Corkindale <toby.corkindale@xxxxxxxxxxxxxxxxxxxx> wrote: > 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. try "offset 0" (or you can tweak statistics collector to get better estimates): select ... from (select * from view offset 0) as v .... http://blog.endpoint.com/2009/04/offset-0-ftw.html -- Ondrej Ivanic (ondrej.ivanic@xxxxxxxxx) -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
