Postgres Pro
Downloads
Home   >   mailing lists

temp file 1TB size - Mailing list pgsql-admin

From Artem Tomyuk
Subject temp file 1TB size
Date
Msg-id CANYYVqLMjGjLwZ7wFYH8SoZk3D4SveaPA5hUtnDtCQx3z5-5dQ@mail.gmail.com
Whole thread Raw
Responses Re: temp file 1TB size  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-admin
Tree view
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

pgsql-admin by date:

Previous
From: jonescam
Date:
Subject: New Tool - Looking for BETA Testers!
Next
From: Tom Lane
Date:
Subject: Re: temp file 1TB size