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@nic.umass.edu             Amherst, MA 01003-4640