From: | "Adam Lang" <aalang(at)rutgersinsurance(dot)com> |
---|---|
To: | <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: a "huge" table with small rows and culumns |
Date: | 2000-12-18 22:06:34 |
Message-ID: | 000701c0693e$c9fd8da0$330a0a0a@6014cwpza006 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Do you do a lot of updates and/or deletes? If so, you need to VACUUM your
database. When rows are modified, they are not actually deleted. They are
just flagged to be ignored.
Vacuum cleans up the rows.
Adam Lang
Systems Engineer
Rutgers Casualty Insurance Company
http://www.rutgersinsurance.com
----- Original Message -----
From: "Feng Xue" <feng(at)axe(dot)net(dot)au>
To: <pgsql-general(at)postgresql(dot)org>
Sent: Monday, December 18, 2000 4:59 PM
Subject: [GENERAL] a "huge" table with small rows and culumns
> 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
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2000-12-18 22:08:04 | Re: Are arrays broken in 7.0.3? |
Previous Message | Feng Xue | 2000-12-18 21:59:26 | a "huge" table with small rows and culumns |