From: | Fabrízio de Royes Mello <fabriziomello(at)gmail(dot)com> |
---|---|
To: | Alvaro Herrera <alvherre(at)2ndquadrant(dot)com> |
Cc: | "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>, Josh Berkus <josh(at)agliodbs(dot)com>, pgsql-hackers <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: DISCARD ALL (Again) |
Date: | 2014-04-17 23:38:01 |
Message-ID: | CAFcNs+p+PMFhkiPTF1Xbz3neG8d0MtEnb021H2FUG049333LrQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
On Thu, Apr 17, 2014 at 6:51 PM, Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>
wrote:
>
> It does sounds a legitimate feature request to me. I don't remember if
> we honored the request to add resetting of cached sequences, though; if
> we didn't, this one is probably going to be tough too.
>
+1
> Another point is that to implement this I think there will need to be
> another per-PL entry point to discard session data; are we okay with
> that? Since this probably means a new column in pg_language, we
> couldn't even consider the idea of back-patching. Unless we add a hook,
> which is registered in the PL's _PG_init()?
>
This week I had some similar trouble, but using "dblink" and "pgbouncer".
As expected "DISCARD ALL" don't clear the extension resources.
I was thinking if is possible to every extension register his own "discard"
procedure and then the "DISCARD ALL" can execute all registered extension
cleanup procedures. Makes sense?
> Are we going to backpatch a doc change that says "releases all temporary
> resources, except for plptyhon's and plperl's GD"? Surely not ...
>
Maybe this doc can be like that:
"releases all temporary resources, except for extensions"
Grettings,
--
Fabrízio de Royes Mello
Consultoria/Coaching PostgreSQL
>> Timbira: http://www.timbira.com.br
>> Blog sobre TI: http://fabriziomello.blogspot.com
>> Perfil Linkedin: http://br.linkedin.com/in/fabriziomello
>> Twitter: http://twitter.com/fabriziomello
From | Date | Subject | |
---|---|---|---|
Next Message | Josh Berkus | 2014-04-17 23:42:21 | Re: How can we make beta testing better? |
Previous Message | David G Johnston | 2014-04-17 23:01:17 | Re: DISCARD ALL (Again) |