Luiz Gonzaga da Mata <[EMAIL PROTECTED]> writes:
> Although to have changed they sort_mem/work_mem it for 1 MB, it did not
> use this area in available memory for the connection to make the
> creation of the temporary table.
Why would you expect it to, and why would you think there is any
advantage? A small, short-lived temp table will probably never actually
be spilled to disk by the kernel (we never fsync them) so the actual
performance improvement would be minimal.
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
