Postgres Pro
Downloads
Home   >   mailing lists

Re: Table using more disk space than expected - Mailing list pgsql-general

From Tom Lane
Subject Re: Table using more disk space than expected
Date
Msg-id 14838.1443027027@sss.pgh.pa.us
Whole thread Raw
In response to Table using more disk space than expected  (Steve Pritchard <steve.pritchard@bto.org>)
Responses Re: Table using more disk space than expected
List pgsql-general
Tree view 
Steve Pritchard <steve.pritchard@bto.org> writes:
> -- Average length of a row in bytes:
> select avg(octet_length(t.*::text)) FROM observation t;
> -- 287 bytes

That measurement technique doesn't have a lot to do with reality,
I'm afraid.

The contrib/pgstattuple module could give you a more reliable idea of
how much space is in use or not in the table.

            regards, tom lane

pgsql-general by date:

Previous
From: Steve Pritchard
Date:
Subject: Table using more disk space than expected
Next
From: Jimit Amin
Date:
Subject: Re: Table using more disk space than expected