Re: General performance/load issue

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