temp file 1TB size

From: Artem Tomyuk <admin(at)leboutique(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: temp file 1TB size
Date: 2016-03-25 15:43:36
Message-ID: CANYYVqLMjGjLwZ7wFYH8SoZk3D4SveaPA5hUtnDtCQx3z5-5dQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

PostgresSQL logged that query created temp file with size 1073741824 (as log
temporary files equalor larger than the specified size in kilobytes) which
is 1024 Gigabytes?
Is it possible????

===========>21992 127.0.0.1 postgres 2016-03-25 16:24:39 EET 00000
[21-1]LOG: temporary file: path "base/pgsql_tmp/pgsql_tmp21992.451",
size 1073741824
===========>21992 127.0.0.1 postgres 2016-03-25 16:24:40 EET 00000
[22-1]LOG: temporary file: path "base/pgsql_tmp/pgsql_tmp21992.452",
size 1073741824

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2016-03-25 16:51:25 Re: temp file 1TB size
Previous Message Scott Whitney 2016-03-24 19:42:58 Re: Running backups on a standby server