Re: "AND", "OR" and Materialize :((((

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Meszaros Attila <tilla(at)draconis(dot)elte(dot)hu>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: "AND", "OR" and Materialize :((((
Date: 2001-08-26 15:51:23
Message-ID: 18622.998841083@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Meszaros Attila <tilla(at)draconis(dot)elte(dot)hu> writes:
> WHY SHALL IT MATERIALIZE A CONSTANT RESULT IN A LOOP OF 120000 TIMES ??
> [it would be enough to materialize only once,

Which in fact is exactly what the materialize node is for. The reported
costs are pretty bogus, but AFAICT the plan is the right thing.

regards, tom lane

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Meszaros Attila 2001-08-26 18:09:59 Re: "AND", "OR" and Materialize :((((
Previous Message Tom Lane 2001-08-26 15:44:54 Re: Different Choices For Index/Sequential Scan With And Without A Join In 7.2