On Mon, Apr 30, 2012 at 9:55 AM, Wolfgang Wilhelm
> Just for the ones interested in a view on another turf:
> In Oracle "shutdown immediate" is the fastest _clean_ shutdown and "shutdown
> abort" is equal to "shutdown immediate" in PG.
> The other modes are called "shutdown normal" and "shutdown transactional".
Though the behaviour users see is quite different. In Oracle the
fastest clean shutdown still requires rolling back transactions which
can take a long time. In Postgres rolling back transactions is
instantaneous so a shutdown immediate will appear to behave like a
shutdown abort in Oracle in that it will always run fast even if the
effect on the database is different.
In response to
pgsql-hackers by date
|Next:||From: Alvaro Herrera||Date: 2012-04-30 13:02:33|
|Subject: Re: [PATCH] Allow breaking out of hung connection attempts|
|Previous:||From: Atri Sharma||Date: 2012-04-30 12:00:07|
|Subject: Re: Future In-Core Replication|