-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On Tue, 22 Jan 2008 17:44:33 -0200 "Luiz K. Matsumura" <luiz@xxxxxxxxxxxxx> wrote: > > > > Joshua D. Drake wrote:Hi, > > If we run the commands "vacumm full analyze" and "reindex table", > this can be considered as equivalent to making a dump / restore in > this case ? Yes. Joshua D. Drake - -- The PostgreSQL Company: Since 1997, http://www.commandprompt.com/ Sales/Support: +1.503.667.4564 24x7/Emergency: +1.800.492.2240 Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate SELECT 'Training', 'Consulting' FROM vendor WHERE name = 'CMD' -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.6 (GNU/Linux) iD8DBQFHlk/LATb/zqfZUUQRAua0AKCsZrWrkf0d+jKUa9KK3aTqzuZTZACbBiD5 z3aIswcgRSwywxlhD+dgSHE= =vdeQ -----END PGP SIGNATURE----- ---------------------------(end of broadcast)---------------------------TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
