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 8D1C9D1C967 for ; Tue, 10 Feb 2004 01:16:21 +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 12019-10 for ; Mon, 9 Feb 2004 21:16:21 -0400 (AST) Received: from sss.pgh.pa.us (unknown [192.204.191.242]) by svr1.postgresql.org (Postfix) with ESMTP id 0272DD1C7F7 for ; Mon, 9 Feb 2004 21:16:18 -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 i1A1GJt9020458; Mon, 9 Feb 2004 20:16:19 -0500 (EST) To: "scott.marlowe" Cc: "Goulet, Dick" , pgsql-admin@postgresql.org Subject: Re: hanging for 30sec when checkpointing In-reply-to: References: Comments: In-reply-to "scott.marlowe" message dated "Mon, 09 Feb 2004 16:49:51 -0700" Date: Mon, 09 Feb 2004 20:16:19 -0500 Message-ID: <20457.1076375779@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200402/125 X-Sequence-Number: 12299 "scott.marlowe" writes: > That said we have a really HUGE (~200 drive) IDE storage array my web / > app server sits on top of. No clue if that thing will reliably work under > a database, and I'm in no hurry to find out. > But since the fsync on WAL is all that seems important, I could always > initlocation a big chunk of it and keep the WAL local and I should be ok. Unfortunately not --- at checkpoint time, the constraint goes the other way. We have to be sure all the data file updates are down to disk before we write a checkpoint record to the WAL log. So you can still get screwed if the data-file drive lies about write completion. regards, tom lane