Postgres Pro
Downloads
Home   >   mailing lists

Re: Creating index on different tablespace and its temp files - Mailing list pgsql-novice

From Tom Lane
Subject Re: Creating index on different tablespace and its temp files
Date
Msg-id 22305.1286804850@sss.pgh.pa.us
Whole thread Raw
In response to Creating index on different tablespace and its temp files  (Marcin Mirosław <marcin@mejor.pl>)
Responses Re: Creating index on different tablespace and its temp files  (Marcin Mirosław <marcin@mejor.pl>)
List pgsql-novice
Tree view 
=?UTF-8?B?TWFyY2luIE1pcm9zxYJhdw==?= <marcin@mejor.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

pgsql-novice by date:

Previous
From: "Solaimurugan V."
Date:
Subject: Range of IP address specification in pg_hba.conf
Next
From: Josh Kupershmidt
Date:
Subject: Re: Range of IP address specification in pg_hba.conf