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

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. Yes, but this can

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 block,

Re: [HACKERS] share info between backends

2007-01-11 Thread Jaime Casanova
On 1/11/07, Martijn van Oosterhout kleptog@svana.org 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

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 reviewing

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