Re: pg_total_relation_size

From: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
To: Sriram Dandapani <sdandapani(at)counterpane(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: pg_total_relation_size
Date: 2006-05-30 17:41:38
Message-ID: 20060530174137.GB31547@surnet.cl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Sriram Dandapani wrote:

> Does the pg_total_relation_size take into account the free space map
> /"yet to be vacuumed data" ?

Both -- it measures the physical sizes of the files on disk, without
looking at the contents.

--
Alvaro Herrera http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Ivo Rossacher 2006-05-30 21:39:28 Re: the problem plz solve
Previous Message Sriram Dandapani 2006-05-30 16:59:32 pg_total_relation_size