Re: temp file 1TB size - Mailing list pgsql-admin

From Tom Lane
Subject Re: temp file 1TB size
Date
Msg-id 14335.1458924685@sss.pgh.pa.us
Whole thread Raw
In response to temp file 1TB size  (Artem Tomyuk <admin@leboutique.com>)
List pgsql-admin
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


pgsql-admin by date:

Previous
From: Artem Tomyuk
Date:
Subject: temp file 1TB size
Next
From: "Pavlov, Vladimir"
Date:
Subject: MultiXact member wraparound protections