Re: table size

From: "David Blood" <davidjblood(at)yahoo(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Re: table size
Date: 2002-03-06 23:43:50
Message-ID: 005501c1c568$c5098290$0100a8c0@david2
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Yes

-----Original Message-----
From: pgsql-general-owner(at)postgresql(dot)org
[mailto:pgsql-general-owner(at)postgresql(dot)org] On Behalf Of Doug McNaught
Sent: Wednesday, March 06, 2002 7:41 AM
To: David Blood
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: [GENERAL] table size

"David Blood" <davidjblood(at)yahoo(dot)com> writes:

> I have noticed that our database is growing in size about 10 MB day.
I
> am not sure where this growth is coming from. Is there an easy way to
> check the size of all of the tables?

Are you running VACUUM regularly?

-Doug
--
Doug McNaught Wireboard Industries http://www.wireboard.com/

Custom software development, systems and network consulting.
Java PostgreSQL Enhydra Python Zope Perl Apache Linux BSD...

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/users-lounge/docs/faq.html

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Gaston Micheri 2002-03-06 23:48:36 Odbc, postgresql and disconnected recordsets
Previous Message andrew.clark 2002-03-06 23:40:32 Have problems with 7.1 -> 7.2 upgrade