Re: unlogged tables

"Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov> writes:
> Robert Haas <robertmhaas(at)gmail(dot)com> wrote:
>> Simon Riggs <simon(at)2ndquadrant(dot)com> wrote:
>>> Note that DB2 uses the table modifier VOLATILE to indicate a
>>> table that has a widely fluctuating table size, for example a
>>> queue table.

>> the fact that DB2 uses that word to mean something entirely
>> different is certainly a bit awkward

> It would be especially awkward should someone port their DB2
> database to PostgreSQL without noticing the semantic difference, and
> then find their data missing.

Not to mention that DB2 syntax tends to appear in the standard a few
years later.

>> so maybe we should reconsider.

> +1 for choosing terminology without known conflicts with other
> significant products.

Yeah. Given this info I'm strongly inclined to stick with UNLOGGED.

regards, tom lane