Re: table size

I have postgres 7.2.  I have a web page that uses coldfusion scripting to
insert the contents of a form into a table.  One of the items on the form is
a place to put comments.  To insert the data into the table, I used cold
fusion's url encode which converts all not alpha text into their hex values.
IE: spaces gets converted to %20 and so on.  It seemed like a good idea to
avoid having to attempted to catch for ' or " that may be entered into the
comment until I got an error saying the query string was too long.  Is there
a limit in postgres on how long the query string can be?

Thank You
Charles Cruise
System Administrator
RV America OnLine
www.rvamerica.com
408 E. Southern Avenue
Tempe, Az  85282
480-784-4771

-----Original Message-----
From: pgsql-general-owner@postgresql.org
[mailto:pgsql-general-owner@postgresql.org]On Behalf Of David Blood
Sent: Wednesday, March 06, 2002 4:44 PM
To: pgsql-general@postgresql.org
Subject: Re: [GENERAL] table size


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


---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org