X-Original-To: pgsql-admin-postgresql.org@postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id C39F99F9FE3 for ; Thu, 22 Jun 2006 07:42:27 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 56865-04 for ; Thu, 22 Jun 2006 07:42:16 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from ls405.htnet.hr (ls405.t-com.hr [195.29.150.135]) by postgresql.org (Postfix) with ESMTP id 3B0FF9F9ED6 for ; Thu, 22 Jun 2006 07:42:16 -0300 (ADT) Received: from ls401.t-com.hr (ls401.t-com.hr [195.29.150.236]) by ls405.htnet.hr (Postfix) with ESMTP id 0CDC8143B64; Thu, 22 Jun 2006 12:42:14 +0200 (CEST) Received: from ls401.t-com.hr (localhost.localdomain [127.0.0.1]) by ls401.t-com.hr (Qmlai) with ESMTP id 0BCE5E38E3; Thu, 22 Jun 2006 12:42:14 +0200 (CEST) X-Envelope-Sender: mario.splivalo@mobart.hr X-Envelope-Sender: mario.splivalo@mobart.hr Received: from 83-131-54-80.adsl.net.t-com.hr (83-131-54-80.adsl.net.t-com.hr [83.131.54.80])by ls401.t-com.hr (Qmali) with ESMTP id A59743801E;Thu, 22 Jun 2006 12:42:13 +0200 (CEST) Subject: Re: archive_log command... From: Mario Splivalo Reply-To: mario.splivalo@mobart.hr To: Bruce Momjian Cc: pgsql-admin@postgresql.org In-Reply-To: <200606220130.k5M1U3G09804@momjian.us> References: <200606220130.k5M1U3G09804@momjian.us> Content-Type: text/plain Organization: Mob-Art Date: Thu, 22 Jun 2006 12:41:39 +0200 Message-Id: <1150972899.10531.0.camel@localhost.localdomain> Mime-Version: 1.0 X-Mailer: Evolution 2.6.1 Content-Transfer-Encoding: 7bit X-imss-version: 2.040 X-imss-result: Passed X-imss-scores: Clean:99.90000 C:2 M:4 S:5 R:5 X-imss-settings: Baseline:1 C:1 M:1 S:1 R:1 (0.0000 0.0000) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200606/192 X-Sequence-Number: 22154 On Wed, 2006-06-21 at 21:30 -0400, Bruce Momjian wrote: > Mario Splivalo wrote: > > Can I force archiving of the WAL files using CHECKPOINT statement? My > > checkpoing_segments is set to 32, but still archive_command is beeing > > called up only every 45 minutes or so. Is there a way to speed this up a > > bit? (I'd love to have it around 10 minutes, so I can have almost-live > > backed-up server). > > No, but it is on the TODO list. > So, the only thing I could to is to reduce checkpoint_segments? Mario