psql seems to hang during delete query

From: "surabhi(dot)ahuja" <surabhi(dot)ahuja(at)iiitb(dot)ac(dot)in>
To: <pgsql-general(at)postgresql(dot)org>
Subject: psql seems to hang during delete query
Date: 2006-07-20 06:05:05
Message-ID: 8626C1B7EB748940BCDD7596134632BE398699@jal.iiitb.ac.in
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Timothy Smith 2006-07-20 06:27:28 unsubscribe
Previous Message Merlin Moncure 2006-07-20 02:34:19 Re: Linking Tables from 2 databases