Received: from localhost (maia-4.hub.org [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id C089D9FA0EF for ; Wed, 6 Dec 2006 04:49:32 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-new, port 10024) with ESMTP id 73413-06 for ; Wed, 6 Dec 2006 04:49:27 -0400 (AST) X-Greylist: delayed 00:05:07.774041 by SQLgrey-1.7.4 Received: from mail.libertysurf.net (mx-out.libertysurf.net [213.36.80.91]) by postgresql.org (Postfix) with ESMTP id BAFA19F938C for ; Wed, 6 Dec 2006 04:49:27 -0400 (AST) Received: from [192.168.1.5] (88.123.134.216) by mail.libertysurf.net (7.3.117.3) id 455B2F290056AC05; Wed, 6 Dec 2006 09:43:08 +0100 Message-ID: <457682E0.9000206@inrialpes.fr> Date: Wed, 06 Dec 2006 09:44:16 +0100 From: Jean Arnaud User-Agent: Thunderbird 1.5.0.8 (Windows/20061025) MIME-Version: 1.0 To: Rajesh Kumar Mallah , pgsql-performance@postgresql.org Subject: Re: Restart time References: <4575A78F.5040504@inrialpes.fr> <8738.1165342609@sss.pgh.pa.us> In-Reply-To: Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 8bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=3.485 tagged_above=0 required=5 tests=BAYES_50, DEAR_SOMETHING, SPF_SOFTFAIL X-Spam-Level: *** X-Archive-Number: 200612/108 X-Sequence-Number: 22164 Rajesh Kumar Mallah a écrit : > > > On 12/5/06, *Tom Lane* > > wrote: > > Jean Arnaud > writes: > > Is there a relation between database size and PostGreSQL restart > duration ? > > No. > > > Does anyone now the behavior of restart time ? > > It depends on how many updates were applied since the last checkpoint > before the crash. > > If you're talking about startup of a cleanly-shut-down database, it > should be pretty much constant time. > > > Dear Sir, > > Startup time of a clean shutdown database is constant. But we still > face problem when it comes to shutting down. PostgreSQL waits > for clients to finish gracefully. till date i have never been able to > shutdown > quickly (web application scenerio) and i tend to do pg_ctl -m > immediate stop > mostly. > > > regards, tom lane > Hi Thanks everybody for answers ! To be sure SGBD will stop before a certain time, I use function that is a combination of pg_ctl -m fast to stop most of process cleanly, and after few seconds, I send pg_ctl -m immediate to be shut down immediatly the system if not already stoped. This works pretty well in practice and offers a good compromise between clean and fast shutdown. Cheers -- --- Jean Arnaud --- Projet SARDES --- INRIA Rhône-Alpes