Delete operation VERY slow...

From: David Leangen <postgres(at)leangen(dot)net>
To: pgsql-performance(at)postgresql(dot)org
Subject: Delete operation VERY slow...
Date: 2006-06-16 06:58:46
Message-ID: 1150441126.4812.23.camel@sonoda.bioscene.co.jp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance


Hello!

I am trying to delete an entire table. There are about 41,000 rows in
the table (based on count(*)).

I am using the SQL comment: delete from table;

The operation seems to take in the order of hours, rather than seconds
or minutes.

"Explain delete from table" gives me:

QUERY PLAN
----------------------------------------------------------------
Seq Scan on table (cost=0.00..3967.74 rows=115374 width=6)
(1 row)

I am using an Intel Pentium D 2.8GHz CPU. My system has about 1.2GB of
RAM. This should be ok... my database isn't that big, I think.

Any ideas why this takes so long and how I could speed this up?

Or alternatively, is there a better way to delete all the contents from
a table?

Thank you!

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message A. Kretschmer 2006-06-16 07:17:07 Re: Delete operation VERY slow...
Previous Message Qingqing Zhou 2006-06-16 04:48:27 Re: Test request for Stats collector performance improvement