On Thu, Jun 11, 2015 at 5:56 AM, ben.play <benjamin(dot)cohen(at)playrion(dot)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