On Tuesday 08 April 2008, mljv(at)planwerk6(dot)de 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