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