[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_________