On Tue, Jul 19, 2011 at 2:26 PM, Tom Lane <t...@sss.pgh.pa.us> wrote:
> Ken Caruso <k...@ipl31.net> writes: > > I am trying to trouble shoot a couple of issue related to vacuum and db > > size. I currently have a postgres DB that is around 390GB on disk (du -hs > in > > $PG_DATA/base). If I look at the total relation size using the following > > query: > > > SELECT SUM(pg_relation_size(pg_class.oid)) > > FROM pg_class ; > > > This says the total size is around 191GB. That query should sum all of > the > > tables, toast and indexes AFAIK. > > What PG version? > 9.0.4 -Ken > > If it's a version with multiple table forks, you're only counting the > main forks, not FSM or VM. > > Theoretically the latter two should be pretty small relative to the main > fork, but obviously you are missing something with this query ... > regards, tom lane >
