| From: | Sven Willenberger <sven(at)dmv(dot)com> |
|---|---|
| To: | "surabhi(dot)ahuja" <surabhi(dot)ahuja(at)iiitb(dot)ac(dot)in> |
| Cc: | Harald Armin Massa <haraldarminmassa(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: psql seems to hang during delete query |
| Date: | 2006-07-20 14:13:35 |
| Message-ID: | 1153404815.6821.1.camel@lanshark.dmv.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Thu, 2006-07-20 at 12:48 +0530, surabhi.ahuja wrote:
> so how much space should be free so that i am able to delete
>
> i have a hard disk of size 130 G.
>
>
> thanks,
> regards
> Surabhi
>
>
> ______________________________________________________________________
If you are trying to delete the entire contents of a table (and are not
using slony replication or similar) then a simple TRUNCATE <tablename>
will achieve the desired result and free up some diskspace.
Alternatively, if you have indexes on the table, you could try to drop
the indexes (if they are bloated, you can probably regain some diskspace
that way). Delete the rows you need and then create the indexes anew.
Sven
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Sven Willenberger | 2006-07-20 14:29:03 | Re: timestamp and calculations. |
| Previous Message | Martijn van Oosterhout | 2006-07-20 11:51:43 | Re: UTF8 conversion differences from v8.1.3 to v8.1.4 |