Am Mittwoch, 9. Mai 2007 02:21 schrieb Jaime Casanova:
> > 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...1/msg00531.php
> http://archives.postgresql.org/pgsql...1/msg00282.php

Those are discussions of possible ideas, not an acceptable documentation of
this feature.

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

That also isn't an acceptable place to put feature documentation.

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

What does this mean? Is there code that selects the second tablespace to use?

--
Peter Eisentraut
http://developer.postgresql.org/~petere/

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend