Re: unlogged tables

Поиск
Список
Период
Сортировка
От Simon Riggs
Тема Re: unlogged tables
Дата
Msg-id 1291821547.2872.920.camel@ebony
обсуждение исходный текст
Ответ на Re: unlogged tables  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: unlogged tables  (Robert Haas <robertmhaas@gmail.com>)
Список pgsql-hackers
On Tue, 2010-12-07 at 13:17 -0500, Tom Lane wrote:
> Robert Haas <robertmhaas@gmail.com> writes:
> > I'm also going to go through and change all instances of the word
> > "unlogged" to "volatile", per previous discussion.  If this seems like
> > a bad idea to anyone, please object now rather than afterwards.
> 
> Hm... I thought there had been discussion of a couple of different
> flavors of table volatility.  Is it really a good idea to commandeer
> the word "volatile" for this particular one?

Note that DB2 uses the table modifier VOLATILE to indicate a table that
has a widely fluctuating table size, for example a queue table. It's
used as a declarative optimizer hint. So the term has many possible
meanings.

Prefer UNLOGGED or similar descriptive term.

-- Simon Riggs           http://www.2ndQuadrant.com/books/PostgreSQL Development, 24x7 Support, Training and Services



В списке pgsql-hackers по дате отправления:

Предыдущее
От: Simon Riggs
Дата:
Сообщение: Hot Standby btree delete records and vacuum_defer_cleanup_age
Следующее
От: Simon Riggs
Дата:
Сообщение: Re: Spread checkpoint sync