Home > mailing lists

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

From	surabhi.ahuja
Subject	psql seems to hang during delete query
Date	July 20, 2006 05:58:23
Msg-id	8626C1B7EB748940BCDD7596134632BE398699@jal.iiitb.ac.in Whole thread Raw
Responses	unsubscribe (Timothy Smith <timothy@open-networks.net>) Re: psql seems to hang during delete query ("Harald Armin Massa" <haraldarminmassa@gmail.com>)
List	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

From: "Merlin Moncure"
Date: 20 July 2006, 02:34:29
Subject: Re: Linking Tables from 2 databases

From: Timothy Smith
Date: 20 July 2006, 06:25:41
Subject: unsubscribe