One-time plans - Mailing list pgsql-hackers

From Simon Riggs
Subject One-time plans
Date
Msg-id 1175523452.4386.1055.camel@silverbirch.site
Whole thread Raw
Responses Re: One-time plans  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
ISTM we've just invented the concept of one-time plans to allow CREATE
INDEX to work effectively with HOT.

I'd like to extend that thought back over towards constraint exclusion.
Currently we don't allow STABLE functions to be used for constraint
exclusion because that mean plans were valid only if they are
immediately executed.

It seems like a very small act to force the plan to be one-time only
when we have successfully used a STABLE function to exclude a table.

--  Simon Riggs              EnterpriseDB   http://www.enterprisedb.com




pgsql-hackers by date:

Previous
From: Oscar Täckström
Date:
Subject: Statistics on views (execute a plan from within analyze)
Next
From: Martijn van Oosterhout
Date:
Subject: Re: Statistics on views (execute a plan from within analyze)