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

Поиск
Список
Период
Сортировка
От Claudio Freire
Тема Re: How to reduce writing on disk ? (90 gb on pgsql_tmp)
Дата
Msg-id CAGTBQpZoZemBRH7LRg=AnUn_RPa-QhjuoeBL9KJhNePmh6_nCQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: How to reduce writing on disk ? (90 gb on pgsql_tmp)  ("ben.play" <benjamin.cohen@playrion.com>)
Список pgsql-performance
Дерево обсуждения 
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 по дате отправления:

Предыдущее
От: "ben.play"
Дата:
Сообщение: Re: How to reduce writing on disk ? (90 gb on pgsql_tmp)
Следующее
От: Sasa Vilic
Дата:
Сообщение: Slow query: Postgres chooses nested loop over hash join, whery by hash join is much faster, wrong number of rows estimated