Received: from localhost (maia-4.hub.org [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 4B55F9FB986 for ; Thu, 15 Mar 2007 08:44:04 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-new, port 10024) with ESMTP id 58909-01 for ; Thu, 15 Mar 2007 08:44:00 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4 Received: from wr-out-0506.google.com (wr-out-0506.google.com [64.233.184.228]) by postgresql.org (Postfix) with ESMTP id A26789FB3B7 for ; Thu, 15 Mar 2007 08:44:00 -0300 (ADT) Received: by wr-out-0506.google.com with SMTP id 76so51431wra for ; Thu, 15 Mar 2007 04:43:56 -0700 (PDT) DKIM-Signature: a=rsa-sha1; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:message-id:date:from:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=nE/VQXh1bs5g5G93Na6CqLTnW2q3leXUXyfjFu6j81o0pW+SwALez7Qt6XzoqpHOns9/WyA83zCpsYaNNN/xuEMdzNRPDjGhPmiQWtj/GGrQumjobLLEB8Duf/mWajugvXQqqFIUROkAsgC1hZXa+Bg/vX0VjEBnW0dKbQUmmOU= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=NSmrHyzLbtWwTxtxhOIHR/Y3ISXSAkEMta00t3Uy0PHLdymrarM8C+bN2E9b4eV1pot6IcAfZmRZZPKwnJ69u/YSCwIAusIboWZbDsl9Z42ZfxAkHeTgIkTspoxn+e0VdHFklCo4xDuZBnENM7mNj2gold+i+HcyBezE/3dLjzs= Received: by 10.114.126.1 with SMTP id y1mr195431wac.1173959035793; Thu, 15 Mar 2007 04:43:55 -0700 (PDT) Received: by 10.115.72.5 with HTTP; Thu, 15 Mar 2007 04:43:55 -0700 (PDT) Message-ID: <48d0cacb0703150443i27dd852fj36fa646e38f095a0@mail.gmail.com> Date: Thu, 15 Mar 2007 08:43:55 -0300 From: "Daniel Cristian Cruz" Subject: Re: Determine dead tuples size Cc: pgsql-performance@postgresql.org In-Reply-To: <24499713.20070315135847@swsoft.com> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <24499713.20070315135847@swsoft.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200703/245 X-Sequence-Number: 23650 Try the contrib module pgstattuple. 2007/3/15, Alexey Romanchuk : > Hello guys, > > is it possible to determine dead tuples size for table? > > -- > Alexey Romanchuk > > > > ---------------------------(end of broadcast)--------------------------- > TIP 1: if posting/reading through Usenet, please send an appropriate > subscribe-nomail command to majordomo@postgresql.org so that your > message can get through to the mailing list cleanly > -- Daniel Cristian Cruz Analista de Sistemas