[OGo-Users] Speed after Backup-Recovery

Adam Tauno Williams users@opengroupware.org
Fri, 15 Jun 2007 07:00:45 -0400


> > Did you perform an "VACUUM ANALYZE" after the restore?  This is  
> > standard required practice in PostgreSQL.
> Did that and a re-index but it still is slow.  Could it be that using
> acl's is having this kind of impact? I think I read in the list that
> acl's make things slow. I didn't expect it to be this dramatic.

No, we have ACLs (lots of them), and have no performance issues.

Did you change PostgreSQL versions or possibly revert to a default
postgresql.conf file?