=?UTF-8?B?TWFyY2luIE1pcm9zxYJhdw==?= <marcin(at)mejor(dot)pl> writes:
> and i noticed that temporary files for new index are creating in tb_1
> not tb_2.
Actually they're spread semi-randomly across all available tablespaces.
IIRC there's a parameter you can set to control which tablespaces are
used for temp files, if you care.
regards, tom lane