Re: DISCARD ALL ; stored procedures - Mailing list pgsql-hackers

From Robert Haas
Subject Re: DISCARD ALL ; stored procedures
Date
Msg-id AANLkTi=2cWaESwzKH71LyV--+XDV6B6zbT54Ng4pwHxE@mail.gmail.com
Whole thread Raw
In response to Re: DISCARD ALL ; stored procedures  (Stephen Frost <sfrost@snowman.net>)
Responses Re: DISCARD ALL ; stored procedures  (Stephen Frost <sfrost@snowman.net>)
List pgsql-hackers
On Thu, Jan 6, 2011 at 5:22 PM, Stephen Frost <sfrost@snowman.net> wrote:
> If it's "performance" vs. "correctness", you can guess what I'm going to
> vote for, however, in this case, I can't see how either of the other
> options would perform better than a discard-like approach.  If people
> are already using 'discard all;' then they're already throwing away
> their plans for prepared queries, it strikes me as unlikely that they'd
> have an issue with also getting rid of stored procedure plans.  If they
> do, they could certainly use the individual 'discard' statements
> instead (presuming we implement this with a new discard argument).

If DISCARD ALL doesn't flush this stuff, I'd consider that an outright
bug.  Does it?

--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company


pgsql-hackers by date:

Previous
From: Stephen Frost
Date:
Subject: Re: DISCARD ALL ; stored procedures
Next
From: Heikki Linnakangas
Date:
Subject: Re: Streaming base backups