"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