delete seems to be getting blocked

From: "surabhi(dot)ahuja" <surabhi(dot)ahuja(at)iiitb(dot)ac(dot)in>
To: <pgsql-general(at)postgresql(dot)org>
Subject: delete seems to be getting blocked
Date: 2006-06-12 07:24:15
Message-ID: 8626C1B7EB748940BCDD7596134632BE398689@jal.iiitb.ac.in
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

hi,
I am using postgresql 8.0.0.
i have four tables in my database
TAB1, has one primary key T1

TAB2 , has 2 fields, one is the primary ley T2 and the other one is the foreign key T1(from TAB1)

TAB3 also has 2 fields, one is the primary ley T3 and the other is the foreign key T2(from TAB2)

TAB4 has 2 fields again, primary key T4 and a foreign key T3(from TAB3)

the disk is 100% full.

i open psql <datbase_name> and do
delete from TAB1

nothing seems to be happening for a long time, although when i do top, it shows postgres taking 99%.

what is happening, cant delete be quickened?

thanks,
regards
Surabhi



Responses

Browse pgsql-general by date

  From Date Subject
Next Message Greg 2006-06-12 08:21:00 test
Previous Message John Tregea 2006-06-12 07:19:27 Re: Help with storing spatial (map coordinates) data?