Skip site navigation (1) Skip section navigation (2)

\dt+ sizes don't include TOAST data

From: Florian Weimer <fweimer(at)bfk(dot)de>
To: pgsql-general(at)postgresql(dot)org
Subject: \dt+ sizes don't include TOAST data
Date: 2010-01-21 16:17:58
Message-ID: 82fx5zh1op.fsf@mid.bfk.de (view raw or flat)
Thread:
Lists: pgsql-general
The sizes displayed by \dt+ in version 8.4.2 do not take TOAST tables
into account, presumably because the pg_relation_size does not reflect
that, either.  I think this is a bit surprising.  From a user
perspective, these are part of the table storage (I understand that
the indices might be a different story, but TOAST table are a fairly
deep implementation detail and should perhaps be hidden here).

-- 
Florian Weimer                <fweimer(at)bfk(dot)de>
BFK edv-consulting GmbH       http://www.bfk.de/
Kriegsstra├če 100              tel: +49-721-96201-1
D-76133 Karlsruhe             fax: +49-721-96201-99

Responses

pgsql-general by date

Next:From: Dhimant PatelDate: 2010-01-21 16:40:03
Subject: Currently connected users...
Previous:From: Fernando SchapachnikDate: 2010-01-21 15:57:01
Subject: Changing FS when full

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group