From: | Gregory Stark <stark(at)enterprisedb(dot)com> |
---|---|
To: | "Zdenek Kotala" <Zdenek(dot)Kotala(at)Sun(dot)COM> |
Cc: | <j6m(at)adm(dot)estp(dot)fr>, <pgsql-bugs(at)postgresql(dot)org> |
Subject: | Re: BUG #4096: PG 8.3.1. confused about remaining disk space |
Date: | 2008-04-07 11:14:39 |
Message-ID: | 874padq5ls.fsf@oxford.xeocode.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
"Zdenek Kotala" <Zdenek(dot)Kotala(at)Sun(dot)COM> writes:
> j6m(at)adm(dot)estp(dot)fr napsal(a):
>> relation 1663/19693/634162: No space left on device
...
>> Disk saturation, you think ? No at all, as in the meantime :
>>
>> Filesystem Size Used Avail Use% Mounted on
>> /dev/sda3 9.9G 8.5G 874M 91% /
>> udev 125M 88K 125M 1% /dev
>> /dev/sda1 54M 15M 37M 29% /boot
>> /dev/sda4 8.3G 7.4G 966M 89% /home
>> /dev/sdb1 38G 31G 7.2G 81% /var/lib/pgsql
>>
>> As you can see, there is some 200 times the active DB size that remains
>> available.
>
> User quota or super user space reservation could take affect. Could you create
> file as a postgres user on pgsql filesystem?
Also check "df -i"
--
Gregory Stark
EnterpriseDB http://www.enterprisedb.com
Get trained by Bruce Momjian - ask me about EnterpriseDB's PostgreSQL training!
From | Date | Subject | |
---|---|---|---|
Next Message | Adriaan van Kekem | 2008-04-07 11:34:50 | BUG #4097: can join + where query be optimized? |
Previous Message | Zdenek Kotala | 2008-04-07 10:51:07 | Re: BUG #4096: PG 8.3.1. confused about remaining disk space |