Postgres Pro
Downloads
Home   >   mailing lists

Re: "AND", "OR" and Materialize :(((( - Mailing list pgsql-sql

From Tom Lane
Subject Re: "AND", "OR" and Materialize :((((
Date
Msg-id 18622.998841083@sss.pgh.pa.us
Whole thread Raw
In response to "AND", "OR" and Materialize :((((  (Meszaros Attila <tilla@draconis.elte.hu>)
Responses Re: "AND", "OR" and Materialize :((((  (Meszaros Attila <tilla@draconis.elte.hu>)
List pgsql-sql
Tree view 
Meszaros Attila <tilla@draconis.elte.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

pgsql-sql by date:

Previous
From: Tom Lane
Date:
Subject: Re: Different Choices For Index/Sequential Scan With And Without A Join In 7.2
Next
From: Meszaros Attila
Date:
Subject: Re: "AND", "OR" and Materialize :((((