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

From Jesper Krogh
Subject Re: Unlogged tables, persistent kind
Date
Msg-id 4DB5B771.2050908@krogh.cc
Whole thread Raw
In response to Re: Unlogged tables, persistent kind  (Leonardo Francalanci <m_lists@yahoo.it>)
Responses Re: Unlogged tables, persistent kind
Re: Unlogged tables, persistent kind
List pgsql-hackers
On 2011-04-25 20:00, Leonardo Francalanci wrote:<br /><span style="white-space: pre;">>> The amount of data loss
ona big table will be <1% of the data<br /> >> loss caused by truncating the whole table.<br /> > <br />
>If that 1% is random (not time/transaction related), usually you'd<br /> > rather have an empty table. In other
words:is a table that is not<br /> > consistant with anything else in the db useful?<br /> > </span><br />
Dependson the application, if it serves for pure caching then it is fully acceptable and way<br /> better than dropping
everything.<br/><br /> -- <br /> Jesper<br /><br /> 

pgsql-hackers by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: Unfriendly handling of pg_hba SSL options with SSL off
Next
From: Peter Eisentraut
Date:
Subject: Re: Unfriendly handling of pg_hba SSL options with SSL off