hi,

I have been a postgres user for serveral months. But recently I find a "mysterious" 
things
in my /usr/local/pgsql/data/base/The_Database_Name/The_table_name.

In a particular table name "fred" there are only 50 rows and 13 columns. The column 
types are int,
float, varchar, where
varchar's size is restricted to 50. But its size of
/usr/local/pgsql/data/base/The_Database_Name/fred is more than 20M,  and it keeps 
growing while the
rows number is still 50.

I am using linux (slackware), with postgres as database, Jonas as EJB server, Tomcat 
and apache
as webserver, the "fred" table is constantly looked up (no updated) by the user.

Thanks in advance for any suggestions.

Cheers

Feng

Reply via email to