Postgres Pro
Downloads
Home   >   mailing lists

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

From Claudio Freire
Subject Re: How to reduce writing on disk ? (90 gb on pgsql_tmp)
Date
Msg-id CAGTBQpZoZemBRH7LRg=AnUn_RPa-QhjuoeBL9KJhNePmh6_nCQ@mail.gmail.com
Whole thread Raw
In response to Re: How to reduce writing on disk ? (90 gb on pgsql_tmp)  ("ben.play" <benjamin.cohen@playrion.com>)
List pgsql-performance
Tree view 
On Thu, Jun 11, 2015 at 5:56 AM, ben.play <benjamin.cohen@playrion.com> wrote:
> 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.

You can do it with the PGOPTIONS environment variable:

PGOPTIONS="-c temp_tablespaces=blabla" psql some_db -f some_script.sql

pgsql-performance by date:

Previous
From: "ben.play"
Date:
Subject: Re: How to reduce writing on disk ? (90 gb on pgsql_tmp)
Next
From: Sasa Vilic
Date:
Subject: Slow query: Postgres chooses nested loop over hash join, whery by hash join is much faster, wrong number of rows estimated