Re: Performance tips

I think you *should* recreating the indexes and *then* VACUUM ANALYZE.

Regards
Andy
----- Original Message -----
From: "Andrew Perrin" <andrew_perrin(at)unc(dot)edu>
To: "Doug McNaught" <doug(at)wireboard(dot)com>
Cc: <pgsql-general(at)postgresql(dot)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(at)unc(dot)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(at)postgresql(dot)org)