Received: from magus.postgresql.org (magus.postgresql.org [87.238.57.229]) by mail.postgresql.org (Postfix) with ESMTP id 7C6D97ACC83 for ; Wed, 8 Aug 2012 13:23:39 -0300 (ADT) Received: from sss.pgh.pa.us ([66.207.139.130]) by magus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1Sz92l-0000Rd-A2 for pgsql-sql@postgresql.org; Wed, 08 Aug 2012 16:23:38 +0000 Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.14.5/8.14.5) with ESMTP id q78GNMc4012759; Wed, 8 Aug 2012 12:23:22 -0400 (EDT) From: Tom Lane To: Wayne Cuddy cc: PostgreSQL Subject: Re: fsync debug messages in pgsql logs In-reply-to: <20120808154416.GE16371@slacker.ja10629.home> References: <20120808154416.GE16371@slacker.ja10629.home> Comments: In-reply-to Wayne Cuddy message dated "Wed, 08 Aug 2012 11:44:16 -0400" Date: Wed, 08 Aug 2012 12:23:22 -0400 Message-ID: <12758.1344443002@sss.pgh.pa.us> X-Pg-Spam-Score: -1.9 (-) X-Archive-Number: 201208/10 X-Sequence-Number: 36781 Wayne Cuddy writes: > I'm seeing this in my PGSQL logs, is this something to be concerned > about? I know the file system it sits on is reliable and the DB appears > to run with fine, additionally the log indicates it's a debug message. I > did some google searches and didn't find much. > When I examine the file system file by these names to not exist. If it only complains once per file name, this is expected behavior when somebody drops a table just before the checkpoint mechanism tries to fsync it. (If the failure were to repeat, then it might be something more interesting.) It does seem a bit odd that only fsm files are being complained of, though. What PG version is that exactly? regards, tom lane