temporary file

From: Artem Tomyuk <admin(at)leboutique(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: temporary file
Date: 2015-10-09 11:33:00
Message-ID: CANYYVqJfos0K-r-eAqXLhF3_e8q4p_7oMZc6Fk-+CQrKDJ=PWA@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi.

The questions is how to avoid creating temp files on disk?

The work_mem parameter set to 1600 Megabytes, but on logs i still can see
the messages like:
LOG: temporary file: path "base/pgsql_tmp/pgsql_tmp7905.2", size 865869824

Thanks

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Albe Laurenz 2015-10-09 12:53:46 Re: temporary file
Previous Message lst_hoe02 2015-10-08 19:35:47 Re: Doubts PostgreSQL