Hi Benjamin, It looks you are facing disk space issue for queries. In order to avid the disk space issue you can do the following. 1) Increase the work_mem parameter session level before executing the queries. 2) If you observe diskspace issue particular user queries,increase the work_mem parameter user level. 3) Check with developer to tune the query.
On Wed, Jun 3, 2015 at 6:41 PM, amulsul <sul_a...@yahoo.co.in> wrote: > 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. > > > -- > Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-performance >
