On 12/15/15 3:52 AM, Matteo Grolla wrote:
1) Can you explain me the big difference between the result in A for
table alf_node_properties: 17GB and the result in B: ~6GB ?
11GB of indexes would explain it.
2) Can you explain me the difference between the result in B: ~6GB and
the result in C, the sum of all column sizes, 3717MB ?
Probably per-page and per-tuple overhead.
What does SELECT reltuples, relpages FROM pg_class WHERE oid =
'public.alf_node_properties'::regclass show?
--
Jim Nasby, Data Architect, Blue Treble Consulting, Austin TX
Experts in Analytics, Data Architecture and PostgreSQL
Data in Trouble? Get it in Treble! http://BlueTreble.com
--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
