Actually, this is because I changed sort_mem to 4 Mb as asked by Robert. I removed this setting.. Gaëtan Le 26/11/11 18:58, « Tomas Vondra » <tv@xxxxxxxx> a écrit : >Dne 26.11.2011 18:08, Gaëtan Allart napsal(a): >> UhmŠ >> >> I'm seeing dozens and dozens of temporary file creations in logs : >> >> LOG: temporary file: path "base/pgsql_tmp/pgsql_tmp15388.1399", size >>23912 >> LOG: temporary file: path "base/pgsql_tmp/pgsql_tmp15388.211", size >> 2761788 >> LOG: temporary file: path "base/pgsql_tmp/pgsql_tmp13772.3747", size >>27188 >> LOG: temporary file: path "base/pgsql_tmp/pgsql_tmp13772.2639", size >> 2749672 >> LOG: temporary file: path "base/pgsql_tmp/pgsql_tmp15388.1053", size >>24276 >> LOG: temporary file: path "base/pgsql_tmp/pgsql_tmp15388.452", size >> 2948712 > >Please, add timestamp to log_line_prefix so that we know how frequently >that happens. > >Anyway the output is a bit strange. It's writing a lot of temp files >that are significantly smaller (about 3MB) than work_mem (128MB). > >Tomas > >-- >Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) >To make changes to your subscription: >http://www.postgresql.org/mailpref/pgsql-general -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
