Thread: Shared Data Structure b/w clients

Shared Data Structure b/w clients

From
Rohit Goyal
Date:
Hi All,

I am working on postgresql code and having some problem. :)

I need to create shared data structure, so that different client and connection can update and share the state of those data structures in memory. I planned to use top memory context but it can give me shared structure within one session/terminal.

Please tel me how  postgresql do that and how i can do that?

Regards,
Rohit Goyal

Re: Shared Data Structure b/w clients

From
Atri Sharma
Date:


On Tuesday, July 22, 2014, Rohit Goyal <rhtgyl.87@gmail.com> wrote:
Hi All,

I am working on postgresql code and having some problem. :)

I need to create shared data structure, so that different client and connection can update and share the state of those data structures in memory. I planned to use top memory context but it can give me shared structure within one session/terminal.

Please tel me how  postgresql do that and how i can do that?

Regards,
Rohit Goyal

How about making it a part of shared mem, like shared buffers?

Regards,

Atri 


--
Regards,
 
Atri
l'apprenant

Re: Shared Data Structure b/w clients

From
Rohit Goyal
Date:
Hi Atri/All,

I am very new in postgresql code. Can you please help in a bit detail ortel me how to create structure in shared memory(shared buffer).

It would be really easy for me if you can give me a code snippet or any link to follow.

Regards,
Rohit Goyal


On Tue, Jul 22, 2014 at 8:30 PM, Atri Sharma <atri.jiit@gmail.com> wrote:


On Tuesday, July 22, 2014, Rohit Goyal <rhtgyl.87@gmail.com> wrote:
Hi All,

I am working on postgresql code and having some problem. :)

I need to create shared data structure, so that different client and connection can update and share the state of those data structures in memory. I planned to use top memory context but it can give me shared structure within one session/terminal.

Please tel me how  postgresql do that and how i can do that?

Regards,
Rohit Goyal

How about making it a part of shared mem, like shared buffers?

Regards,

Atri 


--
Regards,
 
Atri
l'apprenant




--
Regards,
Rohit Goyal

Re: Shared Data Structure b/w clients

From
Jaime Casanova
Date:
On Tue, Jul 22, 2014 at 1:33 PM, Rohit Goyal <rhtgyl.87@gmail.com> wrote:
> Hi Atri/All,
>
> I am very new in postgresql code. Can you please help in a bit detail ortel
> me how to create structure in shared memory(shared buffer).
>
> It would be really easy for me if you can give me a code snippet or any link
> to follow.
>

you can look at contrib/pg_stat_statements

--
Jaime Casanova         www.2ndQuadrant.com
Professional PostgreSQL: Soporte 24x7 y capacitación
Phone: +593 4 5107566         Cell: +593 987171157



Re: Shared Data Structure b/w clients

From
Craig Ringer
Date:
On 07/23/2014 02:33 AM, Rohit Goyal wrote:
> 
> I am very new in postgresql code. Can you please help in a bit detail
> ortel me how to create structure in shared memory(shared buffer).
> 
> It would be really easy for me if you can give me a code snippet or any
> link to follow.
> 

There's a lot of detail on how to do this in the BDR codebase, see
contrib/bdr in
http://git.postgresql.org/gitweb/?p=2ndquadrant_bdr.git;a=summary

-- Craig Ringer                   http://www.2ndQuadrant.com/PostgreSQL Development, 24x7 Support, Training & Services



Re: Shared Data Structure b/w clients

From
Craig Ringer
Date:
On 07/23/2014 09:46 AM, Craig Ringer wrote:
> There's a lot of detail on how to do this in the BDR codebase, see
> contrib/bdr in
> http://git.postgresql.org/gitweb/?p=2ndquadrant_bdr.git;a=summary

Oh, sorry: in the bdr-next branch. Should've mentioned.


http://git.postgresql.org/gitweb/?p=2ndquadrant_bdr.git;a=tree;f=contrib/bdr;h=fad1aa59a15724deb98f9b923d84f0ce818afc1f;hb=refs/heads/bdr-next

-- Craig Ringer                   http://www.2ndQuadrant.com/PostgreSQL Development, 24x7 Support, Training & Services