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 M. Lerner -- Web development, consulting, and training
Mobile: +972-54-496-8405 * US phone: 847-230-9795
In response to
pgsql-performance by date
|Next:||From: Wales Wang||Date: 2012-02-26 08:52:07|
|Subject: Re： [PERFORM] PG as in-memory db? How to warm up and re-populate buffers? How to read in all tuples into memory?|
|Previous:||From: Jeff Janes||Date: 2012-02-26 02:13:49|
|Subject: Re: PG as in-memory db? How to warm up and re-populate
buffers? How to read in all tuples into memory?|