On Thu, Jun 11, 2015 at 5:56 AM, ben.play <benjamin.co...@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 -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
