Re: [GENERAL] Difficult while acquiring LWLocks

2017-05-03 Thread Julien Rouhaud
On 03/05/2017 15:01, hariprasath nallasamy wrote:
> 
> AFAIK yes this is the correct way to use multiple lwlocks.
> 
> 
> Thanks.!
> 
> Just curious, Is there any other way to do this.? 

Probably no, except asking for 10 different tranches :)

-- 
Julien Rouhaud
http://dalibo.com - http://dalibo.org


-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general


Re: [GENERAL] Difficult while acquiring LWLocks

2017-05-03 Thread hariprasath nallasamy
> AFAIK yes this is the correct way to use multiple lwlocks.
>

Thanks.!

Just curious, Is there any other way to do this.?


Re: [GENERAL] Difficult while acquiring LWLocks

2017-05-03 Thread Julien Rouhaud
On 03/05/2017 13:08, hariprasath nallasamy wrote:
> Hi all
>There is an use case, where i want some 10 LightWeight Locks and
> after 9.6 LW locks api's (LWLockAssign) are changed a bit and i am
> confused too.
> 
>  Only reference i cant get was from pg_stat_statement :(
> 
> Since GetNamedLWLockTranche method will return the base address of the
> specified tranche.
> 
> From pg_init
> *" RequestNamedLWLockTranche("Some_10_LWLocks", 10); "
> 
> 
> *For getting those locks which were requested from pg_init
> *" LWLockPadded *lwLockPadded = GetNamedLWLockTranche("Some_10_LWLocks");
>LWLock *lock = &(lwLockPadded[index in 0 to 9]).lock; "*
> 
> Is the above code snippet a valid for requesting some 10 LWLocks?
> 
> 

AFAIK yes this is the correct way to use multiple lwlocks.

-- 
Julien Rouhaud
http://dalibo.com - http://dalibo.org


-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general


[GENERAL] Difficult while acquiring LWLocks

2017-05-03 Thread hariprasath nallasamy
Hi all
   There is an use case, where i want some 10 LightWeight Locks and after
9.6 LW locks api's (LWLockAssign) are changed a bit and i am confused too.

 Only reference i cant get was from pg_stat_statement :(

Since GetNamedLWLockTranche method will return the base address of the
specified tranche.

>From pg_init



*" RequestNamedLWLockTranche("Some_10_LWLocks", 10); "*For getting those
locks which were requested from pg_init

*" LWLockPadded *lwLockPadded = GetNamedLWLockTranche("Some_10_LWLocks");
LWLock *lock = &(lwLockPadded[index in 0 to 9]).lock; "*

Is the above code snippet a valid for requesting some 10 LWLocks?


TIA
 harry