Re: [WIP] GUC for temp_tablespaces

On 5/8/07, Peter Eisentraut <peter_e@gmx.net> wrote:
> Am Samstag, 5. Mai 2007 16:40 schrieb Jaime Casanova:
> > On 5/5/07, Bruce Momjian <bruce@momjian.us> wrote:
> > > Your patch has been added to the PostgreSQL unapplied patches list at:
> >
> > This is final version of the patch (i hope), at least it fixes the
> > problem i had yesterday.
>
> What I have been missing all along in these patches is an explanation for what
> it means to list multiple temporary tablespaces.  Are they used in order, or
> the first one that exists, or what?
>

http://archives.postgresql.org/pgsql-hackers/2007-01/msg00531.php
http://archives.postgresql.org/pgsql-patches/2007-01/msg00282.php

in src/backend/commands/tablespace.c:assign_temp_tablespaces():

   /*
     * Select the first tablespace to use
     */
    Assert(num_temp_tablespaces >= 0);
    if (num_temp_tablespaces != 0)
        next_temp_tablespace = MyProcPid % num_temp_tablespaces;


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