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 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers