Re: Restart time - Mailing list pgsql-performance

From Tom Lane
Subject Re: Restart time
Date
Msg-id 10203.1165347590@sss.pgh.pa.us
Whole thread Raw
In response to Re: Restart time  ("Rajesh Kumar Mallah" <mallah.rajesh@gmail.com>)
Responses Re: Restart time  ("Rajesh Kumar Mallah" <mallah.rajesh@gmail.com>)
List pgsql-performance
"Rajesh Kumar Mallah" <mallah.rajesh@gmail.com> writes:
> 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.

RTFM ... you should be using -m fast not -m immediate.  -m immediate
is for emergency situations not routine.

            regards, tom lane

pgsql-performance by date:

Previous
From: "Rajesh Kumar Mallah"
Date:
Subject: Re: Restart time
Next
From: Stefan Kaltenbrunner
Date:
Subject: Re: Performance of ORDER BY