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