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

["David G. Johnston" <david.g.johnston@xxxxxxxxx>]

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@xxxxxxxxxxxx> 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@xxxxxxxxxxxxxx)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-performance