Re: Survey on backing up unlogged tables: help us with PostgreSQL development! - Mailing list pgsql-general

From Glen Parker
Subject Re: Survey on backing up unlogged tables: help us with PostgreSQL development!
Date
Msg-id 4CE33537.3070107@nwlink.com
Whole thread Raw
In response to Re: Survey on backing up unlogged tables: help us with PostgreSQL development!  (Josh Berkus <josh@agliodbs.com>)
Responses Re: Survey on backing up unlogged tables: help us with PostgreSQL development!  (Josh Berkus <josh@agliodbs.com>)
Re: Survey on backing up unlogged tables: help us with PostgreSQL development!  ("Marc Mamin" <M.Mamin@intershop.de>)
List pgsql-general
On 11/16/2010 05:33 PM, Josh Berkus wrote:
>
>> With the current patches, the data survives a restart just fine.
>
> Per -hackers, that's not guarenteed.
>

Which is fine.  If you choose to set a table to nonlogged, that implies
that you accept the risk of corrupted data, or that you don't "get it",
in which case .  It should not however, imply that you want it all
thrown out every so often for no good reason.

If you do wish to have the data tossed out for no good reason every so
often, then there ought to be a separate attribute to control that.  I'm
really having trouble seeing how such behavior would be desirable enough
to ever have the server do it for you, on its terms rather than yours.

-Glen


pgsql-general by date:

Previous
From: Scott Mead
Date:
Subject: Re: Survey on backing up unlogged tables: help us with PostgreSQL development!
Next
From: Josh Berkus
Date:
Subject: Re: Survey on backing up unlogged tables: help us with PostgreSQL development!