On Tue, Sep 20, 2011 at 2:09 PM, Josh Kupershmidt <schmiddy@xxxxxxxxx> wrote: > On Tue, Sep 20, 2011 at 1:26 PM, Jon Nelson <jnelson+pgsql@xxxxxxxxxxx> wrote: >> I have a table with a fair bit of TOAST data in it. >> I noticed that \d+ does /not/ include that information (but >> pg_total_relation_size does). > > I assume by "\d+" you meant "\dt+" (\d+ doesn't show sizes at all). On > version 9.0 and up, \dt+ uses pg_relation_size() internally, which > actually does include TOAST data as this comment in dbsize.c explains: I meant "\d+". I'm using 9.0.3 and "\d+" clearly shows sizes. Per Tom Lane's comments later in the thread, the behavior of 9.0 (and prior) matches my recollection. I just need to wait for 9.1. Thanks! -- Jon -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
