Received: from localhost (maia-4.hub.org [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 637909FB60B for ; Fri, 16 Mar 2007 06:35:21 -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 00546-10 for ; Fri, 16 Mar 2007 06:35:18 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4 Received: from ug-out-1314.google.com (ug-out-1314.google.com [66.249.92.170]) by postgresql.org (Postfix) with ESMTP id CFCC69FB6CE for ; Fri, 16 Mar 2007 06:35:17 -0300 (ADT) Received: by ug-out-1314.google.com with SMTP id k3so564835ugf for ; Fri, 16 Mar 2007 02:35:16 -0700 (PDT) DKIM-Signature: a=rsa-sha1; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:message-id:date:from:user-agent:mime-version:to:cc:subject:references:in-reply-to:content-type:content-transfer-encoding:sender; b=naxuAT0NgWh5aOWXHg65m2SWr6IFPvtwislGcQN8CUmw6ueOiB4bgbH82WWwn5vp6+I+Z5qsBwQoMLC/pzfyBSl+qbOAOi+u3qCss71crmjuGnyOcbUxlah5Mce2avnxSAZ9UcLh3qGFritbk2jSPgEoveorB1snRb+R0yxzfug= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:user-agent:mime-version:to:cc:subject:references:in-reply-to:content-type:content-transfer-encoding:sender; b=UjEd1UaJJSzZKu7kAQOsNB0MsQaGiyGTY2Z6yeMtj+Mp50xTIZhN9EeaYfJfGWPIYz3iPkcLG40cKH12MLXX0+PcVA2sKB6m9hRS5ucrH4j65XyHVzTR3hQlaqLL1ZBjo9dJGX8lgC2aIEMvURLnSB+tF00XL7B7T8agiGuafGc= Received: by 10.67.101.10 with SMTP id d10mr4271634ugm.1174037716581; Fri, 16 Mar 2007 02:35:16 -0700 (PDT) Received: from ?192.168.1.34? ( [82.14.79.173]) by mx.google.com with ESMTP id b36sm3810273ika.2007.03.16.02.35.13; Fri, 16 Mar 2007 02:35:14 -0700 (PDT) Message-ID: <45FA64D8.7070904@enterprisedb.com> Date: Fri, 16 Mar 2007 09:35:20 +0000 From: Heikki Linnakangas User-Agent: Icedove 1.5.0.8 (X11/20061116) MIME-Version: 1.0 To: aromanchuk@swsoft.com CC: pgsql-performance@postgresql.org Subject: Re: Determine dead tuples size References: <24499713.20070315135847@swsoft.com> <20070315114508.GA12266@winnie.fuhr.org> <17410023575.20070316114150@swsoft.com> In-Reply-To: <17410023575.20070316114150@swsoft.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200703/252 X-Sequence-Number: 23657 Alexey Romanchuk wrote: > thanks, i install contribs and try to analyze result of pgstattuple > function and found it strange. Try "SELECT * FROM pgstattuple('foo')", that'll tell you what the columns are. Take a look at README.pgstattuple as well for more details. -- Heikki Linnakangas EnterpriseDB http://www.enterprisedb.com