From: | "Jaime Casanova" <systemguards(at)gmail(dot)com> |
---|---|
To: | "Martijn van Oosterhout" <kleptog(at)svana(dot)org> |
Cc: | "Pgsql Hackers" <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: share info between backends |
Date: | 2007-01-11 12:21:49 |
Message-ID: | c2d9e70e0701110421i5eefaa7ck627d4267e5ff1c71@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
On 1/11/07, Martijn van Oosterhout <kleptog(at)svana(dot)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 show me the way to go...
>
> Well, there's a shared memory block, but getting access to it is not
> easy. Using a table may to easier, but you'll need to provide more
> details if you want more help.
>
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 this i notice this will not use different tablespaces
in the case of having various connections all with just one temp
table:
http://archives.postgresql.org/pgsql-patches/2007-01/msg00188.php
what i'm trying to do it is share what's the next_temp_tablespace to use...
the other way to do this is as you say using tables, but i don't think
this is a good idea in this case...
comments?
--
regards,
Jaime Casanova
"Programming today is a race between software engineers striving to
build bigger and better idiot-proof programs and the universe trying
to produce bigger and better idiots.
So far, the universe is winning."
Richard Cook
From | Date | Subject | |
---|---|---|---|
Next Message | Andrew Dunstan | 2007-01-11 12:54:24 | Re: share info between backends |
Previous Message | Magnus Hagander | 2007-01-11 12:15:56 | Re: [COMMITTERS] pgsql: Stamp major release 8.3.0, |