From: Reuven M. Lerner <reuven@lerner.co.il>
To: Jeff Janes <jeff.janes@gmail.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: Very long deletion time on a 200 GB database
Date: Sun, 26 Feb 2012 09:33:05 +0200
Message-ID: <4F49E031.7080605@lerner.co.il> (raw)
In-Reply-To: <CAMkU=1wkj20=+GxdQz6Zq5YkpcDkwzmBx6n+RGeq-YHk5NN_ew@mail.gmail.com>
References: <4F45FB55.1020600@lerner.co.il>
<CAMkU=1wkj20=+GxdQz6Zq5YkpcDkwzmBx6n+RGeq-YHk5NN_ew@mail.gmail.com>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: reuven@lerner.co.il, jeff.janes@gmail.com
Subject: Re: Very long deletion time on a 200 GB database
In-Reply-To: <4F49E031.7080605@lerner.co.il>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox