changeset 2343 | 984ccb104a6e |
parent 2339 | cb96d35c46cf |
child 2373 | 07d81edeaba6 |
--- a/postgres.rst Thu Jan 10 14:13:45 2019 +0200 +++ b/postgres.rst Wed Jan 23 20:39:31 2019 +0200 @@ -289,6 +289,15 @@ LEFT JOIN pg_class t ON t.reltoastrelid = p.oid ORDER BY p.relpages DESC; +Size of types:: + + SELECT pg_column_size(5::smallint); + SELECT pg_column_size(5::int); + SELECT pg_column_size(5::bigint); + +https://wiki.postgresql.org/wiki/Disk_Usage + Finding the size of various object in your database. + MVCC and transaction id =======================