Home > mailing lists

Log says temporary files are being created - Mailing list pgsql-admin

From	Campbell, Lance
Subject	Log says temporary files are being created
Date	June 22, 2016 18:50:57
Msg-id	B75CD08C73BD3543B97E4EF3964B7D70306CA2B3@CITESMBX1.ad.uillinois.edu Whole thread Raw
Responses	Re: Log says temporary files are being created
List	pgsql-admin

PostgreSQL 5.3.2

I am seeing entries like this appearing in my PostgreSQL log.

Log entry:

temporary file: path "base/pgsql_tmp/pgsql_tmp10336.0", size 17809408

1) Should this concern me?

2) What would I need to modify in my configuration in order to stop temporary file creation from occurring?

Thanks,

Lance

From: "Geo P.C."
Date: 22 June 2016, 16:41:37
Subject: Re: Too many Open files error for postgres

From: Artem Tomyuk
Date: 22 June 2016, 18:58:00
Subject: Re: Log says temporary files are being created