On Tuesday 08 April 2008, mljv@xxxxxxxxxxxx wrote: > The problem is that we have peaktimes were everything is running fine. It > has something to do with the vacuum process running. To simplify my > problem: > > - I run vaccum analyze concurrently with some few user queries: slows > down to a crawl after vacuum is finished. > > - if i run it while no user is connected, everything runs fine > afterwards. > > It has something to do with the vacuum analyze process. It's probably running the machine into swap. Check swap usage and disk I/O when it happens. -- Alan
