Re: [GENERAL] psql seems to hang during delete query

2006-07-20 Thread Sven Willenberger
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 de

Re: [GENERAL] psql seems to hang during delete query

2006-07-20 Thread surabhi.ahuja
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

Re: [GENERAL] psql seems to hang during delete query

2006-07-19 Thread Harald Armin Massa
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: