Skip site navigation (1) Skip section navigation (2)

One-time plans

From: "Simon Riggs" <simon(at)2ndquadrant(dot)com>
To: <pgsql-hackers(at)postgresql(dot)org>
Subject: One-time plans
Date: 2007-04-02 14:17:32
Message-ID: (view raw, whole thread or download thread mbox)
Lists: 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             


pgsql-hackers by date

Next:From: Martijn van OosterhoutDate: 2007-04-02 14:54:14
Subject: Re: Statistics on views (execute a plan from within analyze)
Previous:From: Pavan DeolaseeDate: 2007-04-02 12:21:13
Subject: HOT WIP Patch - version 6.3

Privacy Policy | About PostgreSQL
Copyright © 1996-2018 The PostgreSQL Global Development Group