| 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: | Whole Thread | Raw Message | 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!
| 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 |