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

From: "ben(dot)play" <benjamin(dot)cohen(at)playrion(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: How to reduce writing on disk ? (90 gb on pgsql_tmp)
Date: 2015-06-03 12:21:32
Message-ID: 1433334092106-5852321.post@n5.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Hi all,

We have a big database (more than 300 Gb) and we run a lot of queries each
minute.

However, once an hour, the (very complex) query writes A LOT on the disk
(more than 95 Gb !!!)
We have 64 Gb of RAM and this is our config :

And my error on the query is :

Do you know how to solve this problem ?

Best regards,
Benjamin.

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

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message David G. Johnston 2015-06-03 12:44:23 Re: How to reduce writing on disk ? (90 gb on pgsql_tmp)
Previous Message Ashik S L 2015-06-02 08:20:13 Re: Postgres is using 100% CPU