[OGo-Users] Speed after Backup-Recovery

[Adam Tauno Williams]

> recently I had to recover our database from a backup SQL dump.   
> Everything went
> fine. However the search-speed has gone down considerably (sometimes 2-3 min
> until a result is displayed). When somebody searches ogo-webui  goes to 100%
> CPU. Postmaster doesn't use up much CPU while this happens.
> Anyone got an idea?

Did you perform an "VACUUM ANALYZE" after the restore?  This is  
standard required practice in PostgreSQL.

And you should be performing "VACUUM ANALYZE" at some regular interval  
(daily).  An ideal task for cron.