pg.ddx.io pgsql-admin@postgresql.org mailing list archivehelp / color / mirror / Atom feed
temp file 1TB size 2+ messages / 2 participants [nested] [flat]
* temp file 1TB size @ 2016-03-25 15:43 Artem Tomyuk <admin@leboutique.com> 2016-03-25 16:51 ` Re: temp file 1TB size Tom Lane <tgl@sss.pgh.pa.us> 0 siblings, 1 reply; 2+ messages in thread From: Artem Tomyuk @ 2016-03-25 15:43 UTC (permalink / raw) To: pgsql-admin 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 ^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: temp file 1TB size 2016-03-25 15:43 temp file 1TB size Artem Tomyuk <admin@leboutique.com> @ 2016-03-25 16:51 ` Tom Lane <tgl@sss.pgh.pa.us> 0 siblings, 0 replies; 2+ messages in thread From: Tom Lane @ 2016-03-25 16:51 UTC (permalink / raw) To: Artem Tomyuk <admin@leboutique.com>; +Cc: 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 -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin ^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2016-03-25 16:51 UTC | newest] Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2016-03-25 15:43 temp file 1TB size Artem Tomyuk <admin@leboutique.com> 2016-03-25 16:51 ` Tom Lane <tgl@sss.pgh.pa.us>
This inbox is served by DDX for PostgreSQL; see mirroring instructions for how to clone and mirror all data and code used for this inbox