On Mon, Jul 26, 2010 at 16:01, Irene Barg <ibarg@noao.edu> wrote:
>> 2010-07-26 11:33:33 MST system_admin metadataERROR: could not write block
>> 503414 of temporary file: No space le
>> ft on device
>> 2010-07-26 11:33:33 MST system_admin metadataHINT: Perhaps out of disk
>> space?
>> -bash-3.2$ df -h
>> Filesystem Size Used Avail Use% Mounted on
>> /dev/sda3 16G 13G 1.7G 89% /
>> /dev/sda8 635G 979M 601G 1% /data0
>> /dev/sda7 2.0G 241M 1.7G 13% /home
>> /dev/sda5 7.8G 1.5G 5.9G 20% /u1
>> /dev/sda2 16G 184M 15G 2% /var/log
>> /dev/sda1 487M 22M 440M 5% /boot
>> tmpfs 12G 0 12G 0% /dev/shm
>> /dev/md0 2.7T 202M 2.6T 1% /data1
>
>
> The pg_stat_tmp is hardly growing::
>
>> -bash-3.2$ date
>> Mon Jul 26 14:37:38 MST 2010
>> -bash-3.2$ pwd
>> /var/lib/pgsql/data
Ok so it looks like this is on your / (sda3) partition that only has
1.7G free. Its entirely possible that you have some query that needs
to write more than that in tmp files.
>> -bash-3.2$ du -ks pg_stat_tmp/*
No surprise that is not growing, thats not for temp files, its for the
stats collector.
I would try turning on log_temp_files, that might help pin point the
problem query.