Re: a "huge" table with small rows and culumns
От | Adam Lang |
---|---|
Тема | Re: a "huge" table with small rows and culumns |
Дата | |
Msg-id | 000701c0693e$c9fd8da0$330a0a0a@6014cwpza006 обсуждение исходный текст |
Ответ на | a "huge" table with small rows and culumns ("Feng Xue" <feng@axe.net.au>) |
Список | 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@axe.net.au> To: <pgsql-general@postgresql.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
В списке pgsql-general по дате отправления: