Steve Pritchard <steve.pritch...@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
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
