BUG #5947: Error while running query
The following bug has been logged online:
Bug reference: 5947
Logged by: Raman Sharma
Email address: rsharma@10kinfo.com
PostgreSQL version: 7.4
Operating system: Ubnato
Description: Error while running query
Details:
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
On Fri, Mar 25, 2011 at 9:47 AM, Raman Sharma <rsharma@10kinfo.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