Postgres Pro
Downloads
Home   >   mailing lists

Forcing materialize in the planner - Mailing list pgsql-general

From Robert James
Subject Forcing materialize in the planner
Date
Msg-id CAGYyBgii9UuHVafw=FW30Kuk2L4MJawCCAHjQJj1UeC_RvDYVg@mail.gmail.com
Whole thread Raw
Responses Re: Forcing materialize in the planner  (Jack Christensen <jack@jackchristensen.com>)
List pgsql-general
Tree view 
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?

pgsql-general by date:

Previous
From: Robert James
Date:
Subject: Re: Escape string for LIKE op
Next
From: Beena Emerson
Date:
Subject: Re: devide and summarize sql result (all)