[imp] high load average with postgresql

Claus cniesen@gmx.net
Tue, 24 Apr 2001 15:00:56 -0500


Thanks Rich for the "VACUUM ANALYZE" hint.  I have been experiencing
significant delays while bringing up the login page and when loggin into
IMP.  Only a hand full of user have been using the new IMP installation so
far.  I guess since I never ran vacuum analyze on the database the access
plan of the database was totally off (probably still thinking it's empty).
Now, getting into IMP is again a breeze.

Matthew, I would reccomend that you try to run vacuum analyze.  I'm fairly
new to postgresql and haven't read up on its performance aspects but if it's
anything like the other databases that I have worked with then the analyze
part analyzes the data in the database and optimizes the access path.  (see
Vacuum Analyze documentation at
http://www.ca.postgresql.org/docs/aw_pgsql_book/node137.html)

Good luck
  Claus