On 15 Jul 2003, 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... >
You probably need to question why the vacuum analyse is taking a long time on a small table. Not because it isn't annoying for your selects to appear to hang but because it shouldn't take a long time to analyze a small table so there's probably something more significant wrong than slow/blocked queries. -- Nigel J. Andrews ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend