Re: unlogged tables - Mailing list pgsql-hackers

From Josh Berkus
Subject Re: unlogged tables
Date
Msg-id 4CE301BA.4030801@agliodbs.com
Whole thread Raw
In response to Re: unlogged tables  (Peter Eisentraut <peter_e@gmx.net>)
Responses Re: unlogged tables
Re: unlogged tables
List pgsql-hackers
On 11/16/10 2:08 PM, Peter Eisentraut wrote:
> On tis, 2010-11-16 at 14:00 -0800, Josh Berkus wrote:
>> It seems to me
>> that most people using unlogged tables won't want to back them up ...
>> especially since the share lock for pgdump will add overhead for the
>> kinds of high-volume updates people want to do with unlogged tables.
> 
> Or perhaps most people will want them backed up, because them being
> unlogged the backup is the only way to get them back in case of a crash?

Yeah, hard to tell, really.   Which default is less likely to become a
foot-gun?

Maybe it's time for a survey on -general.

--                                  -- Josh Berkus                                    PostgreSQL Experts Inc.
                        http://www.pgexperts.com
 


pgsql-hackers by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: unlogged tables
Next
From: "Joshua D. Drake"
Date:
Subject: Re: unlogged tables