On Fri, Feb 26, 2010 at 7:03 PM, Tom Lane <[email protected]> wrote: > Robert Haas <[email protected]> writes: >> Basically, what I really want here is some kind of keyword or other >> syntax that I can stick into a PL/pgsql query that requests a replan >> on every execution. > > Wouldn't it be better if it just did the right thing automatically? > > The sort of heuristic I'm envisioning would essentially do "replan every > time" for some number of executions, and give up only if it noticed that > it wasn't getting anything better than the generic plan. So you'd have > a fixed maximum overhead per session when the custom plan was useless, > and the Right Thing when it wasn't.
Which is likely useless for my use case. ...Robert -- Sent via pgsql-hackers mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
