X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 90F7ED1E15F; Thu, 18 Mar 2004 21:04:58 +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 19940-06; Thu, 18 Mar 2004 17:04:58 -0400 (AST) Received: from sss.pgh.pa.us (unknown [192.204.191.242]) by svr1.postgresql.org (Postfix) with ESMTP id EAD69D1E131; Thu, 18 Mar 2004 17:04:51 -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 i2IL4jXD012316; Thu, 18 Mar 2004 16:04:45 -0500 (EST) To: Bruce Momjian Cc: josh@agliodbs.com, Kurt Roeckx , Mark Kirkwood , pgsql-performance@postgresql.org, PostgreSQL-development Subject: Re: [HACKERS] fsync method checking In-reply-to: <200403182049.i2IKnKK00246@candle.pha.pa.us> References: <200403182049.i2IKnKK00246@candle.pha.pa.us> Comments: In-reply-to Bruce Momjian message dated "Thu, 18 Mar 2004 15:49:20 -0500" Date: Thu, 18 Mar 2004 16:04:45 -0500 Message-ID: <12315.1079643885@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200403/272 X-Sequence-Number: 6128 Bruce Momjian writes: > Well, I wrote the program to allow testing. I don't see a complex test > as being that much better than simple one. We don't need accurate > numbers. We just need to know if fsync or O_SYNC is faster. Faster than what? The thing everyone is trying to point out here is that it depends on context, and we have little faith that this test program creates a context similar to a live Postgres database. regards, tom lane