| From: | "Jim C(dot) Nasby" <jnasby(at)pervasive(dot)com> |
|---|---|
| To: | "mcelroy, tim" <tim(dot)mcelroy(at)bostonstock(dot)com> |
| Cc: | 'Pierre LEBRECH' <pierre(dot)lebrech(at)laposte(dot)net>, pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: growth of a postgresql database |
| Date: | 2006-06-07 22:41:54 |
| Message-ID: | 20060607224154.GE45331@pervasive.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
On Wed, Jun 07, 2006 at 12:43:59PM -0400, mcelroy, tim wrote:
> The contrib/dbsize module will accomplish what you want. I use release
> 8.0.1 and it works for me.
>
> It provides the size of the DB, you could cron a job to take readings at
> various times and calculate the growth that way.
If you're on 8.1.x, see also \df pg_*size*
--
Jim C. Nasby, Sr. Engineering Consultant jnasby(at)pervasive(dot)com
Pervasive Software http://pervasive.com work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ludek Finstrle | 2006-06-08 09:18:02 | Maximum text and bytea size? |
| Previous Message | Jim C. Nasby | 2006-06-07 22:39:25 | Re: Standalone Postgres |