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).
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:
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,
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
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
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
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
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