Re: postgresql-server-8.4.4-1PGDG.el5 - ERROR: could not write block 503414 of temporary file: No space le,ft on device

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.