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

Re: Table size does not include toast size

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Bernd Helmle <mailings(at)oopsware(dot)de>
Cc: Greg Smith <greg(at)2ndquadrant(dot)com>, Rafael Martinez <r(dot)m(dot)guerrero(at)usit(dot)uio(dot)no>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Table size does not include toast size
Date: 2010-01-19 05:51:42
Message-ID: 327.1263880302@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-hackers
Bernd Helmle <mailings(at)oopsware(dot)de> writes:
> Since i'm not able to finish those other things in time, i wrapped up my 
> existing code for this issue and came up with the attached patch, which 
> should implement the behavior Tom proposed. These are two new functions 
> pg_table_size() and pg_indexes_size(). This patch also changes 
> pg_total_relation_size() to be a shorthand for pg_table_size() + 
> pg_indexes_size().

Applied with minor corrections.

			regards, tom lane

In response to

pgsql-hackers by date

Next:From: Fujii MasaoDate: 2010-01-19 06:04:06
Subject: Re: Streaming replication, and walsender during recovery
Previous:From: Brad T. SligerDate: 2010-01-19 05:41:47
Subject: Re: Pretty printed trigger in psql

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