On Thu, Mar 29, 2012 at 3:06 PM, Alexander Fortin < alexander.for...@gmail.com> wrote:
> Hi folks, > > I'm analyizing why our /var/lib/postgresql partition got a quick bump in > usage (from 32GB to 41GB) few days ago, even if, according to data from > monitoring software, database size kept increasing with no bump at all. > > So I'm using "SELECT pg_database_size('mydb')" but I can't find much > documentation about what that "size" actually refers to. What I see is > that both the master and the replicas shows the same number (32GB), but > for both of those I see differences in the actual file system usage: > > master: > 41G /var/lib/postgresql/9.1/main/base > > replica: > 37G /var/lib/postgresql/9.1/main/base/ > > Does pg_database_size() return size occupied by indexes too? If not, the > difference could be due to index space I guess. > > Thanks! > > Yes, pg_database_size include indexes in the database. Can you also tell what replication is in place ? --- Regards, Raghavendra EnterpriseDB Corporation Blog: http://raghavt.blogspot.com/ > -- > Alexander Fortin > http://about.me/alexanderfortin/ > > -- > Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-admin >