[imp] Postgres vacuuming

jlewis@lewis.org jlewis@lewis.org
Wed, 20 Dec 2000 22:55:42 -0500 (EST)


On Wed, 20 Dec 2000, Rich Lafferty wrote:

> Realized that we hadn't run VACUUM or VACUUM ANALYZE, *ever*.
> 
> Ran VACUUM, which took ten minutes (!).
> 
> Now, "SELECT count(*) FROM active_sessions" takes under a second, and
> IMP isn't running slowly.

What is VACUUM?  Is it pg specific?

mysql> SELECT count(*) FROM active_sessions;
+----------+
| count(*) |
+----------+
|     3802 |
+----------+
1 row in set (0.03 sec)

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?


----------------------------------------------------------------------
 Jon Lewis *jlewis@lewis.org*|  I route
 System Administrator        |  therefore you are
 Atlantic Net                |  
_________ http://www.lewis.org/~jlewis/pgp for PGP public key_________