Re: old_snapshot_threshold's interaction with hash index

Поиск
Список
Период
Сортировка
От Kevin Grittner
Тема Re: old_snapshot_threshold's interaction with hash index
Дата
Msg-id CACjxUsOJP0ev35KwcXWz25=ejZNcqs8jmNKvM5hgM_KLXVTCrA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: old_snapshot_threshold's interaction with hash index  (Robert Haas <robertmhaas@gmail.com>)
Ответы Re: old_snapshot_threshold's interaction with hash index  (Amit Kapila <amit.kapila16@gmail.com>)
Список pgsql-hackers
On Tue, May 3, 2016 at 11:48 AM, Robert Haas <robertmhaas@gmail.com> wrote:

> OK, I see now: the basic idea here is that we can't prune based on the
> newer XID unless the page LSN is guaranteed to advance whenever data
> is removed.  Currently, we attempt to limit bloat in non-unlogged,
> non-catalog tables.  You're saying we can instead attempt to limit
> bloat only in non-unlogged, non-catalog tables without hash indexes,
> and that will fix this issue.  Am I right?

As a first cut, something like the attached.

--
Kevin Grittner
EDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

Вложения

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

Предыдущее
От: "D'Arcy J.M. Cain"
Дата:
Сообщение: Update to contrib/chkpass
Следующее
От: Kevin Grittner
Дата:
Сообщение: Re: 9.5.2: "sql" as reserved word?