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