Re: General performance/load issue

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(at)fuzzy(dot)cz> 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(at)postgresql(dot)org)
>To make changes to your subscription:
>http://www.postgresql.org/mailpref/pgsql-general