| From: | "Andrew Dunstan" <andrew(at)dunslane(dot)net> |
|---|---|
| To: | "Jaime Casanova" <systemguards(at)gmail(dot)com> |
| Cc: | "Martijn van Oosterhout" <kleptog(at)svana(dot)org>, "Pgsql Hackers" <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: share info between backends |
| Date: | 2007-01-11 12:54:24 |
| Message-ID: | 63036.24.211.165.134.1168520064.squirrel@www.dunslane.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
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 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?
>
Why not make it probabilistic by using, say, MyProcPid % n where n is the
number of tablespaces? Then you don't need anything shared.
cheers
andrew
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2007-01-11 14:01:09 | Re: [HACKERS] [PATCHES] wal_checksum = on (default) | off |
| Previous Message | Jaime Casanova | 2007-01-11 12:21:49 | Re: share info between backends |