Received: from localhost (maia-2.hub.org [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id A343D9FB72F for ; Thu, 31 May 2007 13:58:55 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-maia, port 10024) with ESMTP id 99666-01 for ; Thu, 31 May 2007 13:58:51 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from main2.mycybernet.net (main2.mycybernet.net [209.222.63.140]) by postgresql.org (Postfix) with ESMTP id 752DA9FB987 for ; Thu, 31 May 2007 13:58:52 -0300 (ADT) Received: from 227-54-222-209.mycybernet.net ([209.222.54.227] helo=phlogiston.dydns.org) by main2.mycybernet.net with esmtp (Exim 4.62) (envelope-from ) id 1Htnz5-0007q0-JL for pgsql-admin@postgresql.org; Thu, 31 May 2007 12:58:47 -0400 Received: by phlogiston.dydns.org (Postfix, from userid 1000) id 33FDC3F9E; Thu, 31 May 2007 12:58:42 -0400 (EDT) Date: Thu, 31 May 2007 12:58:42 -0400 From: Andrew Sullivan To: pgsql-admin@postgresql.org Subject: Re: Deletes hurt Message-ID: <20070531165842.GH19737@phlogiston.dyndns.org> References: <734907A8-F30D-4924-8C97-30D2898CA43C@decibel.org> <465EF665.7040105@commandprompt.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <465EF665.7040105@commandprompt.com> User-Agent: Mutt/1.5.9i X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200705/340 X-Sequence-Number: 25660 On Thu, May 31, 2007 at 09:23:01AM -0700, Joshua D. Drake wrote: > Right. Where we just mark the row as dead and have to vacuum. We just > delay the pain ;). They've delayed the pain too. This is actually an illustration of what Tom Lane said recently -- that the strategy of paying the cost of maintenance outside the main transaction path is intrinsically superior, because you don't have to pay it while your user is sitting there waiting for you. A -- Andrew Sullivan | ajs@crankycanuck.ca The plural of anecdote is not data. --Roger Brinner