Re: isTempNamespaceInUse() is incorrect with its handling of MyBackendId

2020-01-15 Thread Michael Paquier
On Tue, Jan 14, 2020 at 07:23:19AM +0900, Michael Paquier wrote: > Yes, I'd rather keep this routine in its simplest shape for now. If > the optimization makes sense, though in most cases it won't because it > just helps sessions to detect faster their own temp schema, then let's > do it. I'll le

Re: isTempNamespaceInUse() is incorrect with its handling of MyBackendId

2020-01-13 Thread Michael Paquier
On Mon, Jan 13, 2020 at 02:56:13PM +0100, Julien Rouhaud wrote: > Well, since isTempNamespaceInUse is for now only called by autovacuum, and > shouldn't change soon, this really feels premature optimzation, so your > original approach looks better. Yes, I'd rather keep this routine in its simplest

Re: isTempNamespaceInUse() is incorrect with its handling of MyBackendId

2020-01-13 Thread Julien Rouhaud
On Mon, Jan 13, 2020 at 10:14:52PM +0900, Michael Paquier wrote: > On Mon, Jan 13, 2020 at 01:09:01PM +0100, Julien Rouhaud wrote: > > But that means an extraneous call to BackendIdGetProc() in that > > case, it seems better to avoid it if we already have the information. > > Note that you cannot m

Re: isTempNamespaceInUse() is incorrect with its handling of MyBackendId

2020-01-13 Thread Michael Paquier
On Mon, Jan 13, 2020 at 01:09:01PM +0100, Julien Rouhaud wrote: > But that means an extraneous call to BackendIdGetProc() in that > case, it seems better to avoid it if we already have the information. Note that you cannot make a direct comparison of the result from GetTempNamespaceBackendId() wit

Re: isTempNamespaceInUse() is incorrect with its handling of MyBackendId

2020-01-13 Thread Julien Rouhaud
On Mon, Jan 13, 2020 at 06:37:03PM +0900, Michael Paquier wrote: > Hi all, > > While reviewing some code in namespace.c, I have bumped into the > following issue introduced by 246a6c8: > diff --git a/src/backend/catalog/namespace.c > b/src/backend/catalog/namespace.c > index c82f9fc4b5..e70243a008

isTempNamespaceInUse() is incorrect with its handling of MyBackendId

2020-01-13 Thread Michael Paquier
Hi all, While reviewing some code in namespace.c, I have bumped into the following issue introduced by 246a6c8: diff --git a/src/backend/catalog/namespace.c b/src/backend/catalog/namespace.c index c82f9fc4b5..e70243a008 100644 --- a/src/backend/catalog/namespace.c +++ b/src/backend/catalog/namespa