Re: temp file 1TB size

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