Postgres Pro
Downloads
Home   >   mailing lists

How to reduce writing on disk ? (90 gb on pgsql_tmp) - Mailing list pgsql-performance

From ben.play
Subject How to reduce writing on disk ? (90 gb on pgsql_tmp)
Date
Msg-id 1433334092106-5852321.post@n5.nabble.com
Whole thread Raw
Responses Re: How to reduce writing on disk ? (90 gb on pgsql_tmp)  ("David G. Johnston" <david.g.johnston@gmail.com>)
Re: How to reduce writing on disk ? (90 gb on pgsql_tmp)  (amulsul <sul_amul@yahoo.co.in>)
List pgsql-performance
Tree view 
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.

pgsql-performance by date:

Previous
From: Ashik S L
Date:
Subject: Re: Postgres is using 100% CPU
Next
From: "David G. Johnston"
Date:
Subject: Re: How to reduce writing on disk ? (90 gb on pgsql_tmp)