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 2518352CA6 for ; Tue, 26 Jul 2005 19:22:54 -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 41339-04 for ; Tue, 26 Jul 2005 22:22:52 +0000 (GMT) Received: from cmailm3.svr.pol.co.uk (cmailm3.svr.pol.co.uk [195.92.193.19]) by svr1.postgresql.org (Postfix) with ESMTP id 9062B52C86 for ; Tue, 26 Jul 2005 19:22:51 -0300 (ADT) Received: from modem-2163.llama.dialup.pol.co.uk ([217.135.184.115] helo=192.168.0.102) by cmailm3.svr.pol.co.uk with esmtp (Exim 4.41) id 1DxXp7-0003Dm-W3 for pgsql-admin@postgresql.org; Tue, 26 Jul 2005 23:22:54 +0100 Subject: Checkpoint segments From: Simon Riggs To: pgsql-admin@postgresql.org Content-Type: text/plain Organization: 2nd Quadrant Date: Tue, 26 Jul 2005 23:22:34 +0100 Message-Id: <1122416554.3670.109.camel@localhost.localdomain> Mime-Version: 1.0 X-Mailer: Evolution 2.0.2 (2.0.2-3) Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.053 tagged_above=0 required=5 tests=AWL, FORGED_RCVD_HELO X-Spam-Level: X-Archive-Number: 200507/211 X-Sequence-Number: 18267 If I have a system that writes out one WAL file every 5 minutes, and I have these settings: checkpoint_timeout = 3329 checkpoint_segments = 1000 (parameters checked as valid via pg_settings) How many WAL files would you expect to see in pg_xlog, once the system has reached steady state? I would expect checkpoints to occur every 3329 seconds, giving on average 10-11 WAL files per checkpoint. So, I expect to find up to 23 WAL files in the pg_xlog directory. I have 308 files in pg_xlog, which remains constant. The oldest file time is approximately 24 hours ago. Am I just tired, or is that a little strange? pg 7.4.6 Best Regards, Simon Riggs