On Tuesday 08 April 2008, [EMAIL PROTECTED] 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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general