log_temp_files confusion

Поиск
Список
Период
Сортировка
От Filip Rembiałkowski
Тема log_temp_files confusion
Дата
Msg-id 92869e661001130651k7bc76013y1e6f58d981ad5134@mail.gmail.com
обсуждение исходный текст
Ответы Re: log_temp_files confusion
Список pgsql-general

I would like to log usage of temporary files for sort/join operations, but only when size of these files exceeds some threshold.

So I set in postgresql.conf (this is 8.4.2)
log_temp_files = 4MB

But then I got these messages in log file

2010-01-12 13:24:49 CET 24899 filip@la_filip LOG:  temporary file: path "base/pgsql_tmp/pgsql_tmp24899.1", size 162464
2010-01-12 13:24:49 CET 24899 filip@la_filip CONTEXT:  SQL statement "insert into foo ( ... ) select ...
    PL/pgSQL function "la_foo" line 51 at SQL statement
2010-01-12 13:24:49 CET 24899 filip@la_filip STATEMENT:  Select * From la_foo(31968)

2010-01-12 13:24:49 CET 24899 filip@la_filip LOG:  temporary file: path "base/pgsql_tmp/pgsql_tmp24899.0", size 153152
2010-01-12 13:24:49 CET 24899 filip@la_filip CONTEXT:  SQL statement "insert into foo ( ... ) select ...
    PL/pgSQL function "la_foo" line 51 at SQL statement
2010-01-12 13:24:49 CET 24899 filip@la_filip STATEMENT:  Select * From la_foo(31968)

2010-01-12 13:24:49 CET 24899 filip@la_filip LOG:  temporary file: path "base/pgsql_tmp/pgsql_tmp24899.2", size 152128
2010-01-12 13:24:49 CET 24899 filip@la_filip CONTEXT:  SQL statement "insert into foo ( ... ) select ...
    PL/pgSQL function "la_foo" line 51 at SQL statement
2010-01-12 13:24:49 CET 24899 filip@la_filip STATEMENT:  Select * From la_foo(31968)


The combined size of temporary files named in these three warnings is far from 4 MB.

Why is postgres logging these operations?
How is this threshold calculated at run time?

TIA


--
Filip Rembiałkowski
JID,mailto:filip.rembialkowski@gmail.com
http://filip.rembialkowski.net/

В списке pgsql-general по дате отправления: