On Fri, Jul 2, 2010 at 1:40 AM, Sachin Kumar <Sachin.Ku@xxxxxxxxxxxxxxx> wrote: > At times we have observed that postgres stops responding for several > minutes, even couldn’t fetch the number of entries in a particular table. > One such instance happens when we execute the following steps: Sounds sort of like a checkpoint spike. -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise Postgres Company -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance