| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Artem Tomyuk <admin(at)leboutique(dot)com> |
| Cc: | pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: temp file 1TB size |
| Date: | 2016-03-25 16:51:25 |
| Message-ID: | 14335.1458924685@sss.pgh.pa.us |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
Artem Tomyuk <admin(at)leboutique(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Pavlov, Vladimir | 2016-03-29 13:25:06 | MultiXact member wraparound protections |
| Previous Message | Artem Tomyuk | 2016-03-25 15:43:36 | temp file 1TB size |