On Tue, Aug 29, 2017 at 5:17 PM, Gersner <gersner@xxxxxxxxx> wrote: > Is there a reliable way to distinguish between an empty unlogged table to an > unlogged table which has been truncated due to a crash? Why do you want to make such a difference? At the beginning of a crash recovery all the, the existing relation files of unlogged tables are all removed, and replaced by the init forknum which represents their initial state. You can see by yourself ResetUnloggedRelations & friends in reinit.c. -- Michael -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
