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
