slow vacuuming...

Hi,

I'm running into major problems with slow vacuuming. I'm running Postgres
6.5.3 on a Sun Enterprise 250 with dual 300 CPUs and 1 GB of ram. Currently
there is only one db/table being used in postgres and it's not that big a data
structure (used for PHP session info with IMP).
------------------------------------

horde=> \d active_sessions;
Table = active_sessions
+----------------------------------+----------------------------------+-------+
| Field | Type | Length|
+----------------------------------+----------------------------------+-------+
| sid | varchar() not null default '' | 32 |
| name | varchar() not null default '' | 32 |
| val | text | var |
| changed | varchar() not null default '' | 14 |
+----------------------------------+----------------------------------+-------+

----------------------------------------------

Each day the DB grows to ~70MB in size and takes upwards of 25 minutes to
vacuum. A 70MB DB doesn't sound too big and 25 minutes is a painfully long time
to wait.

Any ideas?

David

--

David Powicki Network Analyst/Postmaster OIT Network Services
Voice: 413.545.1605 Fax: 413.545.3203 University of Massachusetts
email: dpowicki(at)nic(dot)umass(dot)edu Amherst, MA 01003-4640