Re: [PERFORM] How to reduce writing on disk ? (90 gb on pgsql_tmp)

2015-06-09 Thread Claudio Freire
On Tue, Jun 9, 2015 at 12:58 PM, ben.play wrote: > Hi, > > Thank you a lot for your answer. > I've done that (create a tablespace in another HD with POSTGRES role + put > it as the main temp_tablespace in the conf). > > But ... my command ~# df show me that all queries use the default tablespace >

Re: [PERFORM] How to reduce writing on disk ? (90 gb on pgsql_tmp)

2015-06-09 Thread ben.play
Hi, Thank you a lot for your answer. I've done that (create a tablespace in another HD with POSTGRES role + put it as the main temp_tablespace in the conf). But ... my command ~# df show me that all queries use the default tablespace ... This was my commands (the directory is owned by postgre