Artem Tomyuk <admin@xxxxxxxxxxxxxx> 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 -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
