Re: the XID question

Поиск
Список
Период
Сортировка
От Kevin Grittner
Тема Re: the XID question
Дата
Msg-id 4D3816DB02000025000398DF@gw.wicourts.gov
обсуждение исходный текст
Ответ на Re: the XID question  ("Charles.Hou" <givemeegn@gmail.com>)
Ответы Re: the XID question  (Robert Haas <robertmhaas@gmail.com>)
Список pgsql-performance
"Charles.Hou" <givemeegn@gmail.com> wrote:

> my postgresql version is 8.1.3

Ouch!  That's getting pretty old; I hope it's not on Windows.

http://wiki.postgresql.org/wiki/PostgreSQL_Release_Support_Policy

http://www.postgresql.org/about/news.865

> you means the newer version has a virtual transaction ID. and
> what's the maxmium of this virtual id,  also 4 billion ?
> should i also vacuum freeze the virtual id in the new version when
> it reached the 4 billion?

The point is to reduce maintenance, not increase it -- you don't
need to worry about cleaning these up.

-Kevin

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

Предыдущее
От: Cédric Villemain
Дата:
Сообщение: Re: anti-join chosen even when slower than old plan
Следующее
От: Madhu Ramachandran
Дата:
Сообщение: copy command and blobs