Postgres Pro
Downloads
Home   >   mailing lists

Thread: temp file 1TB size

temp file 1TB size

From
Artem Tomyuk
Date:
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

Re: temp file 1TB size

From
Tom Lane
Date:
Artem Tomyuk <admin@leboutique.com> writes:
> 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

Those sizes are in bytes, not kB.  Do you see some documentation saying
the other?

            regards, tom lane