Postgres Pro
Downloads
Home   >   mailing lists

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

From David G. Johnston
Subject Re: How to reduce writing on disk ? (90 gb on pgsql_tmp)
Date
Msg-id CAKFQuwa=+MS6g_FhjktHwgsnrD2MYGkZ33LV2M4xmya=FGWCkg@mail.gmail.com
Whole thread Raw
In response to How to reduce writing on disk ? (90 gb on pgsql_tmp)  ("ben.play" <benjamin.cohen@playrion.com>)
List pgsql-performance
Tree view
You should repost this directly and not through Nabble.  It has wrapped your code in raw tags which the PostgreSQL mailing list software strips.

On Wednesday, June 3, 2015, ben.play <benjamin.cohen@playrion.com> wrote:
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.


--
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 by date:

Previous
From: "ben.play"
Date:
Subject: How to reduce writing on disk ? (90 gb on pgsql_tmp)
Next
From: amulsul
Date:
Subject: Re: How to reduce writing on disk ? (90 gb on pgsql_tmp)