Re: How to reduce writing on disk ? (90 gb on pgsql_tmp)

From: amulsul <sul_amul(at)yahoo(dot)co(dot)in>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: How to reduce writing on disk ? (90 gb on pgsql_tmp)
Date: 2015-06-03 13:11:22
Message-ID: 1433337082772-5852328.post@n5.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

SQLSTATE[53100]: Disk full: 7 ERROR: could not write block 1099247 of
temporary file

Its looks like there is no room to write temporary file, try with limiting
temporary file size by setting temp_file_limit GUC.

--
View this message in context: http://postgresql.nabble.com/How-to-reduce-writing-on-disk-90-gb-on-pgsql-tmp-tp5852321p5852328.html
Sent from the PostgreSQL - performance mailing list archive at Nabble.com.

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message chiru r 2015-06-03 13:27:11 Re: How to reduce writing on disk ? (90 gb on pgsql_tmp)
Previous Message David G. Johnston 2015-06-03 12:44:23 Re: How to reduce writing on disk ? (90 gb on pgsql_tmp)