Re: psql seems to hang during delete query - Mailing list pgsql-general

From Harald Armin Massa
Subject Re: psql seems to hang during delete query
Date
Msg-id 7be3f35d0607192346j6593dd58lcd8cd81f17849257@mail.gmail.com
Whole thread Raw
In response to psql seems to hang during delete query  ("surabhi.ahuja" <surabhi.ahuja@iiitb.ac.in>)
List pgsql-general
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: vacuum freeze

So, to get space, you have to have space first. Delete something else.

Harald

On 7/20/06, surabhi.ahuja <surabhi.ahuja@iiitb.ac.in> wrote:
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 postmaster
i also saw this appearing
 
 2525 root      16   0  7296  720  620 S  0.3  0.0   0:07.62 hald-addon-stor
 
its been almost half an hour
and the database is still in the same state. (all the rows still exist)
 
what is happening?
hasnt it started deleteing yet?
postgreslog dont say anything.
 
what can be done in such a case?
thanks,
regards
Surabhi



--
GHUM Harald Massa
persuadere et programmare
Harald Armin Massa
Reinsburgstraße 202b
70197 Stuttgart
0173/9409607
-
on different matter:
EuroPython 2006 is over. It was a GREAT conference. If you missed it, now you can prepare budget for visiting EuroPython 2007.

pgsql-general by date:

Previous
From: Timothy Smith
Date:
Subject: unsubscribe
Next
From: "surabhi.ahuja"
Date:
Subject: Re: psql seems to hang during delete query