Thread: pg_total_relation_size

pg_total_relation_size

From
"Sriram Dandapani"
Date:

Hi

 

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

Re: pg_total_relation_size

From
Alvaro Herrera
Date:
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.