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