Received: from localhost (maia-4.hub.org [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id BF9299FB311 for ; Wed, 18 Apr 2007 16:09:08 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 34533-01 for ; Wed, 18 Apr 2007 16:09:06 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by postgresql.org (Postfix) with ESMTP id 2447F9FA609 for ; Wed, 18 Apr 2007 16:09:06 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.13.6/8.13.6) with ESMTP id l3IJ8vKk010628; Wed, 18 Apr 2007 15:08:57 -0400 (EDT) To: "David Hinkle" cc: pgsql-admin@postgresql.org Subject: Re: Toast Problems In-reply-to: <41CAB934FDE0DA4392781E79BDF1894710A076@cipapdc.cipafilter.com> References: <41CAB934FDE0DA4392781E79BDF1894710A076@cipapdc.cipafilter.com> Comments: In-reply-to "David Hinkle" message dated "Wed, 18 Apr 2007 13:23:06 -0500" Date: Wed, 18 Apr 2007 15:08:57 -0400 Message-ID: <10627.1176923337@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200704/174 X-Sequence-Number: 25238 "David Hinkle" writes: > Is there any way I can tell for sure if the messages from this column > are being stored compressed? Not in 8.0, but in more recent versions pg_column_size() would help. regards, tom lane