Re: How to reduce writing on disk ? (90 gb on pgsql_tmp)
| От | chiru r |
|---|---|
| Тема | Re: How to reduce writing on disk ? (90 gb on pgsql_tmp) |
| Дата | |
| Msg-id | CA+RSxMiSwse+YfMoFT8128PoWG3kifmrvg4rhdBHxUTE3HPH-g@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: How to reduce writing on disk ? (90 gb on pgsql_tmp) (amulsul <sul_amul@yahoo.co.in>) |
| Ответы |
Re: How to reduce writing on disk ? (90 gb on pgsql_tmp)
|
| Список | pgsql-performance |
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_amul@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.htmlSent 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
В списке pgsql-performance по дате отправления: