Re: unlogged tables

"Kevin Grittner" <Kevin.Grittner@wicourts.gov> writes:
> Robert Haas <robertmhaas@gmail.com> wrote:
>> Simon Riggs <simon@2ndquadrant.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