X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 552DD9DC993 for ; Tue, 27 Dec 2005 18:44:15 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 01089-06 for ; Tue, 27 Dec 2005 18:44:14 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by postgresql.org (Postfix) with ESMTP id F12589DCA63 for ; Tue, 27 Dec 2005 18:44:09 -0400 (AST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.13.1/8.13.1) with ESMTP id jBRMiA56004551; Tue, 27 Dec 2005 17:44:10 -0500 (EST) To: "Jim C. Nasby" cc: Martijn van Oosterhout , Benjamin Arai , pgsql-admin@postgresql.org, pgsql-general@postgresql.org Subject: Re: [GENERAL] Running with fsync=off In-reply-to: <20051227211238.GQ72143@pervasive.com> References: <43AA5607.20000@cs.ucr.edu> <20051222080759.GB21783@svana.org> <23560.1135270033@sss.pgh.pa.us> <20051227211238.GQ72143@pervasive.com> Comments: In-reply-to "Jim C. Nasby" message dated "Tue, 27 Dec 2005 15:12:38 -0600" Date: Tue, 27 Dec 2005 17:44:10 -0500 Message-ID: <4550.1135723450@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.049 required=5 tests=[AWL=0.049] X-Spam-Score: 0.049 X-Spam-Level: X-Archive-Number: 200512/330 X-Sequence-Number: 20050 "Jim C. Nasby" writes: > How would syncsync differ from sync;sync? The second > case will wait for the first command to return, or is there a race > condition that's reduced by typing by hand? The actual runtime of the "sync" program is epsilon, because it doesn't wait for all the I/O to happen. The entire reason for the custom is that the I/O is going on while you type the second "sync". And yes, it's a race condition. regards, tom lane