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 C4BC7D1D30E for ; Fri, 6 Feb 2004 18:34:39 +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 31498-07 for ; Fri, 6 Feb 2004 14:34:38 -0400 (AST) Received: from ecintweb.eldocomp.com (smtp.eldocomp.com [205.159.99.8]) by svr1.postgresql.org (Postfix) with ESMTP id 298F2D1D2D0 for ; Fri, 6 Feb 2004 14:34:36 -0400 (AST) Received: by ecintweb.eldocomp.com with XWall v3.28l ; Fri, 6 Feb 2004 11:34:20 -0700 From: Naomi Walker To: "pgsql-admin@postgresql.org" Subject: Recycled Log Files Date: Fri, 6 Feb 2004 11:34:18 -0700 X-Assembled-By: XWall v3.28l X-Mailer: QUALCOMM Windows Eudora Version 5.1 Message-ID: <5.1.0.14.2.20040206112559.034f5a20@imap.eldocomp.com> Mime-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200402/85 X-Sequence-Number: 12259 We are running Postgres 7.3.4 on Solaris 6 on an E3500. I noticed the=20 following messages, and attempted to remedy the situation by upping our=20 wal_buffers to 64, thinking we might need more room. wal_files seems to=20 have gone away in this version or I would have increased that as well. I'm still seeing the same thing in the logs. Show all in psql shows=20 wal_beffers has been increased. Is this even a problem? If so, which know do I really need to tweak? Thank you, Naomi 2004-02-05 16:48:16 LOG: recycled transaction log file 0000000600000029 2004-02-05 16:48:27 LOG: recycled transaction log file 000000060000002A 2004-02-05 16:48:27 LOG: recycled transaction log file 000000060000002B 2004-02-05 16:48:27 LOG: recycled transaction log file 000000060000002C 2004-02-05 16:48:38 LOG: recycled transaction log file 000000060000002D 2004-02-05 16:48:38 LOG: recycled transaction log file 000000060000002E 2004-02-05 16:48:38 LOG: recycled transaction log file 000000060000002F ---------------------------------------------------------------------------= ---------------------------------------------- Naomi Walker Chief Information Officer Eldorado Computing, Inc. nwalker@eldocomp.com 602-604-3100 ---------------------------------------------------------------------------= ---------------------------------------------- Forget past mistakes. Forget failures. Forget everything except what you're= =20 going to do now and do it. - William Durant, founder of General Motors ---------------------------------------------------------------------------= --------------------------------------------- -- CONFIDENTIALITY NOTICE -- This message is intended for the sole use of the individual and entity to w= hom it is addressed, and may contain information that is privileged, confid= ential and exempt from disclosure under applicable law. If you are not the = intended addressee, nor authorized to receive for the intended addressee, y= ou are hereby notified that you may not use, copy, disclose or distribute t= o anyone the message or any information contained in the message. If you ha= ve received this message in error, please immediately advise the sender by = reply email, and delete the message. Thank you.