Re: [PERFORM] Unlogged tables

2017-08-09 Thread George Neuner
On Wed, 9 Aug 2017 09:14:48 -0700, Jeff Janes 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).

Re: [PERFORM] Unlogged tables

2017-08-09 Thread l...@laurent-hasson.com
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: gneun...@comcast.net Sent: August 9, 2017 13:17 To: pgsql-performance@postgresql.org Subject:

Re: [PERFORM] Unlogged tables

2017-08-09 Thread l...@laurent-hasson.com
Sent from my BlackBerry - the most secure mobile device From: gneun...@comcast.net Sent: August 9, 2017 14:52 To: l...@laurent-hasson.com Cc: pgsql-performance@postgresql.org Subject: Re: [PERFORM] Unlogged tables Please don't top post. On 8/9/2017 2:30 PM,

Re: [PERFORM] Unlogged tables

2017-08-09 Thread Michael Paquier
On Wed, Aug 9, 2017 at 5:20 AM, l...@laurent-hasson.com wrote: > We have a fairly large static dataset that we load into Postgres. We made > the tables UNLOGGED and saw a pretty significant performance improvement for > the loading. This was all fantastic until the server

Re: [PERFORM] Unlogged tables

2017-08-09 Thread George Neuner
Please don't top post. On 8/9/2017 2:30 PM, l...@laurent-hasson.com wrote: > On 8/9/2017 2:17 PM, gneun...@comcast.net wrote: >> On Wed, 9 Aug 2017 09:14:48 -0700, Jeff Janes wrote: >> Why doesn't the Windows scheduled shutdown signal postgres to shutdown >> cleanly and

Re: [PERFORM] Unlogged tables

2017-08-09 Thread Jeff Janes
On Tue, Aug 8, 2017 at 8:20 PM, l...@laurent-hasson.com < l...@laurent-hasson.com> wrote: > Hello, > > > We have a fairly large static dataset that we load into Postgres. We made > the tables UNLOGGED and saw a pretty significant performance improvement > for the loading. This was all fantastic

Re: [PERFORM] Unlogged tables

2017-08-09 Thread Stephen Frost
David, all, * David G. Johnston (david.g.johns...@gmail.com) wrote: > On Wed, Aug 9, 2017 at 3:39 AM, Michael Paquier > wrote: > > > This triggers a table rewrite and makes sure that all the data gets > > WAL-logged. The cost to pay for durability. That's not

Re: [PERFORM] Unlogged tables

2017-08-09 Thread David G. Johnston
On Wed, Aug 9, 2017 at 3:39 AM, Michael Paquier wrote: > This triggers a table rewrite and makes sure that all the data gets > WAL-logged. The cost to pay for durability. > > > Is there a way to get my cake and eat it too? > > Not completely. Making data durable will