Received: from makus.postgresql.org (makus.postgresql.org [98.129.198.125]) by mail.postgresql.org (Postfix) with ESMTP id 6EE6CC76A58 for ; Sun, 26 Feb 2012 03:34:22 -0400 (AST) Received: from server.lerner.co.il ([69.55.231.200] helo=lerner.co.il) by makus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1S1Ycg-0000wf-5Q for pgsql-performance@postgresql.org; Sun, 26 Feb 2012 07:34:22 +0000 Received: by lerner.co.il (Postfix, from userid 1003) id 516135D6626; Sun, 26 Feb 2012 09:34:08 +0200 (IST) X-Spam-Checker-Version: SpamAssassin 3.3.2 (2011-06-06) on lerner.co.il X-Spam-Level: X-Spam-Status: No, score=-2.9 required=5.0 tests=ALL_TRUSTED,BAYES_00, TVD_RCVD_IP autolearn=unavailable version=3.3.2 Received: from 31-154-141-223.orange.net.il (unknown [31.154.141.223]) (using TLSv1 with cipher ECDHE-RSA-AES256-SHA (256/256 bits)) (No client certificate requested) (Authenticated sender: reuven) by lerner.co.il (Postfix) with ESMTPSA id 4F2D55D6363; Sun, 26 Feb 2012 09:33:10 +0200 (IST) Message-ID: <4F49E031.7080605@lerner.co.il> Date: Sun, 26 Feb 2012 09:33:05 +0200 From: "Reuven M. Lerner" User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.6; rv:10.0.2) Gecko/20120216 Thunderbird/10.0.2 MIME-Version: 1.0 To: Jeff Janes CC: pgsql-performance@postgresql.org Subject: Re: Very long deletion time on a 200 GB database References: <4F45FB55.1020600@lerner.co.il> In-Reply-To: Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit X-Pg-Spam-Score: -1.9 (-) X-Archive-Number: 201202/205 X-Sequence-Number: 46377 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