I think you *should* recreating the indexes and *then* VACUUM ANALYZE.
Regards
Andy
----- Original Message -----
From: "Andrew Perrin" <andrew_perrin@unc.edu>
To: "Doug McNaught" <doug@wireboard.com>
Cc: <pgsql-general@postgresql.org>
Sent: Thursday, January 10, 2002 12:14 PM
Subject: Re: [GENERAL] Performance tips
> Never mind - while I was writing the last message the vacuum analyze
> ended. No messages from vacuum analyze (just the VACUUM
> acknowledgement). I'm recreating the one user-created index (the rest are
> based on serials) now and will re-test queries.
>
> Thanks for everyone's help.
>
> ----------------------------------------------------------------------
> Andrew J Perrin - andrew_perrin@unc.edu - http://www.unc.edu/~aperrin
> Assistant Professor of Sociology, U of North Carolina, Chapel Hill
> 269 Hamilton Hall, CB#3210, Chapel Hill, NC 27599-3210 USA
>
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
