Re: BUG #5947: Error while running query

From: Greg Stark <gsstark(at)mit(dot)edu>
To: Raman Sharma <rsharma(at)10kinfo(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #5947: Error while running query
Date: 2011-03-25 11:46:20
Message-ID: AANLkTik1MBQGkfOJrunGbK5Fu-Y_KBX3o0N=u-ahsLa0@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On Fri, Mar 25, 2011 at 9:47 AM, Raman Sharma <rsharma(at)10kinfo(dot)com> wrote:
> ERROR:  could not extend relation "test_table": No space left on device
> HINT:  Check 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.

--
greg

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Mihail Popov 2011-03-25 13:35:08 BUG #5949: ODBC driver. Binding Arrays of Parameters
Previous Message yuriy.tereschuk 2011-03-25 10:58:27 BUG #5948: JDBC wrond insert of timestamp data