Re: [PERFORM] Unlogged tables
| От | ldh@laurent-hasson.com |
|---|---|
| Тема | Re: [PERFORM] Unlogged tables |
| Дата | |
| Msg-id | BN4PR15MB0547F5864AD9691E31458FE1858B0@BN4PR15MB0547.namprd15.prod.outlook.com обсуждение исходный текст |
| Ответ на | Re: [PERFORM] Unlogged tables (George Neuner <gneuner2@comcast.net>) |
| Ответы |
Re: [PERFORM] Unlogged tables
|
| Список | pgsql-performance |
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 |
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
>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 по дате отправления: