Re: [HACKERS] share info between backends

2007-01-12 Thread Andrew Dunstan
Zeugswetter Andreas ADI SD wrote: > >> > > comments? >> > >> > Why not make it probabilistic by using, say, MyProcPid % n where n > is the >> > number of tablespaces? Then you don't need anything shared. > > You still want a (local) counter, so that temp files for one session are > spread out. >

Re: [HACKERS] share info between backends

2007-01-12 Thread Zeugswetter Andreas ADI SD
> > > comments? > > > > Why not make it probabilistic by using, say, MyProcPid % n where n is the > > number of tablespaces? Then you don't need anything shared. You still want a (local) counter, so that temp files for one session are spread out. Andreas ---(end of broad

Re: [HACKERS] share info between backends

2007-01-11 Thread Jaime Casanova
On 1/11/07, Andrew Dunstan <[EMAIL PROTECTED]> wrote: Jaime Casanova wrote: > > i'm trying to fix a problem related to the patch Albert sent in > october (Tablespace for temporary objects and sort files) > http://archives.postgresql.org/pgsql-patches/2006-10/msg00141.php > http://archives.postgre

Re: [HACKERS] share info between backends

2007-01-11 Thread Andrew Dunstan
Jaime Casanova wrote: > > i'm trying to fix a problem related to the patch Albert sent in > october (Tablespace for temporary objects and sort files) > http://archives.postgresql.org/pgsql-patches/2006-10/msg00141.php > http://archives.postgresql.org/pgsql-patches/2007-01/msg00063.php > > after rev

Re: [HACKERS] share info between backends

2007-01-11 Thread Jaime Casanova
On 1/11/07, Martijn van Oosterhout wrote: On Thu, Jan 11, 2007 at 12:58:01AM -0500, Jaime Casanova wrote: > Hi, > > i'm trying to share some info between backends but i cannot figure how > to do it... > i was reading bgwriter.c and autovacuum.c hoping there is something > that can show me the wa

Re: [HACKERS] share info between backends

2007-01-11 Thread Martijn van Oosterhout
On Thu, Jan 11, 2007 at 12:58:01AM -0500, Jaime Casanova wrote: > Hi, > > i'm trying to share some info between backends but i cannot figure how > to do it... > i was reading bgwriter.c and autovacuum.c hoping there is something > that can show me the way to go... Well, there's a shared memory bl

[HACKERS] share info between backends

2007-01-10 Thread Jaime Casanova
Hi, i'm trying to share some info between backends but i cannot figure how to do it... i was reading bgwriter.c and autovacuum.c hoping there is something that can show me the way to go... can you, please, guide me on this? -- regards, Jaime Casanova "Programming today is a race between softwa