X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 713A4528FF for ; Fri, 17 Jun 2005 03:25:46 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 22124-09 for ; Fri, 17 Jun 2005 06:25:36 +0000 (GMT) Received: from zproxy.gmail.com (zproxy.gmail.com [64.233.162.201]) by svr1.postgresql.org (Postfix) with ESMTP id A636252836 for ; Fri, 17 Jun 2005 03:25:35 -0300 (ADT) Received: by zproxy.gmail.com with SMTP id 12so266618nzp for ; Thu, 16 Jun 2005 23:25:33 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:reply-to:to:subject:mime-version:content-type:content-transfer-encoding:content-disposition; b=gf8R1HX/BVauxZkpjhdBRGlwMZMDA3/v9heY5lOEqx16cprynL3xUCMirUuFpxLrtNM2r02cB4lQySQLpBJ3vlyUiF1D5OetJDEsD8pY/AkwrWLMTLCZLL71Rhm2xgHb2lrsAMrjmadMDeZerWYSA5+Cg3q+6eB+wTkWFljo81w= Received: by 10.36.222.75 with SMTP id u75mr1118569nzg; Thu, 16 Jun 2005 23:25:33 -0700 (PDT) Received: by 10.36.68.10 with HTTP; Thu, 16 Jun 2005 23:25:33 -0700 (PDT) Message-ID: <674d1f8a0506162325889a0b4@mail.gmail.com> Date: Fri, 17 Jun 2005 11:55:33 +0530 From: Gourish Singbal Reply-To: Gourish Singbal To: pgsql-admin Subject: checkpoint are too frequent Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.084 tagged_above=0 required=5 tests=AWL, RCVD_BY_IP X-Spam-Level: X-Archive-Number: 200506/122 X-Sequence-Number: 17877 Hi 2005-06-16 23:22:20 LOG: 00000: checkpoints are occurring too frequently (1 seconds apart) HINT: Consider increasing the configuration parameter "checkpoint_segments= ". Is this bad on the hard disk ?. or on the postgresql server?. Can i change the checkpoints which is currently 10 to someting like 50 during FULL vacumming ?. and reload the postgresql server during the process?. --=20 Best, Gourish Singbal