You can't delete from a full disk :)No, really: database systems need space for logging, WAL, whatever.And even with delete PostgreSQL will free no single byte, as deleting is done with marking the row as deleted. Read up on multi version concurrency why this has to be that way.
To reclaim space:
to hang
during delete query
***
Your mail has been scanned by InterScan VirusWall.
***-***
You can't delete from a full disk
:)No, really: database systems need space for logging, WAL,
whatever.And even with "delete" PostgreSQL will free no s
On Thu, 2006-07-20 at 12:48 +0530, surabhi.ahuja wrote:
so how much space should be free so that i am able to delete
i have a hard disk of size 130 G.
thanks,
regards
Surabhi
__
If you are trying to delete the
i am using postgresql 8.0.0
my disk is 100% full
i have a database called x
i do the following
psql x
delete from table;
nothing happens
i try to see the top output
i see the following
1768 sdc
25 0 41860 32m 30m R 99.7 0.8 11:29.35
postmasteri also saw this appearing
2525 root 16 0