Re: table size - Mailing list pgsql-general

From David Blood
Subject Re: table size
Date
Msg-id 005501c1c568$c5098290$0100a8c0@david2
Whole thread Raw
In response to Re: table size  (Doug McNaught <doug@wireboard.com>)
Responses Re: table size  ("ccruise" <ccruise@rvamerica.com>)
List pgsql-general
Yes

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

"David Blood" <davidjblood@yahoo.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


pgsql-general by date:

Previous
From: andrew.clark@sge.net
Date:
Subject: Have problems with 7.1 -> 7.2 upgrade
Next
From: "Gaston Micheri"
Date:
Subject: Odbc, postgresql and disconnected recordsets