Postgres Pro
Downloads
Home   >   mailing lists

Re: [PERFORM] Unlogged tables - Mailing list pgsql-performance

From ldh@laurent-hasson.com
Subject Re: [PERFORM] Unlogged tables
Date
Msg-id BN4PR15MB0547F5864AD9691E31458FE1858B0@BN4PR15MB0547.namprd15.prod.outlook.com
Whole thread Raw
In response to Re: [PERFORM] Unlogged tables  (George Neuner <gneuner2@comcast.net>)
Responses Re: [PERFORM] Unlogged tables  (George Neuner <gneuner2@comcast.net>)
List pgsql-performance
Tree view
Ok, I am not sure. I run Postgres as a service, and when my Windows rebooted after a patch, UNLOGGED tables were cleaned... maybe the patch process in Windows messed something up, I don't know.

From: gneuner2@comcast.net
Sent: August 9, 2017 13:17
To: pgsql-performance@postgresql.org
Subject: Re: [PERFORM] Unlogged tables

#ssc-3048116254049361206 .EmailQuote{margin-left: 1pt;padding-left: 4pt;border-left: rgb(128, 0, 0) 2px solid;}
On Wed, 9 Aug 2017 09:14:48 -0700, Jeff Janes <jeff.janes@gmail.com> wrote:

 >Why doesn't the Windows scheduled shutdown signal postgres to shutdown
 >cleanly and wait for it to do so?  That is what is supposed to happen.

Windows *does* signal shutdown (and sleep and hibernate and wakeup). 
pg_ctl can catch these signals only when running as a service ... it
will not catch any system signals when run as an application.

George


--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance

pgsql-performance by date:

Previous
From: George Neuner
Date:
Subject: Re: [PERFORM] Unlogged tables
Next
From: George Neuner
Date:
Subject: Re: [PERFORM] Unlogged tables