Forcing materialize in the planner

From: Robert James <srobertjames(at)gmail(dot)com>
To: Postgres General <pgsql-general(at)postgresql(dot)org>
Subject: Forcing materialize in the planner
Date: 2013-08-15 22:40:59
Message-ID: CAGYyBgii9UuHVafw=FW30Kuk2L4MJawCCAHjQJj1UeC_RvDYVg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I have a query which, when I materialize by hand some of its
components, runs 10x faster (including the time needed to
materialize). Is there any way to force Postgres to do that? Or do I
need to do this by hand using temp tables?

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Beena Emerson 2013-08-16 03:48:34 Re: devide and summarize sql result (all)
Previous Message Robert James 2013-08-15 22:39:57 Re: Escape string for LIKE op