Re: Unlogged tables, persistent kind - Mailing list pgsql-hackers

From Leonardo Francalanci
Subject Re: Unlogged tables, persistent kind
Date
Msg-id 30910.44583.qm@web29008.mail.ird.yahoo.com
Whole thread Raw
In response to Unlogged tables, persistent kind  (Simon Riggs <simon@2ndQuadrant.com>)
Responses Re: Unlogged tables, persistent kind  (Jesper Krogh <jesper@krogh.cc>)
Re: Unlogged tables, persistent kind  (Simon Riggs <simon@2ndQuadrant.com>)
List pgsql-hackers
> The amount of data loss on a big
> table will be <1% of the data loss
>caused by truncating the whole table.

If that 1% is random (not time/transaction related), usually you'd rather have an empty table. In other words: is a
tablethat is not consistant with anything else in the db useful? 


pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: Foreign table permissions and cloning
Next
From: Tom Lane
Date:
Subject: Re: Foreign table permissions and cloning