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-hackers/2007-01/msg00531.php > http://archives.postgresql.org/pgsql-patches/2007-01/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