postgres.rst
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
 =======================