From: | "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com> |
---|---|
To: | "ben(dot)play" <benjamin(dot)cohen(at)playrion(dot)com> |
Cc: | "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org> |
Subject: | Re: How to reduce writing on disk ? (90 gb on pgsql_tmp) |
Date: | 2015-06-03 12:44:23 |
Message-ID: | CAKFQuwa=+MS6g_FhjktHwgsnrD2MYGkZ33LV2M4xmya=FGWCkg@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
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(dot)cohen(at)playrion(dot)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(at)postgresql(dot)org
> <javascript:;>)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-performance
>
From | Date | Subject | |
---|---|---|---|
Next Message | amulsul | 2015-06-03 13:11:22 | Re: How to reduce writing on disk ? (90 gb on pgsql_tmp) |
Previous Message | ben.play | 2015-06-03 12:21:32 | How to reduce writing on disk ? (90 gb on pgsql_tmp) |