Skip site navigation (1) Skip section navigation (2)

Re: BUG #4096: PG 8.3.1. confused about remaining disk space

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 (view raw or flat)
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!

In response to

Responses

pgsql-bugs by date

Next:From: Adriaan van KekemDate: 2008-04-07 11:34:50
Subject: BUG #4097: can join + where query be optimized?
Previous:From: Zdenek KotalaDate: 2008-04-07 10:51:07
Subject: Re: BUG #4096: PG 8.3.1. confused about remaining disk space

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group