[imp] Postgres vacuuming

[Rich Lafferty]

On Wed, Dec 20, 2000 at 11:54:56PM -0500, jlewis@lewis.org (jlewis@lewis.org) wrote:
> On Wed, 20 Dec 2000, Rich Lafferty wrote:
> 
> > > I really doubt we have 3802 users actively using IMP right now.  Isn't
> > > there a garbage collection routine that's supposed to be killing old
> > > sessions?
> > 
> > Yes, there is; but having 3802 open doesn't mean they're not being
> > GC'd, depending on how busy your machine is. Take a look at the
> > 'changed' field; there's a datestamp in there. Right at this moment,
> > the oldest one on our system is 32 hours old.
> 
> The oldest sessions seem to be only 24h old if I'm reading the changed
> field correctly. 

That's the mark I usually consider "normal".

> I checked the logs, and we only have about 1000 unique users logging
> into IMP per day, with maybe double that number of actual logins per
> day.

Unless you're seeing performance problems or are noticing that
sessions aren't expiring, I wouldn't worry about it.

  -Rich

-- 
------------------------------ Rich Lafferty ---------------------------
 Sysadmin/Programmer, Instructional and Information Technology Services
   Concordia University, Montreal, QC                 (514) 848-7625
------------------------- rich@alcor.concordia.ca ----------------------