>Some time ago I changed the pg_stat_temp directory from /var/lib/pgsq/whatever to /tmp
Have you checked the postgres log to see if there are any errors about it not being able to write to the pg_stat_temp dir?
Yep.... no errors =\
>Some time ago I changed the pg_stat_temp directory from /var/lib/pgsq/whatever to /tmp
Have you checked the postgres log to see if there are any errors about it not being able to write to the pg_stat_temp dir?