Quick Links

growth of the database

From:	"Karthikeyan Sundaram" <skarthi98(at)hotmail(dot)com>
To:	pgsql-admin(at)postgresql(dot)org, pgsql-sql(at)postgresql(dot)org
Subject:	growth of the database
Date:	2007-03-21 17:25:51
Message-ID:	BAY131-F39F217C76C71862EB0528AB0740@phx.gbl
Views:	Whole Thread \| Raw Message \| Download mbox \| Resend email
Thread:
Lists:	pgsql-admin pgsql-sql

Hi,

Our database is growing fast. I want to create a cronjob that should
tell me what is the current size of the database on each day.

How can I find this from the database? Is there any pre-written scripts
written by somebody to share?

Regards
skarthi

_________________________________________________________________
Live Search Maps find all the local information you need, right when you
need it. http://maps.live.com/?icid=hmtag2&FORM=MGAC01

In response to

Re: [SQL] ERROR: invalid byte sequence for encoding "UTF8": 0x92 at 2007-03-21 03:32:44 from Michael Fuhr

Responses

Re: growth of the database at 2007-03-21 17:37:44 from Guido Neitzer
Monitor what command is executing at the backend at 2007-03-21 21:49:43 from Karthikeyan Sundaram
Re: growth of the database at 2007-03-22 10:40:11 from Hubertus Freiherr von Fuerstenberg

Browse pgsql-admin by date

	From	Date	Subject
Next Message	Guido Neitzer	2007-03-21 17:37:44	Re: growth of the database
Previous Message	Morten W. Petersen	2007-03-21 16:42:25	Read-only access to a database

Browse pgsql-sql by date

	From	Date	Subject
Next Message	Ezequias R. da Rocha	2007-03-21 17:37:07	Re: Regular Expressions
Previous Message	Steve Midgley	2007-03-21 17:01:15	Re: Issue with copying data from a text file.