X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id E7FDCD1D286 for ; Fri, 6 Feb 2004 17:34:53 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 99931-07 for ; Fri, 6 Feb 2004 13:34:50 -0400 (AST) Received: from sss.pgh.pa.us (unknown [192.204.191.242]) by svr1.postgresql.org (Postfix) with ESMTP id 0D679D1D2AA for ; Fri, 6 Feb 2004 13:34:48 -0400 (AST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.12.11/8.12.11) with ESMTP id i16HYlFp001530; Fri, 6 Feb 2004 12:34:47 -0500 (EST) To: Shane Wright Cc: pgsql-admin@postgresql.org Subject: Re: hanging for 30sec when checkpointing In-reply-to: <9BB17A7C-58C7-11D8-918E-000393A5890E@shanewright.co.uk> References: <40202216.4010608@shanewright.co.uk> <56DEF96A-5888-11D8-85B9-000393A5890E@shanewright.co.uk> <29986.1076081586@sss.pgh.pa.us> <9BB17A7C-58C7-11D8-918E-000393A5890E@shanewright.co.uk> Comments: In-reply-to Shane Wright message dated "Fri, 06 Feb 2004 17:12:14 +0000" Date: Fri, 06 Feb 2004 12:34:47 -0500 Message-ID: <1529.1076088887@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200402/84 X-Sequence-Number: 12258 Shane Wright writes: > Although, is there any performance implication of not doing checkpoints > very often? (aside from, I assume, that each checkpoint will take > longer and hence saturate available I/O for longer) Mmm, right, I forgot to mention that one, which was a bit silly considering that that was the focus of the discussion. No, infrequent checkpoints won't hurt performance between checkpoints. regards, tom lane