Postgres Pro
Downloads
Home   >   mailing lists

Re: How to reduce writing on disk ? (90 gb on pgsql_tmp) - Mailing list pgsql-performance

From ben.play
Subject Re: How to reduce writing on disk ? (90 gb on pgsql_tmp)
Date
Msg-id 1434012981270-5853337.post@n5.nabble.com
Whole thread Raw
In response to Re: How to reduce writing on disk ? (90 gb on pgsql_tmp)  (Claudio Freire <klaussfreire@gmail.com>)
Responses Re: How to reduce writing on disk ? (90 gb on pgsql_tmp)
List pgsql-performance
Tree view 
Of course ! I'm an idiot ...

Thank you a lot !

A question : is it possible with Postgres to change the temp_tablespace only
for a session  (or page) ?
I have a cron which takes a lot of memory. I would like to say to PostGreSql
to use this temp_tablespace only on this command and not affect my user
experience.

Thank you a lot :)



--
View this message in context:
http://postgresql.nabble.com/How-to-reduce-writing-on-disk-90-gb-on-pgsql-tmp-tp5852321p5853337.html
Sent from the PostgreSQL - performance mailing list archive at Nabble.com.

pgsql-performance by date:

Previous
From: Merlin Moncure
Date:
Subject: Re: Row estimates off by two orders of magnitude with hstore
Next
From: Claudio Freire
Date:
Subject: Re: How to reduce writing on disk ? (90 gb on pgsql_tmp)