Re: One-Shot Plans - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: One-Shot Plans
Date
Msg-id 201106141828.p5EIS3t14078@momjian.us
Whole thread Raw
In response to One-Shot Plans  (Simon Riggs <simon@2ndQuadrant.com>)
Responses Re: One-Shot Plans
List pgsql-hackers
Simon Riggs wrote:
> Currently, the planner and executor are mostly independent of each
> other: the planner doesn't really know when the plan will be executed,
> and the executor doesn't know how recently the plan was made.
> 
> We can work out the various paths through the traffic cop to see when
> a plan will be a "one-shot" - planned and then executed immediately,
> then discarded.

I was also hoping someday allow plans that are to be immediately
executed to probe the buffer cache to determine how expensive index
scans would be.

--  Bruce Momjian  <bruce@momjian.us>        http://momjian.us EnterpriseDB
http://enterprisedb.com
 + It's impossible for everything to be true. +


pgsql-hackers by date:

Previous
From: Simon Riggs
Date:
Subject: One-Shot Plans
Next
From: Simon Riggs
Date:
Subject: Re: use less space in xl_xact_commit patch