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

From: "ben(dot)play" <benjamin(dot)cohen(at)playrion(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: How to reduce writing on disk ? (90 gb on pgsql_tmp)
Date: 2015-06-11 08:56:21
Message-ID: 1434012981270-5853337.post@n5.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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.

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Claudio Freire 2015-06-11 12:48:07 Re: How to reduce writing on disk ? (90 gb on pgsql_tmp)
Previous Message Merlin Moncure 2015-06-10 22:08:10 Re: Row estimates off by two orders of magnitude with hstore