X-Original-To: pgsql-hackers-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 57343D1B582 for ; Tue, 3 Feb 2004 10:38:55 +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 51889-07 for ; Tue, 3 Feb 2004 06:38:41 -0400 (AST) Received: from filer (c-24-6-183-218.client.comcast.net [24.6.183.218]) by svr1.postgresql.org (Postfix) with ESMTP id 8042BD1CCA7 for ; Tue, 3 Feb 2004 06:38:40 -0400 (AST) Received: from localhost (localhost [127.0.0.1]) (uid 1000) by filer with local; Tue, 03 Feb 2004 02:38:42 -0800 Date: Tue, 3 Feb 2004 02:38:42 -0800 From: Kevin Brown To: PostgreSQL-development Subject: Re: [pgsql-hackers-win32] Sync vs. fsync during checkpoint Message-ID: <20040203103842.GD2608@filer> Mail-Followup-To: Kevin Brown , PostgreSQL-development References: <16010.1075485076@sss.pgh.pa.us> <200402011333.i11DXmp29214@candle.pha.pa.us> <20040203103605.GC2608@filer> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Content-Disposition: inline In-Reply-To: <20040203103605.GC2608@filer> Organization: Frobozzco International User-Agent: Mutt/1.5.4i X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200402/84 X-Sequence-Number: 49673 Some Moron at sysexperts.com wrote: > At checkpoint time, for each backend list, the bgwriter grabs a write > lock on the list, copies it into its own memory space, truncates the > list, and then releases the read lock. Sigh. I meant to say that it then releases the *write* lock. -- Kevin Brown kevin@sysexperts.com