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 postgres) :
CREATE TABLESPACE hddtablespace LOCATION '/media/hdd/pgsql';
ALTER TABLESPACE hddtablespace OWNER TO postgres;
SHOW temp_tablespaces;
> hddtablespace
In /media/hdd/pgsql I have only one empty directory (PG_9.3_201306121).
Do you have any tips ?
Thanks a lot guys ...
--
View this message in context:
http://postgresql.nabble.com/How-to-reduce-writing-on-disk-90-gb-on-pgsql-tmp-tp5852321p5853081.html
Sent from the PostgreSQL - performance mailing list archive at Nabble.com.