"Jaime Casanova" <[EMAIL PROTECTED]> writes: > On 6/4/07, Tom Lane <[EMAIL PROTECTED]> wrote: >> Perhaps a reasonable compromise could work like this: at the first point >> in a transaction where a temp file is created, choose a random list >> element, and thereafter advance cyclically for the duration of that >> transaction.
> ok. are you doing this? or can i prepare a patch that implements this? > i guess we can allocate the memory for the list in TopTransactionContext. I'll work on it ... I want to rejigger the API between fd.c and tablespace.c anyway. (fd.c still shouldn't be calling tablespace.c ...) regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match