From: Jean Arnaud <Jean.Arnaud@inrialpes.fr>
To: Rajesh Kumar Mallah <mallah.rajesh@gmail.com>
To: pgsql-performance@postgresql.org
Subject: Re: Restart time
Date: Wed, 06 Dec 2006 09:44:16 +0100
Message-ID: <457682E0.9000206@inrialpes.fr> (raw)
In-Reply-To: <a97c77030612051132h3637c9e2p295bdfb94c3767f1@mail.gmail.com>
References: <4575A78F.5040504@inrialpes.fr>
<8738.1165342609@sss.pgh.pa.us>
<a97c77030612051132h3637c9e2p295bdfb94c3767f1@mail.gmail.com>
Rajesh Kumar Mallah a écrit :
>
>
> On 12/5/06, *Tom Lane* <tgl@sss.pgh.pa.us <mailto:tgl@sss.pgh.pa.us>>
> wrote:
>
> Jean Arnaud <Jean.Arnaud@inrialpes.fr
> <mailto:Jean.Arnaud@inrialpes.fr>> 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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: Jean.Arnaud@inrialpes.fr, mallah.rajesh@gmail.com
Subject: Re: Restart time
In-Reply-To: <457682E0.9000206@inrialpes.fr>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox