Re: BUG #5947: Error while running query - Mailing list pgsql-bugs

From Greg Stark
Subject Re: BUG #5947: Error while running query
Date
Msg-id AANLkTik1MBQGkfOJrunGbK5Fu-Y_KBX3o0N=u-ahsLa0@mail.gmail.com
Whole thread Raw
In response to BUG #5947: Error while running query  ("Raman Sharma" <rsharma@10kinfo.com>)
List pgsql-bugs
On Fri, Mar 25, 2011 at 9:47 AM, Raman Sharma <rsharma@10kinfo.com> wrote:
> ERROR: =A0could not extend relation "test_table": No space left on device
> HINT: =A0Check free disk space.
>>
> But i have 27 GB space in my disk where it loaded and running query

Have you checked df -i ?

Also, this may seem like a silly question but years of experience
motivate it.... are you sure your data is on the filesystem you're
checking?

Also, 7.4 is *ancient*. You really really want to be using something
more recent. I doubt it's relevant to why you're running out of space
though.



--=20
greg

pgsql-bugs by date:

Previous
From: "Raman Sharma"
Date:
Subject: BUG #5947: Error while running query
Next
From: "alex"
Date:
Subject: BUG #5950: backend terminating after altering table