TOAST
authorOleksandr Gavenko <gavenkoa@gmail.com>
Wed, 09 Jan 2019 19:32:16 +0200
changeset 2338 4837614fea35
parent 2337 c6c55f6a45c8
child 2339 cb96d35c46cf
TOAST
postgres.rst
--- a/postgres.rst	Tue Jan 08 11:45:14 2019 +0200
+++ b/postgres.rst	Wed Jan 09 19:32:16 2019 +0200
@@ -67,6 +67,13 @@
 
    SELECT * FROM pg_available_extensions;
 
+Limitations
+===========
+
+https://wiki.postgresql.org/wiki/TOAST
+  TOAST is a mechanism PostgreSQL uses to keep physical data rows from exceeding the size of a data
+  block (typically 8KB).
+
 Grant role options
 ==================
 ::
@@ -252,6 +259,8 @@
   SELECT pg_database_size('geekdb');  -- in bytes
   SELECT pg_size_pretty(pg_database_size('dbname'));
 
+  SELECT datname, pg_database_size(datname) FROM pg_database;
+
 List of databases sizes::
 
   \l+