7.3.3 drop table takes very long time

From: "Eric Freeman" <ejf7(at)hotmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: 7.3.3 drop table takes very long time
Date: 2004-01-08 16:43:02
Message-ID: BAY99-F32kpDasYutu4000304b7@hotmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I'm trying to drop a table and it's taking a very long time. There has been
a lot of modification to the table and it has a lot of old data still being
used as a result of not using the vacuum function enough. I ran an insert
into and it was taking a long time (ran for about 48 hours) so I aborted it.
I tried vacuuming it and that ran for about the same amount of time before I
aborted. I figured the fastest ting would be to drop the table and re-create
it.
I tried running a pg_dump and it ran for about 4 days without putting any of
the data to the output file.
I started the drop table command yesterday and it's been running for almost
24 hours.
I know it's processing because it's using up the CPU and I can run
transactions on all of the other tables except this one. It has about
132,000 records in the table.
Any ideas on how I can speed this up?
Can I go into the /data directory and find the file that contains that table
and delete that? If so, how would I go about doing this?
Eric

_________________________________________________________________
Expand your wine savvy and get some great new recipes at MSN Wine.
http://wine.msn.com

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Richard Huxton 2004-01-08 16:52:05 Re: Queries taking a very long time
Previous Message Marc G. Fournier 2004-01-08 16:33:51 Re: Queries taking a very long time