Is: REINDEX DATABASE blah
supposed to rebuild all indices in the database, or must you specify each table individualy? (I'm asking because I just tried it and it only did system tables) Alex Turner netEconomist On 4/21/05, Josh Berkus <josh@agliodbs.com> wrote: > Bill, > > > What about if an out-of-the-ordinary number of rows > > were deleted (say 75% of rows in the table, as opposed > > to normal 5%) followed by a 'VACUUM ANALYZE'? Could > > things get out of whack because of that situation? > > Yes. You'd want to run REINDEX after and event like that. As you should now. > > -- > Josh Berkus > Aglio Database Solutions > San Francisco > > ---------------------------(end of broadcast)--------------------------- > TIP 6: Have you searched our list archives? > > http://archives.postgresql.org > ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
