Re: Restart time - Mailing list pgsql-performance

From Rajesh Kumar Mallah
Subject Re: Restart time
Date
Msg-id a97c77030612052220r9450fh253f302b9b368b0d@mail.gmail.com
Whole thread Raw
In response to Re: Restart time  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-performance


On 12/6/06, Tom Lane <tgl@sss.pgh.pa.us> wrote:
"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.

Thanks for correcting , -m fast  works fine for me.
I shall RTFM..... :)
Regds
mallah.                        regards, tom lane

pgsql-performance by date:

Previous
From: Greg Smith
Date:
Subject: Re: Bad iostat numbers
Next
From: Joost Kraaijeveld
Date:
Subject: Locking in PostgreSQL?