[OGo-Users] Speed after Backup-Recovery

Christian Naumer users@opengroupware.org
Fri, 15 Jun 2007 08:24:58 +0200


--=-oq9GkFtD08APuWqgx5Vl
Content-Type: text/plain
Content-Transfer-Encoding: quoted-printable

Am Donnerstag, den 14.06.2007, 12:05 -0400 schrieb Adam Tauno Williams:

>=20
> Did you perform an "VACUUM ANALYZE" after the restore?  This is =20
> 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.


But anyway thanks for the answer.

regards






--=-oq9GkFtD08APuWqgx5Vl
Content-Type: application/pgp-signature; name=signature.asc
Content-Description: Dies ist ein digital signierter Nachrichtenteil

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)

iD8DBQBGcjC6q7T2l4/WRbMRAkl6AKCcsHdUdIyiG0TwpWTHfnh2/dDw0wCggoat
MvGI4pi1XtTE2/8hhslpExI=
=a45f
-----END PGP SIGNATURE-----

--=-oq9GkFtD08APuWqgx5Vl--