On Tue, Feb 8, 2011 at 3:08 PM, Greg Smith <greg@xxxxxxxxxxxxxxx> wrote: > Scott Marlowe wrote: >> >> Are there any settings in postgresql.conf that would make it unsafe to >> use -m immediate? >> > > Two concerns: > > -Clients will be killed without any review, and data related to them lost > > -The server will have to go through recovery to start back up again, which > could potentially take a long time. If you manage a successful shutdown > that doesn't happen. > > Shouldn't be unsafe, just has those issues. Good, I was kinda worried about full_page_writes being off or fsync or something like that being a problem. -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
