-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
>>>>> "Ambar" == Ambar Roy <[EMAIL PROTECTED]> writes:
Ambar> [snip].
Ambar> So does VACUUM require the database to be taken offline? Or
Ambar> was this an issue with older versions of pgSQL? As I don't
Ambar> see the Geocrawler under maintainence pages nowadays. There
Ambar> was a time when I only saw the under maintainence page at
Ambar> Geocrawler!!
Haven't used the newer versions of PostgreSQL, but with 7.2.3 (with
which I'm familiar) VACUUM doesn't require any special handling, while
VACUUM FULL locks up the database until the command completes. VACUUM
FULL also doesn't run while the database is in use, e.g. when
transactions are pending.
Regards,
- -- Raju
- --
Raj Mathur [EMAIL PROTECTED] http://kandalaya.org/
GPG: 78D4 FC67 367F 40E2 0DD5 0FEF C968 D0EF CC68 D17F
It is the mind that moves
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.0.7 (GNU/Linux)
Comment: Processed by Mailcrypt 3.5.6 and Gnu Privacy Guard <http://www.gnupg.org/>
iD8DBQE/kYhuyWjQ78xo0X8RArHKAKCMHfW3tm8oo+Z4y3Cy2vV1R5TQtwCeO/Rh
0MCKClGa72LhpXlaXmcbBVI=
=A7mB
-----END PGP SIGNATURE-----
_______________________________________________
ilugd mailing list
[EMAIL PROTECTED]
http://frodo.hserus.net/mailman/listinfo/ilugd
