Обсуждение: temp file 1TB size

Поиск
Список
Период
Сортировка

temp file 1TB size

От
Artem Tomyuk
Дата:
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

От
Tom Lane
Дата:
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