Re: Performance tips
От | Andy Samuel |
---|---|
Тема | Re: Performance tips |
Дата | |
Msg-id | 000b01c199a4$c1db1010$0200a8c0@edpgm обсуждение исходный текст |
Ответ на | Re: Performance tips (Andrew Perrin <andrew_perrin@unc.edu>) |
Список | pgsql-general |
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)
В списке pgsql-general по дате отправления: