| From: | "Reuven M(dot) Lerner" <reuven(at)lerner(dot)co(dot)il> |
|---|---|
| To: | Jeff Janes <jeff(dot)janes(at)gmail(dot)com> |
| Cc: | pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: Very long deletion time on a 200 GB database |
| Date: | 2012-02-26 07:33:05 |
| Message-ID: | 4F49E031.7080605@lerner.co.il |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
Hi, everyone. Jeff wrote:
>
> Is this 9 hours run time for deleting one day worth of data, or for
> deleting the entire accumulation of cruft that filled up the hard
> drive in the first place (which would be 170 days, if you have 200GB
> that accumulated at 1GB per day and you only need 30 days) ?
Unfortunately, it took 9 hours to delete all of the rows associated with
the older-than-30-days records.
Reuven
--
Reuven M. Lerner -- Web development, consulting, and training
Mobile: +972-54-496-8405 * US phone: 847-230-9795
Skype/AIM: reuvenlerner
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Wales Wang | 2012-02-26 08:52:07 | Re： [PERFORM] PG as in-memory db? How to warm up and re-populate buffers? How to read in all tuples into memory? |
| Previous Message | Jeff Janes | 2012-02-26 02:13:49 | Re: PG as in-memory db? How to warm up and re-populate buffers? How to read in all tuples into memory? |