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