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

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 (view raw or flat)
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

pgsql-admin by date

Next:From: Ivo RossacherDate: 2006-05-30 21:39:28
Subject: Re: the problem plz solve
Previous:From: Sriram DandapaniDate: 2006-05-30 16:59:32
Subject: pg_total_relation_size

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