Home > mailing lists

temporary file - Mailing list pgsql-admin

From	Artem Tomyuk
Subject	temporary file
Date	October 9, 2015 14:33:30
Msg-id	CANYYVqJfos0K-r-eAqXLhF3_e8q4p_7oMZc6Fk-+CQrKDJ=PWA@mail.gmail.com Whole thread Raw
Responses	Re: temporary file (Albe Laurenz <laurenz.albe@wien.gv.at>)
List	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

From: lst_hoe02@kwsoft.de
Date: 08 October 2015, 22:52:15
Subject: Re: Doubts PostgreSQL

From: Albe Laurenz
Date: 09 October 2015, 15:53:50
Subject: Re: temporary file