On Tuesday 15 Jul 2003 9:09 pm, Joe Maldonado wrote: > Hello, > Vacuum analyze is taking a really long time on a fairly small table and > during the time the vacuum is running all "select * from <the table>;" > seems to hang untill the vacuum is done. Any help on this matter would > be greatly appreciated...
Can you post the output of a "verbose" vacuum analyse? That will tell us what it's up to. -- Richard Huxton ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
