Received: from localhost (unknown [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id 2E2A637C7F9 for ; Mon, 12 Nov 2007 13:04:50 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-maia, port 10024) with ESMTP id 84305-03-3 for ; Mon, 12 Nov 2007 13:04:41 -0400 (AST) Received: from wa-out-1112.google.com (wa-out-1112.google.com [209.85.146.182]) by postgresql.org (Postfix) with ESMTP id 0C33F37C730 for ; Mon, 12 Nov 2007 13:04:46 -0400 (AST) Received: by wa-out-1112.google.com with SMTP id m38so1841573waf for ; Mon, 12 Nov 2007 09:04:45 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; bh=46znhcOt52YdX3JOnHwgt1OhqtN69xOO2W0y/HdjWKA=; b=sWoKt5m+MDl7swc2dwA7t0tiQ3nBb5ddC2epcF8mhsVMXs/JJLo57ZR+naFqa0QHIz18rMunSwAYqmEsJJhNcVdHC89c4aqH6U7kB3VspWdk362UUh2P7snjFfTop0xSs8suTa4ZB4OpvQSvfL/KEkVihjurnsp0F0V34dROTKU= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=RkGDADo7NajsHKKmhiDT9Q5CujUofW9f9skxdazVs7FQhWkU5wM5sqsVt7+gempIjEx5gLD6zRKG6Ylm4NPzwWMt1oje2yWYfYfPH64YW9xTC9Y3rAXdGvHCfs2EjoXY0AdzOGc8tOGrnM/CInwFDZMppabnGV3Rbq+HNno6XD0= Received: by 10.114.76.1 with SMTP id y1mr872750waa.1194887085039; Mon, 12 Nov 2007 09:04:45 -0800 (PST) Received: by 10.114.171.20 with HTTP; Mon, 12 Nov 2007 09:04:44 -0800 (PST) Message-ID: Date: Mon, 12 Nov 2007 11:04:44 -0600 From: "Scott Marlowe" To: "Heikki Linnakangas" Subject: Re: Need to run CLUSTER to keep performance Cc: "Rafael Martinez" , "Tom Lane" , pgsql-performance@postgresql.org In-Reply-To: <473886DF.1050902@enterprisedb.com> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <4732E6B4.1030907@usit.uio.no> <4732EF07.3060807@enterprisedb.com> <47332200.9050705@usit.uio.no> <24775.1194535980@sss.pgh.pa.us> <4738735B.6030408@usit.uio.no> <47387B4F.7000608@usit.uio.no> <473886DF.1050902@enterprisedb.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200711/186 X-Sequence-Number: 27601 On Nov 12, 2007 11:01 AM, Heikki Linnakangas wrote: > > Scott Marlowe wrote: > > So, between the first and second vacuum you had a long running > > transaction that finally ended and let you clean up the dead rows. > > No, before 8.3, CLUSTER throws away non-removable dead tuples. So the > long running transaction might still be there. Wow, good to know. Why would it have changed in 8.3? Was it considered broken behaviour?